[Libreoffice-bugs] [Bug 107954] New: SQL-statement shows also columns of "OrderBY" -section in Tools > SQL

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 107954
           Summary: SQL-statement shows also columns of "OrderBY"-section
                    in Tools > SQL
           Product: LibreOffice
           Version: 4.0.0.3 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: robert at familiegrosskopf.de

Created attachment 133402
  --> https://bugs.documentfoundation.org/attachment.cgi?id=133402&action=edit
Open the database and try the SQL-code in Tools > SQL.

Open the attached database.
Start Tools > SQL
Mark 'Show output of "select"-statements
Execute the following code:
SELECT "Nachname", "Vorname" FROM "Teilnehmer" ORDER BY "Nachname", "Vorname"
ASC

It will show 
<Nachname>,<Vorname>,<Nachname>,<Vorname>,

Now start
SELECT "Nachname", "Vorname" FROM "Teilnehmer" ORDER BY "Nachname" ASC
It will show 
<Nachname>,<Vorname>,<Nachname>,

Every field, which is included in ORDER BY, will be repeated at the end of the
row.

This bug appears in LO 4.0.0.3, where it has been introduced to show the
output, up to LO 5.4.0.0 alpha1. Tested with OpenSUSE 42.1 64bit rpm Linux.

-- 
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/20170519/9a073e7d/attachment.html>