diff options
| author | Aleksey Midenkov <midenok@gmail.com> | 2019-11-25 17:24:09 +0300 |
|---|---|---|
| committer | Aleksey Midenkov <midenok@gmail.com> | 2019-11-25 17:24:09 +0300 |
| commit | 0c05a2ed71ebf408e32f7fcdd358d756948d8a5d (patch) | |
| tree | fabe919df6b001b22391f37c7a32a1e34a6bfd79 /mysql-test/suite/versioning/t/partition.test | |
| parent | 7c7f9bef28aa566557da31402142f6dd8298ddd2 (diff) | |
| parent | f9ceb0a67ffb20631c936a7e8e8776c000d677ac (diff) | |
| download | mariadb-git-0c05a2ed71ebf408e32f7fcdd358d756948d8a5d.tar.gz | |
Merge 10.4 into 10.5
Diffstat (limited to 'mysql-test/suite/versioning/t/partition.test')
| -rw-r--r-- | mysql-test/suite/versioning/t/partition.test | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/suite/versioning/t/partition.test b/mysql-test/suite/versioning/t/partition.test index c8c06b2858e..64c4bc247c0 100644 --- a/mysql-test/suite/versioning/t/partition.test +++ b/mysql-test/suite/versioning/t/partition.test @@ -487,4 +487,18 @@ select PARTITION_NAME, PARTITION_METHOD, PARTITION_DESCRIPTION from information_ drop view v1; drop tables t, t1, t2, t3, t4; +--echo # +--echo # MDEV-18957 UPDATE with LIMIT clause is wrong for versioned partitioned tables +--echo # +create or replace table t1 ( + x int, + a varchar(255) +) with system versioning partition by system_time (partition p1 history, partition pn current); + +insert into t1 (x) values (1), (2), (3), (4); +update t1 set a= 'foo' limit 3; +update t1 set a= 'bar' limit 4; +select * from t1; +drop table t1; + --source suite/versioning/common_finish.inc |