#63 Syntax error: Keyword PRIMARY doubled in transfer tool

open
nobody
None
5
2008-05-13
2008-05-13
Koos Pol
No

When the transfer tool is migrating a database from a source to a destination, and the source contains a primary key, the statement is mis-typed for the destination. A typical database create statement will look like this:
create table t (i integer, constraint primary primary (i));

Note how keyword PRIMARY has been double AND note how the constraint name is missing.

Discussion

  • Koos Pol
    Koos Pol
    2008-05-13

    • summary: Keyword PRIMARY doubled in transfer tool --> Syntax error: Keyword PRIMARY doubled in transfer tool
     
  • Fred Toussi
    Fred Toussi
    2008-06-10

    Logged In: YES
    user_id=150940
    Originator: NO

    Moved to HSQLDB Utilities tracker.