Apache OpenOffice (AOO) Bugzilla – Issue 47975
HSQLDB "identity" type not in list of column types
Last modified: 2013-02-07 22:42:36 UTC
HSQLDB impelments sequence values on columns as type "identity". Yet in the table create screen in the database component when you are specifying the column type, this option isn't presented (integer, float, etc are). This column type needs to be added to the list!
not a bug, but a feature enhancement -> send further to: requirements@openoffice.org
change issue type
correct os
For Build 1.9.100 it works in such way - if field type= BigInt, Autovalue = yes, then auto increment statement is set automatically to IDENTITY.
That is a good solution for now! In future releases, will it be added to the dropdown too? I.e. Is there more work on this issue planned?
I see that this applies to BIGINT types, but in HSQLDB type INTEGER can also be IDENTITY. In fact, the default storage type of IDENTITY types is INTEGER, not BIGINT. So the above logic should also be applied to INTEGER types (i.e. INTEGER + AUTOVALUE == YES -> IDENTITY).