EVOLUTION-MANAGER

Edit File: column_set_24_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",
"red",
"orange red",
"dark orange",
"orange",
"gold",
"yellow",
"chartreuse",
"lawn green",
"green",
"spring green",
"medium spring green",
"cyan",
"deep sky blue",
"blue",
"medium blue",
"dark violet"),
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','red','orange red','dark orange','orange','gold','yellow','chartreuse','lawn green','green','spring green','medium spring green','cyan','deep sky blue','blue','medium blue','dark violet') DEFAULT NULL,
  KEY `colors` (`colors`)
) ENGINE=Mroonga DEFAULT CHARSET=utf8
INSERT INTO items VALUES ("t-shart", "black,white");
INSERT INTO items VALUES ("hat", "white,lawn green");
INSERT INTO items VALUES ("parka", "gray,medium blue");
SELECT * FROM items;
name	colors
t-shart	black,white
hat	white,lawn green
parka	gray,medium blue
SELECT * FROM items WHERE colors = "white,lawn green";
name	colors
hat	white,lawn green
DROP TABLE items;