[MDEV-17790] order by desc (descending) parameter ignored if multiple expressions specified. Created: 2018-11-21  Updated: 2018-11-23  Resolved: 2018-11-23

Status: Closed
Project: MariaDB Server
Component/s: Optimizer
Affects Version/s: 10.2.18
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Colin Leavett-Brown Assignee: Sergei Golubchik
Resolution: Not a Bug Votes: 0
Labels: None
Environment:

CentOS Linux release 7.5.1804 (Core)

Attachments: HTML File bug_table2    

 Description   

Table (mysqldump of bug_table2 attached) with two columns, "group_name" and "priority".
1. The command "select * from bug_table2 order by priority desc;" produces correct descending output.
2. The command "select * from bug_table2 order by priority,group_name desc;" produces incorrect ascending output.

 Comments   
Comment by Colin Leavett-Brown [ 2018-11-21 ]

You can close this; I now realize that I should be specifying "order by priority desc, group_name desc".

Generated at Thu Feb 08 08:39:08 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.