Created attachment 84786 [details]
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