Pranas wrote > > 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 >
As Sven wrote, the normal string-literal-way of inserting works correctly (at least with his version). No we need some info from you: 1. the full version number 7.4.3.xy (xy important) 2. the tool you are using to insert and its version (if different from the server-version) 3. a vtrace of both inserts according to http://sapdb.2scale.net/moin.cgi/VTrace but please a. change default to default insert in steps 1 and 6 b. change akb to akbm in step 4 Elke SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
