SET STORAGE_ENGINE = Falcon;
#
# Mantis bug #225: UCS2 searches fail if index exists
#
--echo *** Bug #225 ***
--disable_warnings
DROP TABLE IF EXISTS t1;
--enable_warnings

CREATE TABLE t1 (
  a char(50),
  PRIMARY KEY (a)
) CHARSET ucs2 COLLATE ucs2_bin;

INSERT INTO t1 VALUES ('u');
SELECT count(*) FROM t1 WHERE a = 'u';

# Final cleanup.
DROP TABLE t1;
