[MDEV-19040] Error after using SQL_NO_CACHE clause with brackets Created: 2019-03-25  Updated: 2019-03-25

Status: Confirmed
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.4
Fix Version/s: 10.4

Type: Bug Priority: Major
Reporter: Alice Sherepa Assignee: Oleksandr Byelkin
Resolution: Unresolved Votes: 0
Labels: None


 Description   

create table t1 (a int);
insert into t1 values (1),(2),(3),(4),(5);
select sql_no_cache * from t1 order by a limit 1; 
(select sql_no_cache * from t1 order by a) limit 1; #error

MariaDB [test]> select sql_no_cache * from t1 order by a limit 1; #
+------+
| a    |
+------+
|    1 |
+------+
1 row in set (0.000 sec)
 
MariaDB [test]> (select sql_no_cache * from t1 order by a) limit 1;
ERROR 1234 (42000): Incorrect usage/placement of 'SQL_NO_CACHE'


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