Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.4(EOL)
Description
https://mariadb.com/kb/en/library/insert/
The syntax documented by the page above
INSERT
|
INTO tbl_name PARTITION (partition_list) (col,...)
|
VALUES (expr,...),(...)
|
worked on 10.0-10.3, but not on 10.4:
MariaDB [test]> insert into tp partition (p1) (a) values (1); |
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 'a) values (1)' at line 1 |
MariaDB [test]> select @@version; |
+----------------------+ |
| @@version |
|
+----------------------+ |
| 10.4.1-MariaDB-debug |
|
+----------------------+ |
1 row in set (0.00 sec) |
MariaDB [test]> insert into tp partition (p1) (a) values (1); |
Query OK, 1 row affected (0.04 sec)
|
 |
MariaDB [test]> select @@version; |
+-----------------------+ |
| @@version |
|
+-----------------------+ |
| 10.3.12-MariaDB-debug |
|
+-----------------------+ |
1 row in set (0.00 sec) |
Attachments
Issue Links
- duplicates
-
MDEV-18982 Partition pruning with column list causes syntax error in 10.4
- Closed