[ROL-832] Import into MySQL 5.0 is broken

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 1.2
• Fix Version/s: 2.0
• Component/s: Data Model & JPA Backend
• Environment: MySQL 5.0.13-rc-standard
• Assignee: Anil Gangolli
• Reporter: Andre Kruger
• Created: 03/Oct/05 15:34
• Updated: 20/Mar/06 18:14
• Resolved: 24/Nov/05 16:24

Description

When running the import of the roller schema into MySQL 5.0 one of the tables has a reserved word as a column name the reserved word is "condition"
mysql> create database roller;
Query OK, 1 row affected (0.00 sec)

mysql>use roller
Database changed
mysql> \. /home/akruger/createdb.sql
[...]
Query OK, 0 rows affected (0.07 sec)

Query OK, 0 rows affected (0.09 sec)
Records: 0 Duplicates: 0 Warnings: 0

ERROR 1064 (42000): 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 'condition integer default 0 not null,
lastsuccess timestamp null
)' at line 6
ERROR 1146 (42S02): Table 'investologist_roller.pingtarget' doesn't exist
Query OK, 0 rows affected (0.07 sec)
[...]
Query OK, 0 rows affected (0.07 sec)
Records: 0 Duplicates: 0 Warnings: 0

ERROR 1146 (42S02): Table 'investologist_roller.pingtarget' doesn't exist
Query OK, 0 rows affected (0.07 sec)
Records: 0 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.09 sec)
Records: 0 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.12 sec)
Records: 0 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.08 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql>