Apache OpenOffice (AOO) Bugzilla – Issue 52703
table design: Find a better (more usable) UI for specifiying the initial/increment value of an auto-increment field
Last modified: 2013-08-07 15:45:41 UTC
When you open the table design for a embedded HSQLDB database, and have a "Integer" column with "Auto increment" = "Yes", then there is a field "Auto-increment statement", which is prefilled with "IDENTITY". Technically, this is fine and correct. From a user experience point of view, this is - disturbing: unexperienced users don't know what it is, and will be confused by it - useless: any other value than IDENTITY doesn't work, anyway I suggest to remove this field in the table design, if and only if the database/type already prescribes which information would appear there. Please also update the specifiction at http://dba.openoffice.org/specifications/AutoIncrementValues.html then :)
That is not correct. Even HSQLDB supports the creation of auto increment fields which starts at any number and increment bey any value. columnname Datatype [(columnSize[,precision])] [{DEFAULT <defaultValue> | GENERATED BY DEFAULT AS IDENTITY (START WITH <n>[, INCREMENT BY <m>])}] | [[NOT] NULL] [IDENTITY] [PRIMARY KEY]
See my previous comment.
Re-opening. The original problem - the fact that the current UI is mere techno-babble for the unexperienced user - remains. If we want to support users in creating auto-increments with another initial/step value (do we really? This is way too advanced for most of them), then we should find an UI which deserves the word "usable".