SET STORAGE_ENGINE = Falcon;
#
# Mantis bug #234: Binary use fails if index exists
#
--echo *** Bug #234 ***
--disable_warnings
DROP TABLE IF EXISTS t315;
--enable_warnings

CREATE TABLE t315 (s1 binary(5));
CREATE INDEX it315 ON t315 (s1);
INSERT INTO t315 VALUES (0x0001020300),(0x0001020300),(0x0001020300);

SELECT hex(s1) FROM t315 WHERE s1=0x0001020300;

# Final cleanup
DROP TABLE t315;
