Bug 33236 - PostgreSQL fully qualified table name generated as "schema.table" instead of "schema"."table"
Summary: PostgreSQL fully qualified table name generated as "schema.table" instead of ...
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
3.3.0 RC3
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: regression
Depends on:
Blocks:
 
Reported: 2011-01-18 04:08 UTC by Lionel Elie Mamane
Modified: 2011-08-12 08:36 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Lionel Elie Mamane 2011-01-18 04:08:59 UTC
+++ 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).
Comment 1 Alex Thurgood 2011-05-28 22:55:47 UTC

*** This bug has been marked as a duplicate of bug 35683 ***
Comment 2 Alex Thurgood 2011-05-28 22:56:32 UTC
My bad, sorry, closed wrong report by mistake.

Alex
Comment 3 Alex Thurgood 2011-05-28 22:59:35 UTC
Please note that this is not a dup of 35683.

Alex
Comment 4 Lionel Elie Mamane 2011-08-12 08:36:22 UTC
This seems fixed in 3.4.x for an unknown x. I cannot reproduce with my own build of libreoffice-3.4 branch.