UWCS/choob — Issue #407: Requires MySQL < 5.5
Author: FauxFaux
Created: 2012-01-04 02:29:39+00:00
State: open
Labels: bug-p1, core

Under MySQL 5.5, at least creating tables from ODB breaks:

Ack! SQL Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
You have an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near 'Type=InnoDB' at line 1

http://dev.mysql.com/doc/refman/5.5/en/create-table.html quoth:

The older TYPE option was synonymous with ENGINE.
TYPE was deprecated in MySQL 4.0 and removed in MySQL 5.5.
When upgrading to MySQL 5.5 or later, you must convert existing
applications that rely on TYPE to use ENGINE instead.