+++ This bug was initially created as a clone of Bug #32964 +++
Create a report, e.g. based on the following query:
SELECT "T"."A", "T"."B", "T"."C", "T"."D" FROM "S"."T" AS "T"
The report has "analyze SQL command" set to "yes".
Edit the report.
Menu View, Sorting.
Add a grouping level, for example on column B.
Try to execute the report: it does not work, one gets SQL error from PostgreSQL:
missing FROM-clause entry for table "S.T"
That's because the SQL command sent to PostgreSQL looks like:
SELECT "T"."A", "T"."B", "T"."C", "T"."D" FROM "S"."T" AS "T" ORDER BY "S.T"."B"
The fully qualified name for that table is "S"."T", not "S.T": the escaping is wrong.
I reproduced this bug with:
- Debian package of LibreOffice version 1:3.3.0~rc2-3.
- self-build of master git branch, with OpenJDK 6b18-1.8.3-2
- Debian package 1:3.3.0~rc3-2, with OpenJDK 6b18-1.8.3-2
- Debian package 1:3.3.0~rc3-2, with gcj 4:4.4.5-2
*Not* getting this bug with:
- OpenOffice 3.2.1 (Debian package 1:3.2.1-11) with gcj 4:4.4.5-1
- OpenOffice 3.2.1 (Debian package 1:3.2.1-11) with OpenJDK 6b18-1.8.3-2
All tests done with sdbc PostgreSQL driver, version 0.7.6, from Debian package (OpenOffice or LibreOffice, as the case may be).
*** This bug has been marked as a duplicate of bug 35683 ***
My bad, sorry, closed wrong report by mistake.
Please note that this is not a dup of 35683.
This seems fixed in 3.4.x for an unknown x. I cannot reproduce with my own build of libreoffice-3.4 branch.