--echo #
--echo # Bug#42991 "invalid memory access and/or crash when using
--echo #            index condition pushdown + InnoDB"
--echo #

# Note that you need to run with --valgrind to see the warnings
# about invalid memory accesses.

--source include/have_debug.inc
--source include/have_innodb.inc

# Until ICP is on by default in InnoDB we need to set this.
set session debug="+d,optimizer_innodb_icp";

CREATE TABLE t1 (
  c1 TINYTEXT,
  c2 INT NOT NULL,
  PRIMARY KEY (c2),
  KEY id1 (c1(4))
) ENGINE=InnoDB;

INSERT INTO t1 VALUES ('Anastasia', 5);
INSERT INTO t1 VALUES ('Karianne', 4);

SELECT * FROM t1 WHERE (c1 <= '6566-06-15' AND c2 <> 3);

DROP TABLE t1;