https://bugs.documentfoundation.org/show_bug.cgi?id=147730
Bug ID: 147730
Summary: LO Base does not handle compound primary key if one
field is empty ("")
Product: LibreOffice
Version: 7.2.5.2 release
Hardware: All
OS: macOS (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Description:
A table stored in SQLite3 can have a compound primary key of two fields in
which one of the fields is empty, provided that the empty field value is blank
("") and not NULL. Using an ODBC connection with LO Base as the front end, LO
does not handle the records correctly, either as simple table display or within
a form. It gets the number of records wrong (not counting those with blank
values), but can scroll through the whole table. Equally, asking it to go (by
pushbutton) to LAST or NEW typically returns the error "Failed to refetch row".
Steps to Reproduce:
1. See description above.
2.
3.
Actual Results:
See description above.
Expected Results:
LO should not be confused when navigating such a table!
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.2.5.2 / LibreOffice Community
Build ID: 499f9727c189e6ef3471021d6132d4c694f357e5
CPU threads: 8; OS: Mac OS X 10.13.6; UI render: default; VCL: osx
Locale: en-GB (en_GB.UTF-8); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
