Opened 13 years ago

Closed 13 years ago

#1566 closed defect (fixed)

MySQL 5.5 no longer supports CREATE TABLE ... TYPE=InnoDB

Reported by: Nicklas Nordborg Owned by: everyone
Priority: major Milestone: BASE 2.17
Component: install Version:
Keywords: Cc:

Description

According to the documentation at ​http://dev.mysql.com/doc/refman/5.5/en/create-table.html TYPE was deprecated in MySQL 4.0. It was removed in MySQL 5.5 and one should use ENGINGE=InnoDB instead.

Hibernate has fixed this some time ago, but it seems like we are still using the older MySQL dialect in the configuration file.

Change History (1)

comment:1 by Nicklas Nordborg, 13 years ago

Resolution: → fixed
Status: new → closed

(In [5537]) Fixes #1566: MySQL 5.5 no longer supports CREATE TABLE ... TYPE=InnoDB

Changes the default dialect to org.hibernate.dialect.MySQL5InnoDBDialect. An additional problem was found in ContextData.java which incorrectly used type="string" length="65535" for a column declaration. We must use type="text" instead. Unfortunately this means that BASE will not install on MySQL 5.5 until 2.17 is released.

Note: See TracTickets for help on using tickets.