Issue 77732 - Not possible to create AUTOINCREMENT fields in HSQL file based database
Summary: Not possible to create AUTOINCREMENT fields in HSQL file based database
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.2.1 RC2
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: OOo 2.x
Assignee: ocke.janssen
QA Contact: issues@dba
URL:
Keywords:
: 79341 (view as issue list)
Depends on:
Blocks:
 
Reported: 2007-05-23 20:47 UTC by drewjensen.inbox
Modified: 2007-08-24 06:45 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
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 drewjensen.inbox 2007-05-23 20:47:20 UTC 
Follow the steps in ISSUE 71830 to connect to file based HSQL database.
Create a new table, assign a PK field with type INTEGER AUTOINCREMENT = YES

The table is created but the PK field never is set to auto_increment.

Opening as separate issue, since the primary issues with 71830 are fixed and
working, when tested on my machine.
Comment 1 marc.neumann 2007-05-30 15:24:21 UTC 
Hi,

I can confirm this, reassign to the right developer and set target.

Bye Marc
Comment 2 Mechtilde 2007-05-30 20:21:35 UTC 
It is the same as in 72836

which I mark as a regression
Comment 3 mdxonefour 2007-08-17 09:08:41 UTC 
*** Issue 79341 has been marked as a duplicate of this issue. ***
Comment 4 ocke.janssen 2007-08-23 08:47:10 UTC 
@atjensen: Do you changed the Advanced Settings for the auto increment under
Edit->Database?
I set for the 1st field
IDENTITY
and for the 2nd
CALL IDENTITY()
and I could create autoincrement fields.
Comment 5 drewjensen.inbox 2007-08-23 18:13:29 UTC 
That did it.

tested on 
XP Sp2
G680m_2 AND SO8 update 7
JRE 1.0.6.0_02
Class path using the hsqldb.jar supplied with OOo distro
Comment 6 ocke.janssen 2007-08-24 06:45:12 UTC 
Thanks for testing. Closing it now.