[Libreoffice-bugs] [Bug 126178] New: FIREBIRD: Query with two fields with the same name couldn't be sorted

[bugzilla-daemon at bugs.documentfoundation.org]

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 at lists.freedesktop.org
          Reporter: robert at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190701/fc828861/attachment.html>