deprecated SQL Type for CREATE/ALTER in MySQL

Martial Boniou <[email protected]> Fri, 6 Jan 2012 13:15:05 +0100

Newsgroups	gmane.lisp.clsql.general
Message-ID	<[email protected]>

Hi guys,

I recently installed clsql 6.1.1 (December 2011 version) on SBCL 1.0.53 for OSX 10.6. Everything works well but I had to change this in sql/expressions.lisp (http://repo.or.cz/w/clsql.git/blob/HEAD:/sql/expressions.lisp) at line 940.

    (write-string " Type=InnoDB" *sql-stream*))))

Actually 'Type' is obsolete (http://bugs.mysql.com/bug.php?id=47974) and doesn't work with MySQL 5.5.15. I replaced by 'Engine' keyword and now CREATE-TABLE works like a charm with the default :transactions.

Thanks for your work,

--
Martial

_______________________________________________
CLSQL mailing list
[email protected]
http://lists.b9.com/cgi-bin/mailman/listinfo/clsql