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?

asked 08 Apr '13, 07:01

Simon's gravatar image

Simon
96449
accept rate: 100%

I should point out I have now logged this with Sybase through official support channels.

(08 Apr '13, 09:05) Simon
Replies hidden

Thanks for reporting this issue Simon - I can also reproduce this quite easily. Thank you for the succinct reproducible.

May I ask which support channel you used - was this a case through your existing support plan or was this through the 'Report a Bug' website?

(08 Apr '13, 09:18) Jeff Albion

A case on our support plan via a colleague. I have received a case id and they have said they are looking into it.

(08 Apr '13, 09:28) Simon

Support have notified me that this is fixed in EBF 16.0.0.1506 or above.

permanent link

answered 18 Apr '13, 03:40

Simon's gravatar image

Simon
96449
accept rate: 100%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×197
×31

question asked: 08 Apr '13, 07:01

question was seen: 948 times

last updated: 18 Apr '13, 03:40