|
--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.
|