EVOLUTION-MANAGER

Edit File: column_enum_less_with_index.result

DROP TABLE IF EXISTS items; CREATE TABLE items ( name VARCHAR(255), size ENUM("small", "medium", "large"), INDEX (size) ) ENGINE=Mroonga DEFAULT CHARSET=utf8; SHOW CREATE TABLE items; Table Create Table items CREATE TABLE `items` ( `name` varchar(255) DEFAULT NULL, `size` enum('small','medium','large') DEFAULT NULL, KEY `size` (`size`) ) ENGINE=Mroonga DEFAULT CHARSET=utf8 INSERT INTO items VALUES ("t-shart for child", "small"); INSERT INTO items VALUES ("leadies' coat", "medium"); INSERT INTO items VALUES ("parka", "large"); INSERT INTO items VALUES ("hat", "medium"); SELECT * FROM items; name size t-shart for child small leadies' coat medium parka large hat medium SELECT * FROM items WHERE size = "medium"; name size leadies' coat medium hat medium DROP TABLE items;