SET @@storage_engine = Falcon;
#
# Bug #23692: Falcon: searches fail if data is 0x00
#
--echo *** Bug #23692 ***
--disable_warnings
DROP TABLE IF EXISTS t1;
DROP TABLE IF EXISTS t2;
--enable_warnings

CREATE TABLE t1 (a char(1), key (a));
INSERT INTO t1 VALUES (0x00);
SELECT * FROM t1 WHERE a < '';

CREATE TABLE t2 (a varbinary(5));
CREATE INDEX i ON t2 (a);
INSERT INTO t2 VALUES (0x02), (0x0202);
SELECT count(*) FROM t2 WHERE a >= 0x02 OR a = 0x0202;

# Final cleanup.
DROP TABLE t1;
DROP TABLE t2;
