| 1 |
call mtr.add_suppression("unknown variable 'loose_mecab_rc_file"); |
| 2 |
call mtr.add_suppression("Fulltext index charset 'big5' doesn't match mecab charset"); |
| 3 |
call mtr.add_suppression("Mecab: createModel.* failed: param.cpp"); |
| 4 |
call mtr.add_suppression("Plugin 'mecab' init function returned error"); |
| 5 |
SHOW STATUS LIKE 'mecab_charset'; |
| 6 |
Variable_name Value |
| 7 |
mecab_charset utf8mb4 |
| 8 |
SET NAMES utf8mb3; |
| 9 |
Warnings: |
| 10 |
Warning 1287 'utf8mb3' is deprecated and will be removed in a future release. Please use utf8mb4 instead |
| 11 |
CREATE TABLE page ( |
| 12 |
page_id int(8) unsigned NOT NULL AUTO_INCREMENT, |
| 13 |
page_title varchar(255) CHARACTER SET utf8mb3 NOT NULL DEFAULT '', |
| 14 |
PRIMARY KEY (page_id), |
| 15 |
FULLTEXT KEY page_title (page_title) WITH PARSER mecab |
| 16 |
) ENGINE=InnoDB; |
| 17 |
Warnings: |
| 18 |
Warning 1681 Integer display width is deprecated and will be removed in a future release. |
| 19 |
Warning 1287 'utf8mb3' is deprecated and will be removed in a future release. Please use utf8mb4 instead |
| 20 |
INSERT INTO page VALUES |
| 21 |
(1,'レモナ'), |
| 22 |
(2,'SDレモナ'), |
| 23 |
(3,'レモナ'), |
| 24 |
(4,'データベース管理システム'), |
| 25 |
(5,'キム'), |
| 26 |
(6,'鉄道100電車'), |
| 27 |
(7,'100'), |
| 28 |
(8,'ラフィタ・カスティージョ'), |
| 29 |
(9,'ツル科_(Sibley)'), |
| 30 |
(10,'ツル'), |
| 31 |
(11,'鉄道'); |
| 32 |
SET GLOBAL innodb_ft_aux_table="test/page"; |
| 33 |
SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_CACHE |
| 34 |
ORDER BY WORD, DOC_ID, POSITION; |
| 35 |
WORD FIRST_DOC_ID LAST_DOC_ID DOC_COUNT DOC_ID POSITION |
| 36 |
100 7 8 2 7 6 |
| 37 |
100 7 8 2 8 0 |
| 38 |
sd 3 3 1 3 0 |
| 39 |
sibley 10 10 1 10 11 |
| 40 |
_( 10 10 1 10 9 |
| 41 |
キム 6 6 1 6 0 |
| 42 |
システム 5 5 1 5 24 |
| 43 |
ツル 10 11 2 10 0 |
| 44 |
ツル 10 11 2 11 0 |
| 45 |
データベース 5 5 1 5 0 |
| 46 |
ラフィタ・カスティージョ 9 9 1 9 0 |
| 47 |
レモナ 3 4 2 3 2 |
| 48 |
レモナ 3 4 2 4 0 |
| 49 |
管理 5 5 1 5 18 |
| 50 |
鉄道 7 12 2 7 0 |
| 51 |
鉄道 7 12 2 12 0 |
| 52 |
電車 7 7 1 7 9 |
| 53 |
レモナ 2 2 1 2 0 |
| 54 |
SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE; |
| 55 |
WORD FIRST_DOC_ID LAST_DOC_ID DOC_COUNT DOC_ID POSITION |
| 56 |
SHOW CREATE TABLE page; |
| 57 |
Table Create Table |
| 58 |
page CREATE TABLE `page` ( |
| 59 |
`page_id` int unsigned NOT NULL AUTO_INCREMENT, |
| 60 |
`page_title` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '', |
| 61 |
PRIMARY KEY (`page_id`), |
| 62 |
FULLTEXT KEY `page_title` (`page_title`) /*!50100 WITH PARSER `mecab` */ |
| 63 |
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
| 64 |
SELECT * FROM page WHERE MATCH(page_title) AGAINST("レモナ" IN BOOLEAN MODE); |
| 65 |
page_id page_title |
| 66 |
1 レモナ |
| 67 |
SELECT * FROM page WHERE MATCH(page_title) AGAINST("キムショウカン" IN BOOLEAN MODE); |
| 68 |
page_id page_title |
| 69 |
SELECT * FROM page WHERE MATCH(page_title) AGAINST("100" IN BOOLEAN MODE); |
| 70 |
page_id page_title |
| 71 |
6 鉄道100電車 |
| 72 |
7 100 |
| 73 |
SELECT * FROM page WHERE MATCH(page_title) AGAINST("ツル*" IN BOOLEAN MODE); |
| 74 |
page_id page_title |
| 75 |
9 ツル科_(Sibley) |
| 76 |
10 ツル |
| 77 |
SELECT * FROM page WHERE MATCH(page_title) AGAINST("ラフィタ・カスティージョ"); |
| 78 |
page_id page_title |
| 79 |
8 ラフィタ・カスティージョ |
| 80 |
SELECT * FROM page WHERE MATCH(page_title) AGAINST("ラフィタ・カスティージョ" IN BOOLEAN MODE); |
| 81 |
page_id page_title |
| 82 |
SELECT * FROM page WHERE MATCH(page_title) AGAINST("+ラフィタ・カスティージョ +データベース" IN BOOLEAN MODE); |
| 83 |
page_id page_title |
| 84 |
SELECT * FROM page WHERE MATCH(page_title) AGAINST("+ラフィタ・カスティージョ +(データベース)" IN BOOLEAN MODE); |
| 85 |
page_id page_title |
| 86 |
SELECT * FROM page WHERE MATCH(page_title) AGAINST("-ラフィタ・カスティージョ +(データベース)" IN BOOLEAN MODE); |
| 87 |
page_id page_title |
| 88 |
4 データベース管理システム |
| 89 |
SELECT * FROM page WHERE MATCH(page_title) AGAINST("ラフィタ・カスティージョ 鉄道" IN BOOLEAN MODE); |
| 90 |
page_id page_title |
| 91 |
6 鉄道100電車 |
| 92 |
11 鉄道 |
| 93 |
SELECT * FROM page WHERE MATCH(page_title) AGAINST("<ラフィタ・カスティージョ >鉄道" IN BOOLEAN MODE); |
| 94 |
page_id page_title |
| 95 |
6 鉄道100電車 |
| 96 |
11 鉄道 |
| 97 |
SELECT * FROM page WHERE MATCH(page_title) AGAINST('鉄道'); |
| 98 |
page_id page_title |
| 99 |
6 鉄道100電車 |
| 100 |
11 鉄道 |
| 101 |
SELECT * FROM page WHERE MATCH(page_title) AGAINST('鉄道' WITH QUERY EXPANSION); |
| 102 |
page_id page_title |
| 103 |
6 鉄道100電車 |
| 104 |
7 100 |
| 105 |
11 鉄道 |
| 106 |
ALTER TABLE page add column c1 varchar(100) CHARACTER SET utf8mb3 DEFAULT 'レモナ'; |
| 107 |
Warnings: |
| 108 |
Warning 1287 'utf8mb3' is deprecated and will be removed in a future release. Please use utf8mb4 instead |
| 109 |
ALTER TABLE page ADD FULLTEXT INDEX idx1 (page_title,c1) WITH PARSER mecab; |
| 110 |
SELECT * FROM page WHERE MATCH(page_title,c1) AGAINST('レモナ'); |
| 111 |
page_id page_title c1 |
| 112 |
1 レモナ レモナ |
| 113 |
2 SDレモナ レモナ |
| 114 |
3 レモナ レモナ |
| 115 |
4 データベース管理システム レモナ |
| 116 |
5 キム レモナ |
| 117 |
6 鉄道100電車 レモナ |
| 118 |
7 100 レモナ |
| 119 |
8 ラフィタ・カスティージョ レモナ |
| 120 |
9 ツル科_(Sibley) レモナ |
| 121 |
10 ツル レモナ |
| 122 |
11 鉄道 レモナ |
| 123 |
SELECT * FROM page WHERE MATCH(page_title,c1) AGAINST('-レモナ' IN BOOLEAN MODE); |
| 124 |
page_id page_title c1 |
| 125 |
DROP TABLE page; |
| 126 |
CREATE TABLE page ( |
| 127 |
page_id int(8) unsigned NOT NULL AUTO_INCREMENT, |
| 128 |
page_title varchar(255) CHARACTER SET big5 NOT NULL DEFAULT '', |
| 129 |
PRIMARY KEY (page_id) |
| 130 |
)ENGINE=InnoDB; |
| 131 |
Warnings: |
| 132 |
Warning 1681 Integer display width is deprecated and will be removed in a future release. |
| 133 |
INSERT INTO page VALUES (1,'日本'); |
| 134 |
CREATE FULLTEXT INDEX ft_idx ON page(page_title) WITH PARSER mecab; |
| 135 |
ERROR HY000: Fulltext index charset 'big5' doesn't match mecab charset 'utf8mb4'. |
| 136 |
SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_CACHE |
| 137 |
ORDER BY WORD, DOC_ID, POSITION; |
| 138 |
WORD FIRST_DOC_ID LAST_DOC_ID DOC_COUNT DOC_ID POSITION |
| 139 |
SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE; |
| 140 |
WORD FIRST_DOC_ID LAST_DOC_ID DOC_COUNT DOC_ID POSITION |
| 141 |
INSERT INTO page VALUES (2,'日本'); |
| 142 |
SELECT * FROM page WHERE MATCH(page_title) AGAINST('日本'); |
| 143 |
ERROR HY000: Can't find FULLTEXT index matching the column list |
| 144 |
DROP TABLE page; |
| 145 |
SET NAMES utf8mb4; |
| 146 |
CREATE TABLE page ( |
| 147 |
page_id int(8) unsigned NOT NULL AUTO_INCREMENT, |
| 148 |
page_title varchar(255) CHARACTER SET utf8mb4 NOT NULL DEFAULT '', |
| 149 |
PRIMARY KEY (page_id), |
| 150 |
FULLTEXT KEY page_title (page_title) WITH PARSER mecab |
| 151 |
) ENGINE=InnoDB; |
| 152 |
Warnings: |
| 153 |
Warning 1681 Integer display width is deprecated and will be removed in a future release. |
| 154 |
INSERT INTO page VALUES |
| 155 |
(1,'😃レモナ'), |
| 156 |
(2,'鉄道😄'), |
| 157 |
(3,'鉄道😊100電車'); |
| 158 |
SET GLOBAL innodb_ft_aux_table="test/page"; |
| 159 |
SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_CACHE |
| 160 |
ORDER BY WORD, DOC_ID, POSITION; |
| 161 |
WORD FIRST_DOC_ID LAST_DOC_ID DOC_COUNT DOC_ID POSITION |
| 162 |
100 4 4 1 4 10 |
| 163 |
鉄道 3 4 2 3 0 |
| 164 |
鉄道 3 4 2 4 0 |
| 165 |
電車 4 4 1 4 13 |
| 166 |
レモナ 2 2 1 2 4 |
| 167 |
SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE; |
| 168 |
WORD FIRST_DOC_ID LAST_DOC_ID DOC_COUNT DOC_ID POSITION |
| 169 |
SHOW CREATE TABLE page; |
| 170 |
Table Create Table |
| 171 |
page CREATE TABLE `page` ( |
| 172 |
`page_id` int unsigned NOT NULL AUTO_INCREMENT, |
| 173 |
`page_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '', |
| 174 |
PRIMARY KEY (`page_id`), |
| 175 |
FULLTEXT KEY `page_title` (`page_title`) /*!50100 WITH PARSER `mecab` */ |
| 176 |
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
| 177 |
SELECT * FROM page WHERE MATCH(page_title) AGAINST("レモナ" IN BOOLEAN MODE); |
| 178 |
page_id page_title |
| 179 |
1 😃レモナ |
| 180 |
SELECT * FROM page WHERE MATCH(page_title) AGAINST('鉄道'); |
| 181 |
page_id page_title |
| 182 |
2 鉄道😄 |
| 183 |
3 鉄道😊100電車 |
| 184 |
SELECT * FROM page WHERE MATCH(page_title) AGAINST('鉄道😄'); |
| 185 |
page_id page_title |
| 186 |
2 鉄道😄 |
| 187 |
3 鉄道😊100電車 |
| 188 |
SELECT * FROM page WHERE MATCH(page_title) AGAINST('鉄道' WITH QUERY EXPANSION); |
| 189 |
page_id page_title |
| 190 |
3 鉄道😊100電車 |
| 191 |
2 鉄道😄 |
| 192 |
DROP TABLE page; |
| 193 |
SET GLOBAL innodb_ft_aux_table=default; |
| 194 |
UNINSTALL PLUGIN mecab; |