Bug 41405 - Reportbuilder makes wrong SQL from queries
Summary: Reportbuilder makes wrong SQL from queries
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
3.3.4 release
Hardware: x86 (IA32) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-10-02 09:41 UTC by Robert Großkopf
Modified: 2011-12-22 05:51 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Open the report - wrong SQL appears. It isn't the SQL of the query. (23.73 KB, application/vnd.sun.xml.base)
2011-10-02 09:41 UTC, Robert Großkopf 		Details
screenshot of the report (65.41 KB, image/png)
2011-10-29 06:49 UTC, Julien Nabet 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Robert Großkopf 2011-10-02 09:41:12 UTC 
Created attachment 51880 [details]
Open the report - wrong SQL appears. It isn't the SQL of the query.

A query is created for formatting and selecting one field. The query shows the correct field. When generating a report with this query (using it for grouping the report) the report would not start. It says: "column not found .... buchungen.Monat ...". There is no "buchungen"."Monat" in the query - only "Monat". So it could not be found. The wrong SQL-statement was created by the Report-Builder.
If I switch the report not to analyse the SQL-code the report works well.
Comment 1 Julien Nabet 2011-10-29 06:49:48 UTC 
Created attachment 52885 [details]
screenshot of the report

I tried to reproduce the pb without success.
I'm on Debian pc x86-32 and I used the Debian packages 3.4.3.

Could you give your environment (Windows, Mac, Linux), the platform (x86-32, x86-64/AMD64, other ?) ?
With which version have you had this pb ? If not 3.4.3, could you please test again with 3.4.3 ?
Comment 2 Robert Großkopf 2011-10-29 09:44:31 UTC 
My system: OpenSuSE 11.4, x86/32, LibreOffice 3.3.4
When trying to start the report it added (attachment 51880 [details]) it crashes: Wrong SQL ...
In version LibreOffice 3.4.x new bugs will appear. I will not change this system. My daugther has changed it to 3.4.2 on her laptop. Databases with a macro crashed - also with a SQL-error. This databases work on 3.3.4.

Robert
Comment 3 Robert Großkopf 2011-10-30 02:26:27 UTC 
I have tested it with original LibreOffice 3.4.3 on OpenSuSE 11.4, 32 Bit.
The report works without SQL-error.
I have changed the version to 3.3.4
Comment 4 Julien Nabet 2011-10-30 02:54:10 UTC 
So if there's no error in 3.4.3 and it concerned only 3.3.4, we can say it this bug has been resolved/fixed. Great !
Comment 5 Korrawit Pruegsanusak 2011-10-30 03:04:57 UTC 
(In reply to comment #4)
> So if there's no error in 3.4.3 and it concerned only 3.3.4, we can say it this
> bug has been resolved/fixed. Great !

Please don't use FIXED if no known fix :) Setting as WORKSFORME.
Comment 6 Björn Michaelsen 2011-12-22 05:51:58 UTC 
RESOLVED, FIXED or CLOSED bugs cant be KEYWORD NEEDINFO.