OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Bug? BOOLEAN data type as PRIMARY KEY field

From: Pranas (baliukadanet.lt)
Date: Wed Feb 11 2004 - 09:42:41 CST


Hello,

SAP DB 7.4 allows insert duplicate rows it to following table:

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),
...)

Regards,
Pranas