https://bugs.freedesktop.org/show_bug.cgi?id=47520
Bug #: 47520
Summary: : ODBC with sqliteodbc: primary key field mostly
empty, broken scolling
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.5.1 Release
Platform: Other
OS/Version: All
Status: UNCONFIRMED
Status Whiteboard: BSA
Severity: normal
Priority: medium
Component: Database
AssignedTo: [email protected]
ReportedBy: [email protected]
Problem description:
I have multiple sqlite3 databases that I use:
- on Windows XP SP3 with Ch. Werner's sqliteodbc driver v. 0.85 and MDAC 2.8
Sp1
- on Ubuntu 10.04 Lucid with Ch. Werner's sqliteodbc driver v. 0.80 and
unixodbc 2.2.11-21
On both systems I see with Libreoffice 3.5.1 and at least 5 different tables of
the connected Base databases:
Opening the table (or using the preview windows) shows the primary key field
mostly empty, to be exact: the 41th row has an entry, the following not; when
scrolling down to later rows and then back the view gets complete out of sync,
having sometimes alternating empty rows and one entry repeated every other row.
Those tables have in common:
all fields are defined "NOT NULL PRIMARY KEY" and are either char(n) or
varchar(n) datatype, the Base database has them as "Text (varchar)"
All databases open flawlessly in Libreoffice 3.4.5. Seems something broke
severely in the ODBC handling.
I experienced another issue, but that is probably a different bug:
Using a version newer than 0.85 of the sqliteodbc driver (only on Windows,
there is no newer version than 0.80 for Lucid) results in some of my tables
showing only 4 empty rows, and this happened already with OpenOffice 3 and
later with Libreoffice 3.3 and 3.4. Those tables have a timedate field as
primary key, and Christian Werner had changed the formatting of timedates
between 0.85 and 0.86 (millionth of seconds I believe) and told me, that in
this case the the handling of Base was in error, and I should avoid using
timedates as primary key, but that was no option. Now new with Libreoffice
3.5.1: when I try to open one of those tables with a timedate primary key
Libreoffice reproducibly crashes.
Steps to reproduce:
see above: I try to find a minimal database that shows this behavior, as the
ones that do hold private data.
Platform (if different from the browser): presumably all, at least Ubuntu Lucid
and Windows XP
Browser: Mozilla/5.0 (X11; Ubuntu; Linux i686; rv:11.0) Gecko/20100101
Firefox/11.0
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
