https://bugs.documentfoundation.org/show_bug.cgi?id=101732
--- Comment #1 from Marc Bantle <m...@rcie.de> ---
Created attachment 127030
--> https://bugs.documentfoundation.org/attachment.cgi?id=127030&action=edit
Error message when using a postgres SDBC driver
When using the SDBC-Driver for postgres (libreoffice-sdbc-postgresql
(1:5.1.4-0ubuntu1)) the error message is a bit more detailed.
It appears, that postgres does not support a column alias directly after the
column name without the keyword AS in between. LibreOffice seems to create
exactly that syntax (SELECT columnname columnalias FROM tablename).
The error only occurs when executing an SQL query or the query designer.
Unlike with JDBC-driver the SDBC-driver seems to pass the query through to the
DBMS unchanged, if executing a SQL-pass-thru query. So using aliases with SDBC
and pass-through works fine.
--
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
