Bug 108060 - Simple table created using Firebird Embedded produces an error during data entry
Summary: Simple table created using Firebird Embedded produces an error during data entry
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
5.2.5.1 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-05-24 14:35 UTC by Howard Johnson
Modified: 2017-07-12 20:04 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
screen shot with error message (39.97 KB, image/png)
2017-05-24 14:35 UTC, Howard Johnson
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Howard Johnson 2017-05-24 14:35:06 UTC
Created attachment 133521 [details]
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.
Comment 1 Howard Johnson 2017-05-24 15:23:46 UTC
It looks like this issue has been resolved.  

Note: I accidentally tested w/ an older version that I thought I was testing with this morning.  Then later realized my mistake and so downgraded the version# on this bug to reflect my actual test.

Again, this bug does NOT occur in the latest release: 5.3.3.2.

Thanks for fixing it, and sorry for my mis-step.