[MDEV-18988] Wrong result when query with group by x order by y limit n Created: 2019-03-21  Updated: 2019-04-25  Resolved: 2019-04-25

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Spider
Affects Version/s: None
Fix Version/s: 10.4.5

Type: Bug Priority: Major
Reporter: willhan Assignee: Kentoku Shiba (Inactive)
Resolution: Fixed Votes: 0
Labels: None


 Description   

Wrong result when query with group by x order by y limit n
query: select a, count from t group by a order by 2 desc limit n
before distribution: select a, count from t group by a order by 2 desc limit n
now distribution: select a, count from t group by a order by 2 desc

 Comments   
Comment by Kentoku Shiba (Inactive) [ 2019-04-23 ]

willhan
I just fixed this. Please check test results of the following commit.
49a3c89e

Comment by willhan [ 2019-04-25 ]

It' ok

Comment by Kentoku Shiba (Inactive) [ 2019-04-25 ]

merging

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