SET storage_engine = Falcon;
#
# Mantis bug #155: Partial indexing failure
#
--echo *** Bug #155 ***
--disable_warnings
DROP TABLE IF EXISTS t2;
--enable_warnings

CREATE TABLE t2 (s1 varchar(5));
CREATE INDEX i2 ON t2 (s1(1));
INSERT INTO t2 VALUES ('b'),('ba');

SELECT * FROM t2 WHERE s1 = 'b';
SELECT * FROM t2 WHERE s1 = 'ba';

# Final cleanup
DROP TABLE t2;
