on 2013 Apr 08 8:01 AM
Hi all,
I have encountered an assertion problem when doing some development with SQL Anywhere 16, which I have narrowed down and recreated in an empty database. I'm not sure if it makes a difference but the dbinit command was as follows:
"C:\\Program Files\\SQL Anywhere 16\\Bin32\\dbinit.exe" -o "%TESTPATH%\\testoutput.log" -p 4096 -s -t test.log -z 1252latin1(CaseSensitivity=Ignore) -zn uca(CaseSensitivity=Ignore;AccentSensitivity=Ignore;PunctuationSensitivity=Primary) "%TESTPATH%\\test.db"
Running the following statements:
CREATE TABLE "DBA"."testing" ("key" INTEGER NOT NULL, PRIMARY KEY ( "key" )); INSERT INTO "DBA"."testing" ("key") VALUES (1); ALTER TABLE "DBA"."testing" ADD "test1" SMALLINT DEFAULT 0 NOT NULL; ALTER TABLE "DBA"."testing" ADD "test2" SMALLINT DEFAULT 0 NOT NULL; ALTER TABLE "DBA"."testing" ALTER "test1" DROP DEFAULT; ALTER TABLE "DBA"."testing" ALTER "test2" DROP DEFAULT; SELECT * FROM "DBA"."testing";
Results in the following error and the failure of the database service:
Internal database error *** ERROR *** Assertion failed: 200610 (16.0.0.1324) Attempting to normalize a non-continued row (0x238:0x0) -- transaction rolled back SQLCODE=-301, ODBC 3 State="HY000"
It appears to be the dropping of two defaults in a row that causes the problem (it can do one just fine as far as I can tell). Any thoughts or suggestions?
Request clarification before answering.
Support have notified me that this is fixed in EBF 16.0.0.1506 or above.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
82 | |
29 | |
9 | |
8 | |
7 | |
7 | |
7 | |
6 | |
6 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.