Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Minor
-
Resolution: Unresolved
-
5.5, 10.0, 10.1, 10.1.33, 10.2.14, 10.2, 10.3
Description
mysql -A
|
Welcome to the MariaDB monitor. Commands end with ; or \g.
|
Your MariaDB connection id is 13
|
Server version: 10.1.33-MariaDB MariaDB Server
|
|
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
|
|
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
|
|
MariaDB [(none)]> use test
|
Database changed
|
MariaDB [test]> CREATE TABLE actor_backticks_around_p1 ( actor_id smallint(5) unsigned NOT NULL AUTO_INCREMENT, first_name varchar(45) NOT NULL, last_name varchar(45) NOT NULL, last_update timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (actor_id,last_update), KEY idx_actor_last_name (last_name), KEY last_update (last_update) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 PARTITION BY RANGE (unix_timestamp(last_update)) (PARTITION p0 VALUES LESS THAN (1522900800) ENGINE = InnoDB, PARTITION `p1` VALUES LESS THAN (1522987200) ENGINE = InnoDB);
|
ERROR 1479 (HY000): Syntax error: RANGE PARTITIONING requires definition of VALUES LESS THAN for each partition
|
Can be reproduced on 10.1 and 10.2
Will work fine if no backticks around 'p1'