--echo #
--echo # test using Index Condition Pushdown for partitioned tables
--echo #

--echo # Test behavior of ICP calls -> use ICP for InnoDB even for BLOB indexes.

CREATE TABLE t1 (a int PRIMARY KEY, b BLOB, c varchar(16) DEFAULT 'Filler...', INDEX (b(4), a))
PARTITION BY HASH (a) PARTITIONS 3;

SHOW CREATE TABLE t1;

INSERT INTO t1 (a, b) VALUES (1, 0xdeadbeef), (2, "text filler"),
(3, 'filler...'), (4, " more filler "), (5, "test text"), (6, "testing...");

ANALYZE TABLE t1;

let $query= SELECT a, HEX(b) FROM t1 WHERE b >= 'te' and (a % 2);
eval EXPLAIN $query;
eval EXPLAIN FORMAT=JSON $query;
eval $query;

DROP TABLE t1;