[Libreoffice-bugs] [Bug 133823] New: Firebird: Alias in a query will give "CASE" as column name in a form, if a field with same name existed

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 133823
           Summary: Firebird: Alias in a query will give "CASE" as column
                    name in a form, if a field with same name existed
           Product: LibreOffice
           Version: 6.4.4.2 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 161809
  --> https://bugs.documentfoundation.org/attachment.cgi?id=161809&action=edit
Test the two forms. Press the button: different column names will be shown with
the same SQL-code.

Open the attached database.
Open the form "form_query" and press the button.
Column names of the query the form depends of are shown.
But there is one column "CASE", which isn't part of the query.

Now close the form and open the form with the same SQL code. The code is
direcly connected to the form, not through a query.
Press the button and you could see the column names. 
This column names are the same as shown in the query.

This is the query:
SELECT "ID", "forename", "sex" "s_short", CASE WHEN "sex" = 'm' THEN 'Mister'
ELSE 'Miss' END "sex" FROM "table1"

The bug only appears if there is a field, which is defined in the table with
the same name as another field gets for alias. Table contains "sex", which is
changed by alias to "s_short" and then another field appears with alias "sex".
The bug appears with queries, but not with SQL-code, which is set directly in
the form.

Might be related to
https://bugs.documentfoundation.org/show_bug.cgi?id=132924

-- 
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/20200609/fe86262b/attachment.htm>