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