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