https://bugs.freedesktop.org/show_bug.cgi?id=53708
--- Comment #2 from Alex Thurgood <ipla...@yahoo.co.uk> 2012-08-19 11:35:36 UTC --- How to reproduce : 1) Create an embedded (default) hsqldb database file, with a table containing the following fields : - autoincrement NOT NULL id field which is also primary key (default behaviour in LO) - a text field with a string value length set to 10, 2) Save the table as Table1, then open the table for editing, then tab (tabulation key) from id field to text field, and enter a data string longer than 10 characters, say 20 characters, then try to tab into a new record. 3) You should get an error message indicating that your string length exceeds the definition allowed by the table. 4) Edit the string to delete 1 or 2 characters, and try again. 5) The message will repeat itself until the string length matches that defined in the field (all of this is normal). 6) When you finally get a string which is not longer than that defined, the INSERT will succeed, but the autoincrement field will contain a value that corresponds to the failed number of attempts. Expected behaviour : the autoincrement field should only insert the default value, ignoring any failed INSERTS, i.e. the counter shouldn't be updated for each failed operation. Alex -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. _______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs