The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

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:

×186
×31

question asked: 08 Apr '13, 07:01

question was seen: 917 times

last updated: 18 Apr '13, 03:40