#14624: Sybase ASE -> Constraints keys extraction limited to 16 keys in primary and unique and 6 in reference needs to be expanded

ivangron reported 2016-08-12T16:59:45Z · last modified 2016-10-19T16:14:06Z

Sybase ASE -> Constraints keys extraction limited to 16 keys in primary and unique and 6 in reference needs to be expanded

Dev	ivangron
QA	NielsGron

Priority	Major
Complexity	Unknown

Component	App - General
Version	17.0

Older versions of sybase ASE limited the amount of columns in a primary and unique constraint to 16. Limit was expanded to 31.

Older versions of sybase ASE limited the amount of columns in a foreign key constraint to 6. Limit was expanded to 16.

For versions of sybase ase 12.5 and above we need to enhance extraction and scripting in order to correctly support these limits.

1 attachment

Screen Shot 2016-08-26 at 12.26.51 PM.png

2016-08-26T19:27:49Z

83 KB

All Comments (3) Change History

ivangron 2016-08-12T17:04:59Z

Extraction sql enhanced to extract column key limits now. There was no need to modify scripting.

Committed revision: 50796

Example use to test below:

CREATE TABLE "dbo"."A" ("a1" int NOT NULL, "a2" int NOT NULL, "a3" int NOT NULL, "a4" int NOT NULL, "a5" int NOT NULL, "a6" int NOT NULL, "a7" int NOT NULL, "a8" int NOT NULL, "a9" int NOT NULL, "a10" int NOT NULL, "a11" int NOT NULL,

"a12" int NOT NULL, "a13" int NOT NULL, "a14" int NOT NULL, "a15" int NOT NULL, "a16" int NOT NULL, "a17" int NOT NULL, "a18" int NOT NULL, "a19" int NOT NULL, "a20" int NOT NULL, "a21" int NOT NULL, "a22" int NOT NULL, "a23" int NOT NULL,

"a24" int NOT NULL, "a25" int NOT NULL, "a26" int NOT NULL, "a27" int NOT NULL, "a28" int NOT NULL, "a29" int NOT NULL, "a30" int NOT NULL, "a31" int NOT NULL, "a32" int NOT NULL, "a33" int NOT NULL,

CONSTRAINT "A_pkey" PRIMARY KEY ("a1","a2","a3","a4","a5","a6","a7","a8","a9","a10","a11","a12","a13","a14","a15","a16","a17","a18","a19"),

CONSTRAINT "A_ukey" UNIQUE ("a10","a11","a12","a13","a14","a15","a16","a17","a18","a19","a20","a21","a22","a23","a24","a25","a26","a27","a28","a29","a30","a31"),

CONSTRAINT "A_ckey" CHECK ( "a21" > 0 AND "a22" > 0 AND "a23" > 0 AND "a24" > 0 AND "a25" > 0 AND "a26" > 0 AND "a27" > 0 AND "a28" > 0 AND "a29" > 0 AND "a30" > 0 AND "a31" > 0 AND "a32" > 0 AND "a33" > 0 AND "a14" > 0 AND "a15" > 0 AND "a16" > 0 AND "a17" > 0 AND "a18" > 0 AND "a19" > 0))

CREATE TABLE "dbo"."A1" ("a1" int NOT NULL, "a2" int NOT NULL, "a3" int NOT NULL, "a4" int NOT NULL, "a5" int NOT NULL, "a6" int NOT NULL, "a7" int NOT NULL, "a8" int NOT NULL, "a9" int NOT NULL, "a10" int NOT NULL, "a11" int NOT NULL,

"a24" int NOT NULL, "a25" int NOT NULL, "a26" int NOT NULL, "a27" int NOT NULL, "a28" int NOT NULL, "a29" int NOT NULL, "a30" int NOT NULL, "a31" int NOT NULL, "a32" int NOT NULL, "a33" int NOT NULL,

CONSTRAINT "A1_pkey" PRIMARY KEY ("a1","a2","a3","a4","a5","a6","a7","a8","a9","a10","a11","a12","a13","a14","a15","a16","a17","a18","a19","a20","a21","a22","a23","a24","a25","a26","a27","a28","a29","a30","a31"),

CONSTRAINT "A1_ukey" UNIQUE ("a10","a11","a12","a13","a14","a15","a16","a17","a18","a19","a20","a21","a22","a23","a24","a25"))

ALTER TABLE "dbo"."A" ADD CONSTRAINT "A_FKEY"

FOREIGN KEY ("a10","a11","a12","a13","a14","a15","a16","a17","a18","a19","a20","a21","a22","a23","a24","a25")

REFERENCES "dbo"."A1" ("a10","a11","a12","a13","a14","a15","a16","a17","a18","a19","a20","a21","a22","a23","a24","a25")

Extraction sql enhanced to extract column key limits now. There was no need to modify scripting.

Committed revision: 50796

Example use to test below:

"a24" int NOT NULL, "a25" int NOT NULL, "a26" int NOT NULL, "a27" int NOT NULL, "a28" int NOT NULL, "a29" int NOT NULL, "a30" int NOT NULL, "a31" int NOT NULL, "a32" int NOT NULL, "a33" int NOT NULL,

CONSTRAINT "A_pkey" PRIMARY KEY ("a1","a2","a3","a4","a5","a6","a7","a8","a9","a10","a11","a12","a13","a14","a15","a16","a17","a18","a19"),

CONSTRAINT "A_ukey" UNIQUE ("a10","a11","a12","a13","a14","a15","a16","a17","a18","a19","a20","a21","a22","a23","a24","a25","a26","a27","a28","a29","a30","a31"),

"a24" int NOT NULL, "a25" int NOT NULL, "a26" int NOT NULL, "a27" int NOT NULL, "a28" int NOT NULL, "a29" int NOT NULL, "a30" int NOT NULL, "a31" int NOT NULL, "a32" int NOT NULL, "a33" int NOT NULL,

CONSTRAINT "A1_ukey" UNIQUE ("a10","a11","a12","a13","a14","a15","a16","a17","a18","a19","a20","a21","a22","a23","a24","a25"))

ALTER TABLE "dbo"."A" ADD CONSTRAINT "A_FKEY"

FOREIGN KEY ("a10","a11","a12","a13","a14","a15","a16","a17","a18","a19","a20","a21","a22","a23","a24","a25")

REFERENCES "dbo"."A1" ("a10","a11","a12","a13","a14","a15","a16","a17","a18","a19","a20","a21","a22","a23","a24","a25")

tariqrahiman 2016-08-26T19:26:14Z

@ivan: This is not fixed in the schema tree node. Only 16 items get displayed in Schema Tree node. The Script Create to Window(Full) works fine.

ivangron 2016-08-30T16:32:13Z

Sybase ASE Constraints Columns Node will correctly show up to 31 key columns for versions 12.5 and above now.

Commit Revision: 50978

Search Tips

Aqua Data Studio / nhilam

Sybase ASE -> Constraints keys extraction limited to 16 keys in primary and unique and 6 in reference needs to be expanded

1 attachment

Issue #14624

Completion

1 issue link

Issue #14655

Search Tips

Aqua Data Studio / nhilam

Title

Sybase ASE -> Constraints keys extraction limited to 16 keys in primary and unique and 6 in reference needs to be expanded

1 attachment

Issue #14624

Completion

1 issue link

Issue #14655