[MDEV-19325] Wrong results of query, using brackets and LIMIT and VALUES() Created: 2019-04-24  Updated: 2019-05-20  Resolved: 2019-05-20

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

Type: Bug Priority: Major
Reporter: Alice Sherepa Assignee: Alice Sherepa
Resolution: Duplicate Votes: 0
Labels: None

Issue Links:
Duplicate
duplicates MDEV-17894 Assertion `(thd->lex)->current_select... Closed

 Description   

MariaDB [test]> SELECT 1 union (values (2),(4) limit 1);
+---+
| 1 |
+---+
| 1 |
| 2 |
| 4 |
+---+
3 rows in set (0.001 sec)
 
MariaDB [test]> values (2),(4) limit 1;
+---+
| 2 |
+---+
| 2 |
+---+
1 row in set (0.000 sec)


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