EVOLUTION-MANAGER

Edit File: index_unique_varchar.result

DROP TABLE IF EXISTS users; CREATE TABLE users ( name varchar(100) NOT NULL, UNIQUE KEY name (name) ) DEFAULT CHARSET=utf8; INSERT INTO users VALUES ("Alice"); INSERT INTO users VALUES ("Bob"); SELECT * FROM users; name Alice Bob SELECT * FROM users WHERE name = "aLiCe"; name Alice DROP TABLE users;