[Libreoffice-bugs] [Bug 141579] Create Query in Design View Query Builder build SQL that aliases table name to itself causing some ODBC and JDBC database queries to fail

[bugzilla-daemon at bugs.documentfoundation.org]

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

Robert Großkopf <robert at familiegrosskopf.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |robert at familiegrosskopf.de

--- Comment #1 from Robert Großkopf <robert at familiegrosskopf.de> ---
Have tested this with internal HSQLDB (LO 7.1.2.2) on OpenSUSE 15.2 64bit rpm
Linux. There doesn't appear an alias for the table automatically.

Then I tried it with MariaDB/JDBC on the same machine. It sets an alias,
because the table will be defined by `database`.`tablename`. So it creates
SELECT `ID`, `Name` FROM `test`.`Person` `Person`
There is no option to append the tablename for MariaDB, only to set "AS" for an
alias there.

Have no other connection to other databases working here, so I can't test
special behavior of other databases.

-- 
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/20210424/30877229/attachment.htm>