Issue 120457 - ORDER By removed when a saved query is edited
Summary: ORDER By removed when a saved query is edited
Status: CLOSED DUPLICATE of issue 121096
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: 3.4.0
Hardware: All All
: P3 Normal (vote)
Target Milestone: 4.2.0
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-08-03 16:11 UTC by telocker02
Modified: 2016-11-06 16:42 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.1.2
Developer Difficulty: ---

Attachments
Test base (24.50 KB, application/octet-stream)
2013-02-17 17:07 UTC, Jacques-64 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description telocker02 2012-08-03 16:11:52 UTC 
a forum discussion regarding the bug is here:
http://www.oooforum.org/forum/viewtopic.phtml?p=511136#511136

When a saved query is edited the order by statement is lost. This occurs whether using the GUI and selecting the sort order or when writing the query as SQL text.

I have replicated this on 3.4.0 running on OS-mountain lion and on windows XP.
Comment 1 Jacques-64 2013-02-17 17:07:58 UTC 
Created attachment 80293 [details]
Test base
Comment 2 Jacques-64 2013-02-17 17:13:28 UTC 
This issue is present with AOo 3.4.1 
See thread (in french) : http://forum.openoffice.org/fr/forum/viewtopic.php?f=9&t=37461&p=206117#p206117

Test base attached here. When you edit a request with SQL everything is OK.
If you edit it with the builder, first time "ORDER By" diseapear from the view but is still executed.
Second time, there is no more ORDER BY in the view nor SQL

Tested on OS Win XP-SP3. Another contributor confirmed with AOo & not with LiBo.
Comment 3 gg43 2013-04-03 23:56:16 UTC 
Platform: 
Operating System: Windows 7 Home Premium Version 6.1.7601 Service Pack 1 Build 7601 (x64)
Apache Open Office 3.4.1 AOO341m1 Build 9593 Rev 1372282

Base - Query
If you are working with the "Edit SQL" I have not seen reported errors.

If you are working with the "Edit" I confirm that the previous settings of the parameter "Order by" are lost, the system does not fill out this parameter, and so if you do not manually reset, the previous settings for this parameter are lost when you save the modified query. .
Comment 4 damjan 2016-11-06 16:01:47 UTC 
Fixed by revision 1713502 in bug 121096, resolving duplicate.

*** This issue has been marked as a duplicate of issue 121096 ***