[Libreoffice-bugs] [Bug 125955] New: BASE: Auto-value is incremented when input to form was aborted due to erroneous input

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=125955

            Bug ID: 125955
           Summary: BASE: Auto-value is incremented when input to form was
                    aborted due to erroneous input
           Product: LibreOffice
           Version: 6.2.4.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: minor
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: simon.i at outlook.de

Description:
I have created a form with a table control element which is used to input data
to a table. Some of the fields have "input required" enabled, so when I want to
jump to another row (could also happen by clicking somewhere else by mistake)
before I entered any data into those fields, Base shows the correct error
message and lets me return to that row to input the missing data. However, it
still increments the auto-value of the primary key.

So let's say, for example, the previous table entry has ID=5. -> I start a new
row -> mess up while inputting the data or forget one field -> that error
message is shown -> I correct my input -> continue to the next row, the row
will now have ID=7 instead of ID=6.

(This is the error message: firebird_sdbc error:
*validation error for column "tablename"."fieldname", value "*** null ***"
caused by
'isc_dsql_execute')

Steps to Reproduce:
1. Create a table
2. Create a primary key with type integer and auto-value enabled
3. Create a field of any type without "input required"
4. create some other field with "input required"
5. Save the table
6. edit the table: enter something into first field (the one without input
required)
7. leave the second field blank (the one with input required)
8. try to get to the next row by using tabulator key
9. Error message pops up because of blank field. Exit message
10. enter data into second field (the one which was previoulsy left blank)
11. tab into next row by using tabulator key
12. Primary key integer value is now 2 whereas it should be 1


Actual Results:
inconsistent IDs

Expected Results:
The Primary key value should not be increased when the data record submission
was aborted due to an error


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 6.2.4.2 (x64)
Build-ID: 2412653d852ce75f65fbfa83fb7e7b669a126d64
CPU-Threads: 4; BS: Windows 10.0; UI-Render: Standard; VCL: win; 
Gebietsschema: de-DE (de_DE); UI-Sprache: de-DE
Calc: CL

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190616/64d189f3/attachment.html>