headers
Martial Boniou | 6 Jan 2012 13:15
Picon
Favicon

deprecated SQL Type for CREATE/ALTER in MySQL

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
CLSQL@...
http://lists.b9.com/cgi-bin/mailman/listinfo/clsql
Permalink | Reply |
headers
Nathan Bird | 24 Apr 2012 18:05
Favicon

Re: deprecated SQL Type for CREATE/ALTER in MySQL

On 01/06/2012 07:15 AM, Martial Boniou wrote:
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.


This is now in CLSQL HEAD, sorry it took so long for me to notice.
_______________________________________________
CLSQL mailing list
CLSQL@...
http://lists.b9.com/cgi-bin/mailman/listinfo/clsql
Permalink | Reply |

Gmane