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

          Priority: medium
            Bug ID: 56243
          Assignee: libreoffice-bugs@lists.freedesktop.org
           Summary: Libreoffice Base: Bogus query for MySQL database
          Severity: normal
    Classification: Unclassified
                OS: All
          Reporter: bugs.freedesktop....@rolf.leggewie.biz
          Hardware: Other
            Status: UNCONFIRMED
           Version: 3.5.6.2 release
         Component: Database
        Depends on: 56242
           Product: LibreOffice

Created attachment 68858
  --> https://bugs.freedesktop.org/attachment.cgi?id=68858&action=edit
excerpt from mysql log

originally reported as - https://bugzilla.novell.com/show_bug.cgi?id=443873

LO produces a bogus query for tables without a primary key.

Steps to reproduce:

1) Load https://bugzilla.novell.com/attachment.cgi?id=251407 into a MySQL
server of your choice
2) Create new database and connect to above database
3) optional: enable logging for your MySQL server
4) double click on table accounts which does have a primary key
5) double click on table accounts_ext which does not

Observe the difference between 4 and 5 in that cells in 4 are editable where
those from 5 are not.

Find some excerpts from my MySQL log in the attachment.  Pay attention to the
bogus "WHERE 0=1" in both cases.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to