[Libreoffice-bugs] [Bug 33239] RPT: "ORDER BY" clause dropped in "analyze sql: no" case

bugzilla-daemon at freedesktop.org bugzilla-daemon at freedesktop.org
Wed Jul 11 22:32:50 CEST 2012


https://bugs.freedesktop.org/show_bug.cgi?id=33239

Lionel Elie Mamane <lionel at mamane.lu> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |UNCONFIRMED
         Resolution|WORKSFORME                  |
     Ever Confirmed|1                           |0

--- Comment #5 from Lionel Elie Mamane <lionel at mamane.lu> 2012-07-11 13:32:50 PDT ---
Confirmed in features/base-preview after all, but:

 - If the SQL command has an "ORDER BY" *and* the report does not
   have any grouping / sorting, *then* the SQL's "ORDER BY" is obeyed.

 - If the SQL command has an "ORDER BY" *and* the report *has*
   some grouping / sorting, *then* the SQL's "ORDER BY" is  dropped
   (and the report's grouping / sorting is dropped *too*, but that's bug
33240).

-- 
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