[Libreoffice-bugs] [Bug 53708] EDITING - hsqldb, wrong autoincrement counter inserted after failed INSERT
https://bugs.freedesktop.org/show_bug.cgi?id=53708 Alex Thurgood ipla...@yahoo.co.uk changed: What|Removed |Added Status|UNCONFIRMED |NEW Ever Confirmed|0 |1 --- Comment #1 from Alex Thurgood ipla...@yahoo.co.uk 2012-08-19 11:26:15 UTC --- If, when adding records to table containing an autoincrement NOT NULL field, the user enters data that does not match the requirements of the field definition, with the result that the INSERT fails, then the autoincrement counter is automatically incremented by 1 for each failed operation until the insert succeeds, at which point the current incremented value is written to the table. This should not happen, failed INSERTS (haven't tested UPDATE) should not cause the autoincrement counter to increment itself. I will test earlier versions to see if problem present there, or if this is a regression. 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
[Libreoffice-bugs] [Bug 53708] EDITING - hsqldb, wrong autoincrement counter inserted after failed INSERT
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
[Libreoffice-bugs] [Bug 53708] EDITING - hsqldb, wrong autoincrement counter inserted after failed INSERT
https://bugs.freedesktop.org/show_bug.cgi?id=53708 Alex Thurgood ipla...@yahoo.co.uk changed: What|Removed |Added AssignedTo|libreoffice-b...@lists.free |lio...@mamane.lu |desktop.org | --- Comment #3 from Alex Thurgood ipla...@yahoo.co.uk 2012-08-19 11:36:34 UTC --- @Lionel : handing this over to you. 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