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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
