Issue 47975 - HSQLDB "identity" type not in list of column types
Summary: HSQLDB "identity" type not in list of column types
Status: UNCONFIRMED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: 680m95
Hardware: Other All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-04-22 16:52 UTC by kieser
Modified: 2013-02-07 22:42 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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).