Summary: | PostgreSQL-SDBC: newly inserted omitted values shown as zero | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Luc MASSENAUX <luc.massenaux> |
Component: | Database | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | QA Contact: | |
Severity: | major | ||
Priority: | medium | CC: | dr, iplaw67, LibreOffice, Simon.Richter |
Version: | 3.5.2 release | ||
Hardware: | Other | ||
OS: | Linux (All) | ||
See Also: | https://bugs.freedesktop.org/show_bug.cgi?id=36858 | ||
Whiteboard: | |||
i915 platform: | i915 features: | ||
Attachments: | Screenshot of the date display issue |
Hi Rainer, do you understand, waht reporter means? (In reply to comment #1) > Hi Rainer, > > do you understand, waht reporter means? Pretty simple IMHO : 1) Create an ODB file which connects to a postgresql db via the native postgres connector now included in LO by default. 2) Load a table containing dates, or create one, and check the result displayed : - in the table itself - in a form (as the user has provided a snapshot in colour, I'm betting that this is a form display and not the Table view display). 3) Check to see whether problem exists. 4) Also check to see whether it is not a duplicate of some other database form display problems (I seem to recall that there is one already). Alex Looking at the screenshot again, it is definitely a form. Alex Adding link to fdo#36858 because I think that it is possibly the same underlying problem. Alex I get this only for NULL dates Actually, I get that only on newly inserted rows, and only for the fields that were not filled in. For integer fields, I get "zero". I've stumbled over something similar in a form: I have two tables, "accounts" and "transactions", and a form showing both (with the latter being limited to the currently selected account, which is a foreign key in the transactions table. When I insert a new account, it is inserted properly, but the account ID (which is set by Postgres from a sequence) is assumed to be 0. When I then attempt to insert a transaction for that account, the INSERT fails because 0 is not a valid account ID and so the foreign key constraint is not met. Closing and reopening the form rereads the ID, and allows me to insert transactions. Adding self to CC if not already on |
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.
Created attachment 59629 [details] Screenshot of the date display issue LibreOffice Base does not display date fields properly with the native driver included in LibreOffice 3.5.2. Date fields are allways displayed as 01/01/1800 (DD/MM/YYYY). This issue not only happens with null values, but also when the date fields are actually set to a proper value. Screenshot provided.