"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;