https://bugs.freedesktop.org/show_bug.cgi?id=61142
Priority: medium
Bug ID: 61142
Assignee: [email protected]
Summary: Memo fields over 1023 bytes on ODBC database cause
garbage text
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.0.0.3 release
Component: Database
Product: LibreOffice
Created attachment 75141
--> https://bugs.freedesktop.org/attachment.cgi?id=75141&action=edit
Sample ODBC database (SQLite) and BASE document
When connecting to an ODBC database, a memo field with greater than 1023 bytes
of text causes extremely slow performance and displays garbage at the end of
the field. It is strongly suspected there is an overflow of a 1k buffer.
Attached is a sample SQLite database illustrating the problem, and a "Base"
database that connects to it.
To reproduce the problem with my sample file...
REQUIRED:
- SQLite ODBC driver. You need the 32-bit driver even on a x64 system in
Windows since there is no 64 bit LibreOffice build for Windows. You can
download this at http://www.ch-werner.de/sqliteodbc/
Steps:
1) Set up the ODBC DSN for the sample database. Use the normal ODBC
administrator through your control panel for 32-bit Windows. For 64-bit
Windows, you must create the ODBC datasource using
"c:\windows\sysWOW64\odbcad32.exe" to access the 32-bit ODBC system. In either
case, create a datasource named "ODBCTEST1" and point it to the "ODBCTest.db"
sample in the zip file attached to this report.
2) Open the sample "Base" database ODBCTest.odb. Select tables and open the
"Test1" table.
3) The Memorandum field in row 1 has 1023 bytes. In row 2 it has 1024 bytes.
If you click on that field in row 1 and hit the "END" button on your keyboard,
you will notice it displays properly. If you click on that column in row 2 and
hit "END", you will notice a bunch of junk oriental characters. Scrolling
through that field is extremely slow. Any handling of rows with such fields is
very slow.
4) If you copy (CRTL-C) an affected field, then paste it into another program,
the text pastes correctly. If you try and display it in any way within "Base"
(table, queries, forms), all the junk characters are added and performance
degrades.
This same ODBC database works in 32 and 64 bit versions of Windows with the
same ODBC driver using 3.5 versions of LibreOffice. It is unknown what interim
version introduced this bug.
--
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
