"Fossies" - the Fresh Open Source Software Archive 
Member "mroonga-12.04/mysql-test/mroonga/storage/column/set/r/8_with_index.result" (6 Jun 2022, 998 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 INDEX (colors)
13 ) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
14 SHOW CREATE TABLE items;
15 Table Create Table
16 items CREATE TABLE `items` (
17 `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
18 `colors` set('black','dim gray','dark gray','gray','light gray','gainsboro','white smoke','white') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
19 KEY `colors` (`colors`)
20 ) ENGINE=Mroonga DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
21 INSERT INTO items VALUES ("t-shart", "black,gray");
22 INSERT INTO items VALUES ("hat", "dim gray,dark gray");
23 INSERT INTO items VALUES ("parka", "white smoke,light gray");
24 SELECT * FROM items;
25 name colors
26 t-shart black,gray
27 hat dim gray,dark gray
28 parka light gray,white smoke
29 SELECT * FROM items WHERE colors = "dim gray,dark gray";
30 name colors
31 hat dim gray,dark gray
32 DROP TABLE items;