To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=104901
User oj changed the following:
What |Old value |New value
================================================================================
Status|NEW |RESOLVED
--------------------------------------------------------------------------------
Resolution| |FIXED
--------------------------------------------------------------------------------
------- Additional comments from [email protected] Fri Sep 11 11:54:32 +0000
2009 -------
Fixed in cws dba32h
-Open any new hsqldb
-Tools->SQL
And execute the following
CREATE CACHED TABLE "Tabelle1"("id" INTEGER GENERATED BY DEFAULT AS
IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"dtText" VARCHAR(50) NOT
NULL,"dtNumber" DECIMAL(15),"dtDatum" DATE,"dtOld" BOOLEAN);
INSERT INTO "Tabelle1" ( "dtOld","dtText") VALUES ( 0,'a');
INSERT INTO "Tabelle1" ( "dtOld","dtText") VALUES ( 0,'b');
INSERT INTO "Tabelle1" ( "dtOld","dtText") VALUES ( 0,'c');
INSERT INTO "Tabelle1" ( "dtOld","dtText") VALUES ( 0,'d');
ALTER TABLE "Tabelle1" ALTER COLUMN "id" INTEGER NOT NULL IDENTITY;
INSERT INTO "Tabelle1" ( "dtOld","dtText") VALUES ( 0,'d');
==> Violation of unique constraint SYS_PK_47: duplicate value(s) for column(s)
"id"
Now the error message should appear anymore.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
