https://bugs.freedesktop.org/show_bug.cgi?id=47520
--- Comment #3 from Terrence Enger <[email protected]> 2012-04-09 11:52:34 PDT --- I have succeeded in demonstrating the first described problem with ubuntu-natty (11.04) 32-bit libsqliteodbc version 0.87.2 libsqlite3-0 version 2.8.17-6build2 and LibreOffice master commit 1199713, pulled 2012-04-01 and configured with --disable-mozilla --enable-symbols --enable-dbgutil --enable-crashdump --disable-build-mozilla --without-system-postgresql --enable-python=internal Here are the steps. Of course, change the name of my working directory "/home/terry/lo_hacking/notes/bug_047520/" to something that you find convenient. (1) Download the attached file init.sql to your working directory. (2) In your working directory, use the attached file init.sql to create an example database: $ sqlite3 bug_047520.db SQLite version 3.7.4 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .read init.sql Error: near line 5: no such table: byNr Error: near line 6: no such table: byTs Alternatively, download the attached database, bug_047520.db. (3) Observe the created tables. $ sqlite3 bug_047520.db SQLite version 3.7.4 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .mode column sqlite> select * from byNr; 1 2012-04-06 12:34:56.654321 Friday 2 2012-04-05 13:45:57.123456 Thursday sqlite> select * from byTs; 1 2012-04-06 12:34:56.654321 Friday 2 2012-04-05 13:45:57.123456 Thursday sqlite> .quit (4) Define bug_047520 as an ODBC data source referencing the SQLite database bug_047520.db. I attach screenshot from ODBCConfig. The stanza in my .odbc.ini reads ... [bug_047520] Description=timestamp primary key Driver=SQLite3 Database=/home/terry/lo_hacking/notes/bug_047520/bug_047520.db Timeout=100000 StepAPI=No ShortNames=No FKSupport=No SyncPragma=NORMAL JournalMode=DELETE LoadExt= (5) Create LO database file ... (a) From command line, source ooenv, and then `soffice.bin --base`. Program displays Database Wizard Step 1 of 2 "Select Database" with default selection "what do you want to do?" = "Create a new database". (b) Select "Connect to an existing database". Program extends the list of steps to four steps and enables the dropdown list of existing databases. (c) In the list of databases, select ODBC. Program displays ODBC as the selected existing database. (d) Click "Next >>". Program displays step 2 of 4 "Set up ODBC connection". (e) In "Name of the ODBC data source on your system", type "bug_047520", and click "Next >>". Program displays step 3 of 4 "Set up user authentication". (f) Click "Test Connection". Program displays message box "Connection Test ... The connection was established successfully." (g) Click "OK". Program returns focus to Database Wizard. (h) Click "Next >>". Program displays step 4 of 4 "Save and proceed". (i) Select "No, do not register the database", leave "Open the database for editing" selected, and click "Finish". Program presents Save dialog. (j) Type Name "Play1", navigate to your working directory, and click Save. Program displays window play1.odb with "Tables" selected; the lower right pane shows tables byNr and byTs. (6) Observe good results from the table with an integer key. (a) Double-click byNr. Program displays window "byNr - play1 - ... Table Data View". Observe two rows of data. I attach screenshot. (b) Close the Data View. Program displays window play1.odb. (7) Observe bad results from the table with a timestamp key. (a) Double-click byTs. Program displays window "byTs - play1 - ... Table Datata View". Actual result: No data is shown. I attach screenshot. Desired result: Two rows of data shown. -- 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
