diff options
| author | Igor Babaev <igor@askmonty.org> | 2019-04-04 16:36:26 -0700 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2019-04-04 16:36:26 -0700 |
| commit | d2013e73288c953a6cbcdddf9688584c0353535d (patch) | |
| tree | af93870bb10b7eb6e1c4f7ca278a7c5fa01eb3d2 /mysql-test/main/partition_explicit_prune.test | |
| parent | ae15f91f227015b3e1ad3f566db9396232cf0a3f (diff) | |
| download | mariadb-git-d2013e73288c953a6cbcdddf9688584c0353535d.tar.gz | |
MDEV-18982 Partition pruning with column list causes syntax error in 10.4
A syntax error was reported for any INSERT statement with explicit
partition selection it if i used a column list.
Fixed by saving the parsing place before parsing the clause for explicit
partition selection and restoring it when the clause has been parsed.
Diffstat (limited to 'mysql-test/main/partition_explicit_prune.test')
| -rw-r--r-- | mysql-test/main/partition_explicit_prune.test | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/main/partition_explicit_prune.test b/mysql-test/main/partition_explicit_prune.test index b8b6e480ce9..a516527c055 100644 --- a/mysql-test/main/partition_explicit_prune.test +++ b/mysql-test/main/partition_explicit_prune.test @@ -877,3 +877,12 @@ UNLOCK TABLES; # Cleanup DROP TABLE t1, t2; + +--echo # +--echo # MDEV-18982: INSERT using explicit patition pruning with column list +--echo # + +create table t1 (a int) partition by hash(a); +insert into t1 partition (p0) (a) values (1); +select * from t1; +drop table t1; |