[ROL-1855] Automatic table creation fails on HSQLDB

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 5.0
• Fix Version/s: 5.0
• Component/s: Data Model & JPA Backend
• Environment: Ubuntu 8.04 LTS, Sun JDK 1.6, Tomcat 6.0.20, HSQLDB 2.0 RC8
• Browser Version: Chrome 3.0
• Database: HSQLDB 2.0 RC8
• JDK Version: 1.6
• Level of effort: 0.25
• O/S Version: Ubuntu 8.04 LTS
• Assignee: David Johnson
• Reporter: Juergen Kellerer
• Created: 09/Jan/10 15:24
• Updated: 01/Jan/13 17:53
• Resolved: 27/Feb/10 03:07

Description

When Tomcat and Roller is set up with HSQLDB, I get a complaint when Roller tries to create its tables.
The exact message is "Unexpected token 'DEFAULT'" and comes up during the execution of the create table script for the table "webpage".

The bug is caused by a mistake in the keyword order and can be fixed by replacing:
action varchar(16) not null default 'custom'
with:
action varchar(16) default 'custom' not null

After this change all tables are created just fine.