EVOLUTION-MANAGER

Edit File: fulltext_groonga_varchar_vector.result

DROP TABLE IF EXISTS bugs, tags; CREATE TABLE tags ( name VARCHAR(64) PRIMARY KEY ) DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='default_tokenizer "TokenDelimit"'; CREATE TABLE bugs ( id INT UNSIGNED PRIMARY KEY, tags VARCHAR(40) COMMENT 'type "tags", flags "COLUMN_VECTOR"', FULLTEXT INDEX bugs_tags_index (tags) COMMENT 'table "tags"' ) DEFAULT CHARSET=utf8; INSERT INTO bugs (id, tags) VALUES (1, "Linux MySQL"); INSERT INTO bugs (id, tags) VALUES (2, "MySQL groonga"); INSERT INTO bugs (id, tags) VALUES (3, "mroonga"); SELECT * FROM bugs WHERE MATCH (tags) AGAINST ("MySQL" IN BOOLEAN MODE); id tags 1 Linux MySQL 2 MySQL groonga DROP TABLE bugs, tags;