[Libreoffice-bugs] [Bug 41405] New: Reportbuilder makes wrong SQL from queries

bugzilla-daemon at freedesktop.org bugzilla-daemon at freedesktop.org
Sun Oct 2 09:41:13 PDT 2011


           Summary: Reportbuilder makes wrong SQL from queries
           Product: LibreOffice
           Version: unspecified
          Platform: x86 (IA32)
        OS/Version: Linux (All)
            Status: NEW
          Severity: normal
          Priority: medium
         Component: Database
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: robert at familiegrosskopf.de

Created an attachment (id=51880)
 --> (https://bugs.freedesktop.org/attachment.cgi?id=51880)
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
If I switch the report not to analyse the SQL-code the report works well.

Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

More information about the Libreoffice-bugs mailing list