[MDEV-19324] Wrong results from query, using brackets with ORDER BY ..LIMIT Created: 2019-04-24  Updated: 2019-05-02  Resolved: 2019-04-30

Status: Closed
Project: MariaDB Server
Component/s: Parser
Affects Version/s: 10.4
Fix Version/s: 10.4.5

Type: Bug Priority: Major
Reporter: Alice Sherepa Assignee: Igor Babaev
Resolution: Fixed Votes: 0
Labels: None


 Description    

CREATE TABLE t1 (a INT);
 
INSERT INTO t1 VALUES (10),(20),(30);
 
SELECT a FROM t1 order by a desc limit 1;
 
(SELECT a FROM t1 order by a desc) limit 1;


MariaDB [test]> SELECT a FROM t1 order by a desc limit 1;
 
+------+
 
| a    |
 
+------+
 
|   30 |
 
+------+
 
1 row in set (0.002 sec)
 
 
 
MariaDB [test]> (SELECT a FROM t1 order by a desc) limit 1;
 
+------+
 
| a    |
 
+------+
 
|   10 |
 
+------+
 
1 row in set (0.001 sec)



 Comments   
Comment by Igor Babaev [ 2019-04-30 ]

A fix for this bug was pushed into 10.4

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