#256 ALTER TABLE with braces

open
nobody
None
5
2010-12-13
2010-12-13
Andreas Masdan
No

Although setting
SET DATABASE SQL SYNTAX ORA TRUE;
following code is not allowed in HSQLDB (but in Oracle it is):
ALTER TABLE CODE_MST_PP ADD ( CONSTRAINT IDX_CODE_MST_PP_PK PRIMARY KEY (ROWID) );
But following code (without surrounding braces) is allwoed in both
ALTER TABLE CODE_MST_PP ADD CONSTRAINT IDX_CODE_MST_PP_PK PRIMARY KEY (ROWID) ;

Adding this compatibility would be nice :-)

Discussion

  • Andreas Masdan
    Andreas Masdan
    2010-12-13

    I forgot: used version is hsqldb-2.0.1-rc3

     
  • Fred Toussi
    Fred Toussi
    2010-12-13

    • milestone: 116102 -->
     
  • Fred Toussi
    Fred Toussi
    2010-12-13

    We don't add non-standard syntax when it is not necessary.
    Moved to feature request tracker.

     
  • Andreas Masdan
    Andreas Masdan
    2010-12-14

    OK, this is understandable.
    Oh yes, thanks, feature request tracker fits much better.