"Fossies" - the Fresh Open Source Software Archive

Member "mroonga-12.04/mysql-test/mroonga/storage/column/set/r/64_with_index.result" (6 Jun 2022, 2548 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.

A hint: This file contains one or more very long lines, so maybe it is better readable using the pure text view mode that shows the contents as wrapped lines within the browser window.

    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 "green",
   21 "spring green",
   22 "medium spring green",
   23 "cyan",
   24 "deep sky blue",
   25 "blue",
   26 "medium blue",
   27 "dark violet",
   28 "dark magenta",
   29 "magenta",
   30 "dark red",
   31 "brown",
   32 "firebrick",
   33 "indian red",
   34 "light coral",
   35 "salmon",
   36 "light salmon",
   37 "tomato",
   38 "coral",
   39 "dark salmon",
   40 "rosy brown",
   41 "sienna",
   42 "saddle brown",
   43 "chocolate",
   44 "peru",
   45 "sandy brown",
   46 "burlywood",
   47 "tan",
   48 "navajo white",
   49 "wheat",
   50 "dark goldenrod",
   51 "goldenrod",
   52 "light goldenrod",
   53 "pale goldenrod",
   54 "cornsilk",
   55 "dark khaki",
   56 "khaki",
   57 "lemon chiffon",
   58 "dark olive green",
   59 "olive drab",
   60 "yellow green",
   61 "green yellow",
   62 "light green",
   63 "forest green",
   64 "dark green",
   65 "lime green",
   66 "pale green",
   67 "dark sea green"),
   68 INDEX (colors)
   69 ) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
   70 SHOW CREATE TABLE items;
   71 Table	Create Table
   72 items	CREATE TABLE `items` (
   73   `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   74   `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','dark magenta','magenta','dark red','brown','firebrick','indian red','light coral','salmon','light salmon','tomato','coral','dark salmon','rosy brown','sienna','saddle brown','chocolate','peru','sandy brown','burlywood','tan','navajo white','wheat','dark goldenrod','goldenrod','light goldenrod','pale goldenrod','cornsilk','dark khaki','khaki','lemon chiffon','dark olive green','olive drab','yellow green','green yellow','light green','forest green','dark green','lime green','pale green','dark sea green') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   75   KEY `colors` (`colors`)
   76 ) ENGINE=Mroonga DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
   77 INSERT INTO items VALUES ("t-shart", "black,white,lawn green,dark violet");
   78 INSERT INTO items VALUES ("hat", "white,dark violet,yellow green");
   79 INSERT INTO items VALUES ("parka", "green,brown,red,lime green");
   80 SELECT * FROM items;
   81 name	colors
   82 t-shart	black,white,lawn green,dark violet
   83 hat	white,dark violet,yellow green
   84 parka	red,green,brown,lime green
   85 SELECT * FROM items WHERE colors = "white,dark violet,yellow green";
   86 name	colors
   87 hat	white,dark violet,yellow green
   88 DROP TABLE items;