Details
-
Bug
-
Resolution: Fixed
-
Medium
-
2.0 DR, 2.0 beta 1
-
None
Description
In the Capablility_set table, we use a reserved word (KEY) to name a column - this doesn't go well with MYSQL so needs to be fixed!
As a result, the table creation fails -
2008-02-18 14:45:24,455 ERROR [btpool0-1] [SchemaExport] 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 'varchar(255), VALUE text, CAPABILITY_SET bigint, primary key (CAPABILITY_ID))' at line 1 2008-02-18 14:45:24,499 ERROR [btpool0-1] [SchemaExport] Unsuccessful: create table REQUIREMENT (REQUIREMENT_ID bigint not null, KEY varchar(255), REGEX_MATCH bit, READONLY_REQ bit, MATCH_VALUE text, REQUIREMENT_SET bigint, primary key (REQUIREMENT_ID)) 2008-02-18 14:45:24,500 ERROR [btpool0-1] [SchemaExport] 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 'varchar(255), REGEX_MATCH bit, READONLY_REQ bit, MATCH_VALUE text, REQUIREMENT_S' at line 1 2008-02-18 14:45:24,564 ERROR [btpool0-1] [SchemaExport] Unsuccessful: alter table CAPABILITY add constraint FKEE341118A542349B foreign key (CAPABILITY_SET) references CAPABILITY_SET (CAPABILITY_SET_ID) 2008-02-18 14:45:24,564 ERROR [btpool0-1] [SchemaExport] Table 'mysql.CAPABILITY' doesn't exist