[Libreoffice-bugs] [Bug 47520] ODBC with sqliteodbc: primary key field mostly empty, broken scolling

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=47520

--- Comment #3 from Terrence Enger <lo_bugs at iseries-guru.com> 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.