"Fossies" - the Fresh Open Source Software Archive 
Member "mroonga-12.04/mysql-test/mroonga/storage/column/set/r/16_with_index.result" (6 Jun 2022, 1152 Bytes) of package /linux/misc/mroonga-12.04.tar.gz:
As a special service "Fossies" has tried to format the requested text file into HTML format (style:
standard) with prefixed line numbers.
Alternatively you can here
view or
download the uninterpreted source code file.
1 DROP TABLE IF EXISTS items;
2 CREATE TABLE items (
3 name VARCHAR(255),
4 colors SET("black",
5 "dim gray",
6 "dark gray",
7 "gray",
8 "light gray",
9 "gainsboro",
10 "white smoke",
11 "white",
12 "red",
13 "orange red",
14 "dark orange",
15 "orange",
16 "gold",
17 "yellow",
18 "chartreuse",
19 "lawn green"),
20 INDEX (colors)
21 ) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
22 SHOW CREATE TABLE items;
23 Table Create Table
24 items CREATE TABLE `items` (
25 `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
26 `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') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
27 KEY `colors` (`colors`)
28 ) ENGINE=Mroonga DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
29 INSERT INTO items VALUES ("t-shart", "black,gray");
30 INSERT INTO items VALUES ("hat", "white,dark gray");
31 INSERT INTO items VALUES ("parka", "chartreuse,orange");
32 SELECT * FROM items;
33 name colors
34 t-shart black,gray
35 hat dark gray,white
36 parka orange,chartreuse
37 SELECT * FROM items WHERE colors = "dark gray,white";
38 name colors
39 hat dark gray,white
40 DROP TABLE items;