Debian Codegraph @

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;