"Fossies" - the Fresh Open Source Software Archive

Member "mroonga-12.04/mysql-test/mroonga/storage/column/set/r/32_with_index.result" (6 Jun 2022, 1564 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 INDEX (colors)
   37 ) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
   38 SHOW CREATE TABLE items;
   39 Table	Create Table
   40 items	CREATE TABLE `items` (
   41   `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   42   `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') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   43   KEY `colors` (`colors`)
   44 ) ENGINE=Mroonga DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
   45 INSERT INTO items VALUES ("t-shart", "black,white");
   46 INSERT INTO items VALUES ("hat", "white,dark violet");
   47 INSERT INTO items VALUES ("parka", "green,brown,red");
   48 SELECT * FROM items;
   49 name	colors
   50 t-shart	black,white
   51 hat	white,dark violet
   52 parka	red,green,brown
   53 SELECT * FROM items WHERE colors = "white,dark violet";
   54 name	colors
   55 hat	white,dark violet
   56 DROP TABLE items;