Issue 47975

Summary: HSQLDB "identity" type not in list of column types
Product: Base Reporter: kieser <brad>
Component: codeAssignee: AOO issues mailing list <issues>
Status: UNCONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: 680m95   
Target Milestone: ---   
Hardware: Other   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---

Description kieser 2005-04-22 16:52:59 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!
Comment 1 christoph.lukasiak 2005-04-25 14:46:18 UTC 
not a bug, but a feature enhancement -> send further to: requirements@openoffice.org
Comment 2 christoph.lukasiak 2005-04-25 14:46:57 UTC 
change issue type
Comment 3 christoph.lukasiak 2005-04-25 14:50:13 UTC 
correct os
Comment 4 valdisvi 2005-05-09 09:17:54 UTC 
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.
Comment 5 kieser 2005-05-09 09:31:17 UTC 
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?
Comment 6 kieser 2005-05-09 09:38:50 UTC 
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).