SET STORAGE_ENGINE = Falcon;
#
# Bug #23689: Falcon: searches fail if exotic collation and index exists
#
--echo *** Bug #23689 ***
--disable_warnings
DROP TABLE IF EXISTS t1;
--enable_warnings

SET NAMES utf8;
CREATE TABLE t1 (a char(5) character set latin1 collate latin1_german2_ci);

INSERT INTO t1 VALUES ('UE'), ('Ü');
SELECT count(*) FROM t1 WHERE a = 'UE';

CREATE INDEX i1 on t1 (a);
SELECT count(*) FROM t1 WHERE a = 'UE';

# Final cleanup.
DROP TABLE t1;
