[MDEV-13017] LOCK TABLE fails with irrelevant error while working with tables affected by ANSI_QUOTES Created: 2017-06-06  Updated: 2020-08-25  Resolved: 2017-06-19

Status: Closed
Project: MariaDB Server
Component/s: Partitioning
Affects Version/s: 5.5, 10.0, 10.1, 10.2
Fix Version/s: 10.1.25, 5.5.57, 10.0.32, 10.2.7

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: upstream-fixed

Issue Links:
Relates
relates to MDEV-13089 identifier quoting in partitioning Closed

 Description   

--source include/have_partition.inc
 
SET sql_mode='ANSI_QUOTES';
 
CREATE TABLE t1 (i INT) 
PARTITION BY RANGE (i)
(PARTITION flush VALUES LESS THAN MAXVALUE);
 
CREATE TABLE t2 LIKE t1;
 
SET @@SQL_MODE='';
LOCK TABLES `t1` READ LOCAL,`t2` READ LOCAL;

MariaDB [test]> LOCK TABLES `t1` READ LOCAL,`t2` READ LOCAL;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"flush" VALUES LESS THAN MAXVALUE ENGINE = InnoDB)' at line 2

Reproducible both with MTR and MySQL client.



 Comments   
Comment by Elena Stepanova [ 2017-06-06 ]

Reproducible on 5.5-10.2 and MySQL 5.6, but not MySQL 5.7.

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