Apache OpenOffice (AOO) Bugzilla – Issue 115434
[cws hsqldb19] Copy table to external hsqldb database Autovalue lost
Last modified: 2013-01-29 21:41:15 UTC
OOo cws hsqldb19 dated 2010.11.04. Open odb with built in hsqldb. Create new table with ID integer Autovalue, Text text, add arbitrary value to text field. Open odb file connected to external hsqldb server. Copy from built in, to external file connected odb file, go through copy wizard. Open table in edit mode in external server connected file, The ID "AutoValue" changed from Yes to No, and grayed out, you can not to change it.
I forget to mention, I added hsqldb.jar and sdbc_hsqldb.jar to classpath, and connected to hsqldb 2.0.1.RC2 server.
I created new table in server connected odb file, with ID, Integer, AutoValue set to "Yes". When I saved the table, the Autovalue settings disregarded. I use URL: hsqldb:hsql://127.0.0.1/;default_schema=true If I use from Tools>SQL.... ALTER TABLE "TableName" ALTER COLUMN ID GENERATED ALWAYS AS IDENTITY I can change the AutoValues to "Yes". Copy in opposite direction not cause ID Autovalue lost.
External server uses memory tables, not cached.
The problem here is that the SQL statement doesn't allow to use "NOT NULL GENERATED BY DEFAULT AS IDENTITY" for Autoincrement fields. When using the embedded version this string is replace by "GENERATED BY DEFAULT AS IDENTITY" I have to figure out how this could be solved.