#654 Create table script problem in constraint

2.6.6
open
Rob Manning
5
2012-12-29
2008-08-13
Anonymous
No

In version 2.5 when I execute "Session > Scripts > Create Table Script" get the result #1 for a constraint FK.
When I execute the same command in version 2.6.6, get the result #2.
The table has a FK with two columns.

result #1
ALTER TABLE TB_DATA1 ADD CONSTRAINT FK_DATA2_DATA1 FOREIGN KEY( col1, col2)REFERENCES TB_DATA2( col1, col2);

result #2
ALTER TABLE TB_DATA1 ADD CONSTRAINT FK_DATA2_DATA1 FOREIGN KEY (col1) REFERENCES TB_DATA2(col2);

Discussion

  • Logged In: NO

    This error occurring in this Apache Derby.

     
  • Logged In: YES
    user_id=503723
    Originator: NO

    The Apache Derby version used is 10.4