Bug 47560 - EDITING: queries open for reediting: only last out-of-order sort column kept (duplicated)
Summary: EDITING: queries open for reediting: only last out-of-order sort column kept ...
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
3.4.4 release
Hardware: All All
: medium critical
Assignee: Lionel Elie Mamane
URL:
Whiteboard: target:3.6.0 target:3.5.2
Keywords:
Depends on: 47370
Blocks: mab3.5
  Show dependency tree / graph
 
Reported: 2012-03-20 02:54 UTC by Lionel Elie Mamane
Modified: 2012-03-20 04:51 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
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 Lionel Elie Mamane 2012-03-20 02:54:16 UTC 
+++ This bug was initially created as a clone of Bug #47370 +++

Found in versions:
 * branch libreoffice-3-5 with fix for bug 47370 applied.

Reproduction case: attachment 57874 [details] from bug 46843

Open query order_job_name in SQL mode. Add:
 , "number" ASC
to the end of the SQL to add sorting by number after job and name.

Open in design mode (graphical editor). Order becomes "job, number, number": number is there twice:

column:   name      job    number  number
table:    tbl1      tbl1   tbl1    tbl1
sort:     (none)    asc    asc     asc
display:   yes      yes    no      no

(I'll commit the fix in a few minutes)
Comment 1 Not Assigned 2012-03-20 03:10:46 UTC 
Lionel Elie Mamane committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=9f6e09e241921c6c4260ab530374de8d5ccd4267

fdo#47560 properly separate each new sorting column
Comment 2 Not Assigned 2012-03-20 04:42:47 UTC 
Lionel Elie Mamane committed a patch related to this issue.
It has been pushed to "libreoffice-3-5":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=1523e93bfc9a5d96fa519c801e904aab82a2b4d4&g=libreoffice-3-5

fdo#47560 properly separate each new sorting column


It will be available in LibreOffice 3.5.2.