+++ 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. Alex
Please note that this is not a dup of 35683. Alex
This seems fixed in 3.4.x for an unknown x. I cannot reproduce with my own build of libreoffice-3.4 branch.