[Libreoffice-bugs] [Bug 133823] Firebird: Alias in a query will give "CASE" as column name in a form, if a field with same name existed
https://bugs.documentfoundation.org/show_bug.cgi?id=133823 Andreas Heinisch changed: What|Removed |Added Resolution|--- |DUPLICATE Status|NEW |RESOLVED --- Comment #4 from Andreas Heinisch --- Should be fixed with Bug 132924. *** This bug has been marked as a duplicate of bug 132924 *** -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 133823] Firebird: Alias in a query will give "CASE" as column name in a form, if a field with same name existed
https://bugs.documentfoundation.org/show_bug.cgi?id=133823 debewerk...@kpnplanet.nl changed: What|Removed |Added CC||debewerk...@kpnplanet.nl --- Comment #3 from debewerk...@kpnplanet.nl --- Comment on attachment 161809 --> https://bugs.documentfoundation.org/attachment.cgi?id=161809 Test the two forms. Press the button: different column names will be shown with the same SQL-code. I experienced identical behaviour and like to strengthen Alex Thurgoods vision. In a base query with SQL ( excerpt: CURRENT_DATE AS "datum", 'F' || "IDgbwriter" || "volgnr" AS "filenaam", ( "tblgb"."gb" - TRUNC( "tblgb"."gb", - 2 ) ) * 1000 + "volgnr" AS "factuurnummer") the aliases are correctly displayed in the query GUI, however the same SQL string in a basic macro evaluated with the PrepareStatement( stringSQL ) and executeQuery()shows that the given alias names are ignored, and reassigned as "CURRENT_DATE" , ADD3 , CONCAT and the like. -- 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
[Libreoffice-bugs] [Bug 133823] Firebird: Alias in a query will give "CASE" as column name in a form, if a field with same name existed
https://bugs.documentfoundation.org/show_bug.cgi?id=133823 Alex Thurgood changed: What|Removed |Added Whiteboard| QA:needsComment| --- Comment #2 from Alex Thurgood --- Seems like the parser can't handle the CASE WHEN statement and just segments after the first space taking CASE as the column name. Could be that this is indeed a DUP of bug 1329294. -- 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
[Libreoffice-bugs] [Bug 133823] Firebird: Alias in a query will give "CASE" as column name in a form, if a field with same name existed
https://bugs.documentfoundation.org/show_bug.cgi?id=133823 Alex Thurgood changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED |NEW --- Comment #1 from Alex Thurgood --- Confirming with Version : 6.4.4.2 Build ID : 3d775be2011f3886db32dfd395a6a6d1ca2630ff Threads CPU : 8; OS : Mac OS X 10.15.5; UI Render : par défaut; VCL: osx; Locale : fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR Calc: threaded -- 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
[Libreoffice-bugs] [Bug 133823] Firebird: Alias in a query will give "CASE" as column name in a form, if a field with same name existed
https://bugs.documentfoundation.org/show_bug.cgi?id=133823 Alex Thurgood changed: What|Removed |Added OS|Linux (All) |All -- 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
[Libreoffice-bugs] [Bug 133823] Firebird: Alias in a query will give "CASE" as column name in a form, if a field with same name existed
https://bugs.documentfoundation.org/show_bug.cgi?id=133823 QA Administrators changed: What|Removed |Added Whiteboard|| QA:needsComment -- 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
[Libreoffice-bugs] [Bug 133823] Firebird: Alias in a query will give "CASE" as column name in a form, if a field with same name existed
https://bugs.documentfoundation.org/show_bug.cgi?id=133823 Robert Großkopf changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=13 ||2924 -- 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
