https://bugs.freedesktop.org/show_bug.cgi?id=68656
Priority: medium
Bug ID: 68656
Assignee: [email protected]
Summary: Database form referencing a column alias does not work
any more
Severity: major
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: x86 (IA32)
Status: UNCONFIRMED
Version: 4.0.4.1 rc
Component: Database
Product: LibreOffice
Created attachment 84786
--> https://bugs.freedesktop.org/attachment.cgi?id=84786&action=edit
The database SQL dump
I have a query that gives an alias for a column:
"projects"."name" AS "Project"
In the report builder it is possible to select this column "Project" for
grouping, but when I execute the query the error comes:
Column projects.Project does not exist
This worked in LO 3.6.
BTW I can't get around using the alias because in the actual application the
value for "Projects" is composite, e.g. "name" || "description" AS "Project"
To reproduce:
- Create an empty database "cdp" with owner postgres
- Import the SQL dump into this database using pgadmin3
- Create an odbc connection in /etc/odbc.ini:
[CDP-local]
Description = Connection to CDP database locally
Driver = PostgreSQL Unicode
Trace = No
TraceFile = /tmp/psqlodbc.log
Database = cdp
Servername = localhost
UserName =
Password =
Port =
ReadOnly = No
RowVersioning = No
ShowSystemTables = No
ShowOidColumn = No
FakeOidIndex = No
ConnSettings =
- Open the .odb file
- Open the only report (it might ask for the password of the postgres user)
- Error message comes up
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
