[Libreoffice-bugs] [Bug 108060] New: Simple table created using Firebird Embedded produces an error during data entry

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 108060
           Summary: Simple table created using Firebird Embedded produces
                    an error during data entry
           Product: LibreOffice
           Version: 5.3.3.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: BridgeportContractor at gmail.com

Created attachment 133521
  --> https://bugs.documentfoundation.org/attachment.cgi?id=133521&action=edit
screen shot with error message

When using the Firebird Embedded database when I create a simple table I can't
insert data into it without getting, "Error inserting the new record", and 

firebird_sdbc_error: *validation error for column "Table1"."ID", value "***
null ***" caused by 'isc_dsql_execute'


How to recreate this:

Step 1 create a simple table:

  Open LibreOffice and select:
    File
       New
          Database
            * Create a new database
                Select: Firebird Embedded
                Next>>
                Select either:
                   * Yes, register the database, OR
                   * No, do not register the database

                Click Finish
                Click Save

  Then select: Create a Table in Design View...

  On line 1 enter: Field Name = "ID"   | Field Type = "Integer"
  On line 2 enter: Fidld Name = "Test" | Field Type = "Text"

  Right click on green arrow left of ID and select Primary Key

  Below set AutoValue to Yes

  Close the window
    Do you want to save the changes?  Save to table name "Table1".
    Click Yes


Step 2 test the table:
  Double click on "Table1" to open it.
  Type something in text and hit return.

  Expected ID becomes "0" and cursor moves to next line.

  Result is the attached error message.

-- 
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/20170524/b7be0048/attachment-0001.html>