SET STORAGE_ENGINE = Falcon;
#---- Bug 226 ----
DROP TABLE IF EXISTS t1;
DROP TABLE IF EXISTS t2;
DROP TABLE IF EXISTS t3;
CREATE TABLE t1 (a char(50),KEY (a)) CHARSET utf8;
CREATE TABLE t2 (a char(1),PRIMARY KEY (a));
CREATE TABLE t3 (a char(5));
ALTER TABLE t3 ADD UNIQUE KEY (a);
INSERT INTO t1 VALUES ('u');
INSERT INTO t1 VALUES ('U');
SELECT count(*) FROM t1 WHERE a = 'u';
count(*)
2
SELECT count(*) FROM t1 WHERE a = 'U';
count(*)
2
INSERT INTO t2 VALUES ('c');
SELECT * FROM t2 WHERE a < '_';
a
c
SELECT * FROM t2 WHERE a > '_';
a
SELECT * FROM t2 WHERE a = '_';
a
SELECT * FROM t2 WHERE a LIKE '_';
a
c
INSERT INTO t3 VALUES ('I');
INSERT INTO t3 VALUES ('i');
ERROR 23000: Duplicate entry 'i' for key 'a'
DROP TABLE t1;
DROP TABLE t2;
DROP TABLE t3;
