[Libreoffice-bugs] [Bug 117897] New: base/postgres seem to use ODBC brace construct, query fail (...FROM { oj "field"...)

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 117897
           Summary: base/postgres seem to use ODBC brace construct, query
                    fail (...FROM { oj "field"...)
           Product: LibreOffice
           Version: 6.0.4.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: grin at grin.hu

Description:
Using postgres connectot LO seems to use ODBC brace constructs, which causes
the query fail.
It was triggered by creating a simple query joining two tables.

Seems " { oj " is some odbc macro wants to be expanded, which doesn't happen in
the postgres driver.

The generated SQL:
SELECT "t3"."nev", "t3"."szam", "t3-nev"."AccountType", "t3-nev"."Description",
"t3-nev"."AccountNumber", "t3-cim"."varos", "t3-cim"."utca", "t3"."jog1",
"t3"."jog2", "t3"."jog3", "t3"."jog4" FROM { oj "public"."t3-cim" "t3-cim"
RIGHT OUTER JOIN "public"."t3" "t3" ON "t3-cim"."szam" = "t3"."szam" LEFT OUTER
JOIN "public"."t3-nev" "t3-nev" ON "t3-nev"."AccountName" = "t3"."nev" } ORDER
BY "t3"."nev" ASC, "t3"."szam" ASC


Steps to Reproduce:
see above

Actual Results:  
error popup.

Expected Results:
running the query.


Reproducible: Always


User Profile Reset: No



Additional Info:


User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:62.0) Gecko/20100101
Firefox/62.0

-- 
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/20180530/32bcf39c/attachment.html>