https://bugs.documentfoundation.org/show_bug.cgi?id=126178
Bug ID: 126178
Summary: FIREBIRD: Query with two fields with the same name
couldn't be sorted
Product: LibreOffice
Version: 6.3.0.0.beta2+
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: rob...@familiegrosskopf.de
Created attachment 152488
--> https://bugs.documentfoundation.org/attachment.cgi?id=152488&action=edit
Open the queries - the one with an alias will work, the other not
Open the attached database.
Open the query "Query_Ambiguous".
Query doesn't work, because the are two columns with the same name and the
columns should be sorted by the name. Shows only an error.
This code has been created by the query-GUI:
SELECT "Forename", "Forename" FROM "Table1" ORDER BY "Forename" ASC
Same code will work in HSQLDB-queries in the GUI.
The query will work in Firebird only when setting an alias to one of the
columns:
SELECT "Forename" "FName", "Forename" FROM "Table1" ORDER BY "FName" ASC
Could be this behaviour is a special Firebird behaviour. So it couldn't be
fixed by LO.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs