https://bugs.documentfoundation.org/show_bug.cgi?id=101732
Bug ID: 101732
Summary: Syntax error when using column alias on postgres
database
Product: LibreOffice
Version: 5.1.4.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: m...@rcie.de
Created attachment 127029
--> https://bugs.documentfoundation.org/attachment.cgi?id=127029&action=edit
Error message when using a postgres JDBC driver
Specifying a column alias on a statement against a postgres database via jdbc
driver creates a database syntax error as shown in the attached screen shot.
The error occures no matter whether an SQL query, the query designer or a
pass-through query is used executed.
JDBC-Drivers tested:
postgresql-jdbc3-8.3.jar
postgresql-jdbc3-9.2.jar
postgresql-jdbc4-9.2.jar
All the above (SQL query, the query designer or a pass-through query) can be
executed if no alias is used.
This error does not occure in libreoffice-base 4.2.8-0ubuntu4. All jdbc drivers
work.
--
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
