SET STORAGE_ENGINE = Falcon;
#
# Bug #23962: Wrong results with > search
#
--echo *** Bug #23962 ***
--disable_warnings
DROP TABLE IF EXISTS t1;
--enable_warnings

CREATE TABLE t1 (a char(5), KEY (a));
INSERT INTO t1 VALUES ('a'), ('aa'), ('aaa'), ('abc'), ('bbb');

SELECT * FROM t1 WHERE a > 'a'  ORDER BY a;
SELECT * FROM t1 WHERE a > 'aa' ORDER BY a;

# Final cleanup.
DROP TABLE t1;
