CREATE TABLE "DBA"."TABLE"
(
"Charr" CHAR(10) ASCII NOT NULL,
"Small" Smallint NOT NULL,
"booll" Boolean NOT NULL DEFAULT TRUE,
...
PRIMARY KEY (Charr,Small,booll),
...)
I cannot confirm it for MaxDB 7.5.0.8
May statements were:
CREATE TABLE test
(c1 CHAR(10) NOT NULL,
c2 SMALLINT NOT NULL,
c3 BOOLEAN NOT NULL DEFAULT TRUE,
PRIMARY KEY (c1,c2,c3))
//
INSERT INTO test VALUES('abc', 1, FALSE)
//
INSERT INTO test VALUES('abc', 1, FALSE)and the last INSERT cause a "Duplicate key" error as expected.
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
