EVOLUTION-MANAGER

Edit File: column_set_8_with_index.result

DROP TABLE IF EXISTS items; CREATE TABLE items ( name VARCHAR(255), colors SET("black", "dim gray", "dark gray", "gray", "light gray", "gainsboro", "white smoke", "white"), INDEX (colors) ) DEFAULT CHARSET=utf8; SHOW CREATE TABLE items; Table Create Table items CREATE TABLE `items` ( `name` varchar(255) DEFAULT NULL, `colors` set('black','dim gray','dark gray','gray','light gray','gainsboro','white smoke','white') DEFAULT NULL, KEY `colors` (`colors`) ) ENGINE=Mroonga DEFAULT CHARSET=utf8 INSERT INTO items VALUES ("t-shart", "black,gray"); INSERT INTO items VALUES ("hat", "dim gray,dark gray"); INSERT INTO items VALUES ("parka", "white smoke,light gray"); SELECT * FROM items; name colors t-shart black,gray hat dim gray,dark gray parka light gray,white smoke SELECT * FROM items WHERE colors = "dim gray,dark gray"; name colors hat dim gray,dark gray DROP TABLE items;