Debian Codegraph @

mysql-test/suite/parts/t/partition_icp.test

raw
1 --echo #
2 --echo # test using Index Condition Pushdown for partitioned tables
3 --echo #
4
5 --echo # Test behavior of ICP calls -> use ICP for InnoDB even for BLOB indexes.
6
7 CREATE TABLE t1 (a int PRIMARY KEY, b BLOB, c varchar(16) DEFAULT 'Filler...', INDEX (b(4), a))
8 PARTITION BY HASH (a) PARTITIONS 3;
9
10 SHOW CREATE TABLE t1;
11
12 INSERT INTO t1 (a, b) VALUES (1, 0xdeadbeef), (2, "text filler"),
13 (3, 'filler...'), (4, " more filler "), (5, "test text"), (6, "testing...");
14
15 ANALYZE TABLE t1;
16
17 let $query= SELECT a, HEX(b) FROM t1 WHERE b >= 'te' and (a % 2);
18 eval EXPLAIN $query;
19 --skip_if_hypergraph # Depends on the query plan.
20 eval EXPLAIN FORMAT=JSON $query;
21 eval $query;
22
23 DROP TABLE t1;