Issue 56920

Summary: Auto-increment always starts from zero
Product: Base Reporter: Andrea Pescetti <pescetti>
Component: codeAssignee: requirements <requirements>
Status: CLOSED NOT_AN_OOO_ISSUE QA Contact: issues@dba <issues>
Severity: Trivial    
Priority: P4 CC: issues
Version: OOo 2.0   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---

Description Andrea Pescetti 2005-10-29 12:09:58 UTC
1. Create a new database.
2. Create a Table using the wizard: add a primary key with auto-increment.
3. Add data.

The auto-generated value of the primary key field for the first record is zero.

Not a bug in itself, but setting the default first entry to 1 would enhance
compatibility. MySQL starts from 1, for instance.

An option to specify a start value would do as well.

[Reported by Mario Govoni during Italian QA tests]
Comment 1 christoph.lukasiak 2005-11-08 14:18:45 UTC
i can acknowledge that

send further to: requirments
Comment 2 marc.neumann 2005-11-09 08:37:26 UTC

according to the hasql db documentation at
You can change the start of the autoincrement field when creating the table via
sql. (menu: TOOLS / SQL)

In the OOo tabledesign there is no possibility to set the start parameter yet.

Bye Marc
Comment 3 Mechtilde 2009-07-28 17:14:37 UTC
no response since that time
-< invalid
Comment 4 Mechtilde 2009-07-28 17:15:19 UTC
Comment 5 Mechtilde 2009-07-28 17:15:53 UTC
-> closed