You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2017/09/11 10:50:35 UTC

[Issue 127534] New: Compound primary keys of type TEXT with ODBC sqlite database result in those columns always appearing empty

https://bz.apache.org/ooo/show_bug.cgi?id=127534

          Issue ID: 127534
        Issue Type: DEFECT
           Summary: Compound primary keys of type TEXT with ODBC sqlite
                    database result in those columns always appearing
                    empty
           Product: Base
           Version: 4.1.3
          Hardware: All
                OS: Windows 10
            Status: UNCONFIRMED
          Severity: Major
          Priority: P5 (lowest)
         Component: code
          Assignee: issues@openoffice.apache.org
          Reporter: morse@ikrg.com
  Target Milestone: ---

Created attachment 86215
  --> https://bz.apache.org/ooo/attachment.cgi?id=86215&action=edit
sqlite file, odb file, and two screenshots

I have several sqlite tables that have multiple TEXT columns as the primary key
(i.e., serving as a compound primary key). The ODBC connection using the sqlite
driver (http://www.ch-werner.de/sqliteodbc/) works fine: I can see and open all
my tables, add data, etc. I have foreign key constraints turned on in the ODBC
driver and they are properly enforced.  However, after adding rows to a table,
then closing the table, and then reopening it, all of my (compound) primary key
fields (TEXT) appear blank.  If I start to edit a row, then press Esc to about
the edit, then the data appears.  This also applies to forms based on the
tables.  Queries do not seem to suffer from this problem.

I've attached a zip file with the sqlite database (.db), the OObase file
(.odb), and a couple of screenshots.

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 127534] Compound primary keys of type TEXT with ODBC sqlite database result in those columns always appearing empty

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127534

--- Comment #2 from Doug Morse <mo...@ikrg.com> ---
If I import my product table into OO Calc, the primary key columns (product_id,
product_variant_id) columns are missing there as well.

However, if I import into Excel 2016 using the same ODBC DSN, the data is all
present.

Thus, I do not believe this problem is due to any problems with sqlite or the
sqlite ODBC driver; rather, it appears to be specific to LibreOffice.

Thanks.

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 127534] Compound primary keys of type TEXT with ODBC sqlite database result in those columns always appearing empty

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127534

--- Comment #3 from mroe <mr...@gmx.net> ---
(In reply to Doug Morse from comment #2)
> Thus, I do not believe this problem is due to any problems with sqlite or
> the sqlite ODBC driver; rather, it appears to be specific to LibreOffice.


The screenshot says that you are using OpenOffice. LibreOffice has it's own bug
tracking system and many issues that have nothing to do with Apache OpenOffice.

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 127534] Compound primary keys of type TEXT with ODBC sqlite database result in those columns always appearing empty

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127534

oooforum (fr) <oo...@free.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |IRREPRODUCIBLE

--- Comment #5 from oooforum (fr) <oo...@free.fr> ---
No news from OP since +30 days

Feel free to reopen and provide requested information.

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 127534] Compound primary keys of type TEXT with ODBC sqlite database result in those columns always appearing empty

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127534

Marcus <ma...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |CLOSED
           Severity|Major                       |Normal

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 127534] Compound primary keys of type TEXT with ODBC sqlite database result in those columns always appearing empty

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127534

--- Comment #1 from Doug Morse <mo...@ikrg.com> ---
Correction: Queries also suffer from this problem.

In addition, I have created a test database with just my manufacturer and
product tables.  When I create the product table without product_id and
product_variant_id as the primary key (i.e., no primary key for this table),
then I see data in all columns (i.e., the "vanishing" data in the product_id
and product_variant_id columns no longer occurs).

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 127534] Compound primary keys of type TEXT with ODBC sqlite database result in those columns always appearing empty

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127534

oooforum (fr) <oo...@free.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |oooforum@free.fr

--- Comment #4 from oooforum (fr) <oo...@free.fr> ---
To avoid a ODBC driver problem, could you provide an ODB with native HSQL
format.

-- 
You are receiving this mail because:
You are the assignee for the issue.