[Libreoffice-bugs] [Bug 126468] New: Unable to deselect 'Visible' flags in Base query

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=126468

            Bug ID: 126468
           Summary: Unable to deselect 'Visible' flags in Base query
           Product: LibreOffice
           Version: 6.1.3.2 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: harvey at nimmo.de

Problem was discovered with LibreOffice (version 6.1.2.3) Base as client to a
backend Mariadb10 via MySQL(JDBC) connector. 

Using the GUI query editor, an entire table as <tablename>.* was entered into
into the query fields. Two of the table fields were added to the query and
selected 'ascending' for sorting for each of these 2
fields. It was however, not possible to deselect the 'Visible' flags
for these 2 sort fields. The behaviour means that the 2 fields will each now
appear twice when running the query. A Base Form based on this query did not
transfer the data from those fields back to the table, presumably because of
the above ambiguity.   

On inspecting the SQL text of the query, a query of the
kind: SELECT * FROM <tablename> ORDER BY <Field1> ASC, <Field2> ASC was
expected.

The actual text in the SQL editor was, however:
SELECT * <tablename>.*, <tablename>.<Field1>, <tablename>.<Field2> FROM
<schema>.<tablename> <tablename> ORDER BY <Field1> ASC, <Field2> ASC

After deleting the text ', <tablename>.<Field1>, <tablename>.<Field2>'
from the SQL query, the query ran successfully, i.e. the extra fields were not
displayed in the query result. But on saving the query from the GUI again, the
deleted text was added again.

The source of the problem seems to be that the 'visible' flags in the extra 
fields (i.e. duplicates of fields from <tablename>.*) could not be deselected.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190718/6bf6ec50/attachment-0001.html>