diff options
Diffstat (limited to 'storage/mroonga/mysql-test/mroonga/wrapper/r/column_multibyte_utf8.result')
-rw-r--r-- | storage/mroonga/mysql-test/mroonga/wrapper/r/column_multibyte_utf8.result | 32 |
1 files changed, 32 insertions, 0 deletions
diff --git a/storage/mroonga/mysql-test/mroonga/wrapper/r/column_multibyte_utf8.result b/storage/mroonga/mysql-test/mroonga/wrapper/r/column_multibyte_utf8.result new file mode 100644 index 00000000000..2d31307392f --- /dev/null +++ b/storage/mroonga/mysql-test/mroonga/wrapper/r/column_multibyte_utf8.result @@ -0,0 +1,32 @@ +DROP TABLE IF EXISTS users; +SET NAMES utf8; +CREATE TABLE users ( +id int unsigned PRIMARY KEY AUTO_INCREMENT, +名前 text, +FULLTEXT INDEX (名前) +) DEFAULT CHARSET=utf8 COMMENT='Engine "InnoDB"'; +INSERT INTO users (名前) VALUES ("やまだ"); +INSERT INTO users (名前) VALUES ("たなか"); +INSERT INTO users (名前) VALUES ("すずき"); +SELECT * FROM users; +id 名前 +1 やまだ +2 たなか +3 すずき +SELECT * FROM users +WHERE MATCH (名前) AGAINST ('+たなか' IN BOOLEAN MODE); +id 名前 +2 たなか +SELECT mroonga_command("dump --dump_plugins no --dump_records no"); +mroonga_command("dump --dump_plugins no --dump_records no") +table_create mroonga_operations TABLE_NO_KEY +column_create mroonga_operations record COLUMN_SCALAR UInt32 +column_create mroonga_operations table COLUMN_SCALAR ShortText +column_create mroonga_operations type COLUMN_SCALAR ShortText + +table_create users TABLE_HASH_KEY ShortText + +table_create users#@540d@524d TABLE_PAT_KEY ShortText --default_tokenizer TokenBigram --normalizer NormalizerMySQLGeneralCI + +column_create users#@540d@524d index COLUMN_INDEX|WITH_POSITION users +DROP TABLE users; |