#11541: NOT NULL gets appended to foreign key all the time

tariqrahiman reported 2014-01-29T01:08:17Z · last modified 2014-01-29T20:15:10Z

Dev	ivangron
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	App - Visual Editing
Version	14.0

Version: 14.0.8

Build #: 35460

Build Date: 2014-Jan-09 08:51:14 AM

Sybase Anywhere 11

@ivan : Look in ScriptConstraint.java Line 1217

1.) For alter table to add a foreign key, the script contains NOT NULL all the time. We should have an option to make this NULL or NOT NULL

To reproduce go to Sybase ASE 11 and Alter the table CHILD and add a foreign key. The SQL generated is as below:

ALTER TABLE [dbo].[CHILD]

ADD CONSTRAINT [fk_1]

NOT NULL FOREIGN KEY([C1])

REFERENCES [dbo].[A]([A])

CLUSTERED

2.) Unique option is not working as well

@ivan : Look in ScriptConstraint.java Line 1217

All Comments (2) Change History

ivangron 2014-01-29T02:28:06Z

Added option to gui. Also option is allow nulls by default. please test to make sure its working as desired.

tariqrahiman 2014-01-29T18:48:55Z

Verified in 14.0.8-3