mysql-test/suite/parts/t/update_and_cache.test
raw| 1 | --source include/have_partition.inc |
| 2 | |
| 3 | CREATE TABLE t1 (pk INT PRIMARY KEY, a INT); |
| 4 | INSERT INTO t1 VALUES (1,10),(2,20); |
| 5 | |
| 6 | CREATE TABLE t2 (b INT) PARTITION BY KEY (b) PARTITIONS 2; |
| 7 | INSERT INTO t2 VALUES (1),(2); |
| 8 | |
| 9 | DELETE t2 FROM t2 WHERE b BETWEEN 5 AND 9; |
| 10 | UPDATE t2 JOIN t1 SET b = 5; |
| 11 | |
| 12 | DROP TABLE t1, t2; |