"Fossies" - the Fresh Open Source Software Archive

Member "mroonga-12.04/mysql-test/mroonga/storage/column/set/r/24_with_index.result" (6 Jun 2022, 1370 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 INDEX (colors)
   29 ) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
   30 SHOW CREATE TABLE items;
   31 Table	Create Table
   32 items	CREATE TABLE `items` (
   33   `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   34   `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') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   35   KEY `colors` (`colors`)
   36 ) ENGINE=Mroonga DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
   37 INSERT INTO items VALUES ("t-shart", "black,white");
   38 INSERT INTO items VALUES ("hat", "white,lawn green");
   39 INSERT INTO items VALUES ("parka", "gray,medium blue");
   40 SELECT * FROM items;
   41 name	colors
   42 t-shart	black,white
   43 hat	white,lawn green
   44 parka	gray,medium blue
   45 SELECT * FROM items WHERE colors = "white,lawn green";
   46 name	colors
   47 hat	white,lawn green
   48 DROP TABLE items;