Debian Codegraph @

mysql-test/suite/innodb_fts/r/ngram_debug.result

raw
1 SET GLOBAL innodb_ft_enable_diag_print = 1;
2 # Test Case 1: Test English with Default(latin1) Charset
3 SET DEBUG="+d,fts_instrument_ignore_ngram_check";
4 CREATE TABLE articles (
5 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
6 title VARCHAR(200)
7 ) ENGINE=InnoDB;
8 ALTER TABLE articles ADD FULLTEXT INDEX (title) WITH PARSER ngram;
9 Warnings:
10 Warning 124 InnoDB rebuilding table to add column FTS_DOC_ID
11 INSERT INTO articles (title) VALUES
12 ('what is M'),
13 ('Myname is wonder'),
14 ('My SQL is good'),
15 ('MySQL database'),
16 ('Mind a good thing'),
17 ('Mind good idea');
18 SELECT * FROM articles WHERE
19 MATCH(title) AGAINST('m*' IN BOOLEAN MODE);
20 id title
21 2 Myname is wonder
22 3 My SQL is good
23 4 MySQL database
24 5 Mind a good thing
25 6 Mind good idea
26 SELECT * FROM articles WHERE
27 MATCH(title) AGAINST('my*' IN BOOLEAN MODE);
28 id title
29 2 Myname is wonder
30 3 My SQL is good
31 4 MySQL database
32 SELECT * FROM articles WHERE
33 MATCH(title) AGAINST('+mind -mysql' IN BOOLEAN MODE);
34 id title
35 5 Mind a good thing
36 6 Mind good idea
37 SELECT * FROM articles WHERE
38 MATCH(title) AGAINST('+(mind thing) -idea' IN BOOLEAN MODE);
39 id title
40 5 Mind a good thing
41 SELECT * FROM articles WHERE
42 MATCH(title) AGAINST('mysql');
43 id title
44 2 Myname is wonder
45 3 My SQL is good
46 4 MySQL database
47 SELECT * FROM articles WHERE
48 MATCH(title) AGAINST('mysql' IN BOOLEAN MODE);
49 id title
50 4 MySQL database
51 SELECT * FROM articles WHERE
52 MATCH(title) AGAINST('"mysql"' IN BOOLEAN MODE);
53 id title
54 4 MySQL database
55 SELECT * FROM articles WHERE
56 MATCH(title) AGAINST('"my sql"' IN BOOLEAN MODE);
57 id title
58 3 My SQL is good
59 SET DEBUG="-d,fts_instrument_ignore_ngram_check";
60 DROP TABLE articles;
61 SET NAMES utf8mb4;
62 # Test Case 2: Test Stopwords
63 SET DEBUG="+d,fts_instrument_ignore_ngram_check";
64 CREATE TABLE articles (
65 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
66 title VARCHAR(200),
67 body TEXT
68 ) ENGINE=InnoDB DEFAULT CHARACTER SET gb2312 COLLATE gb2312_chinese_ci;
69 CREATE FULLTEXT INDEX ft_index ON articles(title, body) WITH PARSER ngram;
70 Warnings:
71 Warning 124 InnoDB rebuilding table to add column FTS_DOC_ID
72 INSERT INTO articles (title, body) VALUES
73 ('从简单购物清单到画展','或企业网络中的海量数据'),
74 ('要想将数据添加到数据库','访问、处理计算机数据库中保存的数据'),
75 ('从简单的购物清单到画展','或企业网络中的海量数据'),
76 ('要想将数据添加到数据库','或访问、处理计算机数据库中保存的数据'),
77 ('数据库是数据的结构化集合','它可以是任何东西');
78 SELECT * FROM articles WHERE
79 MATCH(title, body) AGAINST('的* 或* 东西' IN BOOLEAN MODE);
80 id title body
81 1 从简单购物清单到画展 或企业网络中的海量数据
82 2 要想将数据添加到数据库 访问、处理计算机数据库中保存的数据
83 3 从简单的购物清单到画展 或企业网络中的海量数据
84 4 要想将数据添加到数据库 或访问、处理计算机数据库中保存的数据
85 5 数据库是数据的结构化集合 它可以是任何东西
86 SELECT * FROM articles WHERE
87 MATCH(title, body) AGAINST('简单的' IN BOOLEAN MODE);
88 id title body
89 3 从简单的购物清单到画展 或企业网络中的海量数据
90 SELECT * FROM articles WHERE
91 MATCH(title, body) AGAINST('或访问' IN BOOLEAN MODE);
92 id title body
93 4 要想将数据添加到数据库 或访问、处理计算机数据库中保存的数据
94 SELECT * FROM articles WHERE
95 MATCH(title, body) AGAINST('"数据的结构化"' IN BOOLEAN MODE);
96 id title body
97 5 数据库是数据的结构化集合 它可以是任何东西
98 SET DEBUG="-d,fts_instrument_ignore_ngram_check";
99 DROP TABLE articles;
100 CREATE TABLE articles (
101 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
102 title VARCHAR(200),
103 body TEXT
104 ) ENGINE=InnoDB DEFAULT CHARACTER SET gb2312 COLLATE gb2312_chinese_ci;
105 CREATE TABLE user_stopword(value varchar(30)) ENGINE = InnoDB
106 DEFAULT CHARACTER SET gb2312 COLLATE gb2312_chinese_ci;
107 INSERT INTO user_stopword VALUES('的'),('或'),('东西'),('ab');
108 SET GLOBAL innodb_ft_server_stopword_table = 'test/user_stopword';
109 INSERT INTO articles (title, body) VALUES
110 ('从简单购物清单到画展','或企业网络中的海量数据'),
111 ('要想将数据添加到数据库','访问、处理计算机数据库中保存的数据');
112 CREATE FULLTEXT INDEX ft_index ON articles(title, body) WITH PARSER ngram;
113 Warnings:
114 Warning 124 InnoDB rebuilding table to add column FTS_DOC_ID
115 INSERT INTO articles (title, body) VALUES
116 ('从简单的购物清单到画展','或企业网络中的海量数据'),
117 ('要想将数据添加到数据库','或访问、处理计算机数据库中保存的数据'),
118 ('要想将数据添加到数据库','或访问、处理计算机数据库中保存的数据 abc xyz'),
119 ('数据库是数据的结构化集合','它可以是任何东西');
120 SELECT * FROM articles WHERE
121 MATCH(title, body) AGAINST('的* 或* 东西' IN BOOLEAN MODE);
122 id title body
123 SELECT * FROM articles WHERE
124 MATCH(title, body) AGAINST('简单的' IN BOOLEAN MODE);
125 id title body
126 3 从简单的购物清单到画展 或企业网络中的海量数据
127 SELECT * FROM articles WHERE
128 MATCH(title, body) AGAINST('或访问' IN BOOLEAN MODE);
129 id title body
130 2 要想将数据添加到数据库 访问、处理计算机数据库中保存的数据
131 4 要想将数据添加到数据库 或访问、处理计算机数据库中保存的数据
132 5 要想将数据添加到数据库 或访问、处理计算机数据库中保存的数据 abc xyz
133 SELECT * FROM articles WHERE
134 MATCH(title, body) AGAINST('"数据的结构化"' IN BOOLEAN MODE);
135 id title body
136 6 数据库是数据的结构化集合 它可以是任何东西
137 SELECT * FROM user_stopword WHERE value like 'ab' ;
138 value
139 ab
140 SELECT * FROM articles WHERE
141 MATCH(title, body) AGAINST('"ab"' );
142 id title body
143 SELECT * FROM articles WHERE
144 MATCH(title, body) AGAINST('数据 +ab' IN BOOLEAN MODE);
145 id title body
146 SELECT * FROM articles WHERE
147 MATCH(title, body) AGAINST('数据 (+xyz -bc)' IN BOOLEAN MODE);
148 id title body
149 1 从简单购物清单到画展 或企业网络中的海量数据
150 2 要想将数据添加到数据库 访问、处理计算机数据库中保存的数据
151 3 从简单的购物清单到画展 或企业网络中的海量数据
152 4 要想将数据添加到数据库 或访问、处理计算机数据库中保存的数据
153 5 要想将数据添加到数据库 或访问、处理计算机数据库中保存的数据 abc xyz
154 6 数据库是数据的结构化集合 它可以是任何东西
155 DROP TABLE user_stopword;
156 DROP TABLE articles;
157 SET GLOBAL innodb_ft_server_stopword_table=default;
158 # Test Case 3: Check with FTS debug points
159 CREATE TABLE articles (
160 seq INT AUTO_INCREMENT NOT NULL PRIMARY KEY,
161 c1 VARCHAR(200) CHARACTER SET big5 COLLATE big5_chinese_ci,
162 c2 CHAR(200) CHARACTER SET gbk COLLATE gbk_chinese_ci,
163 c3 CHAR(200) CHARACTER SET utf8,
164 j1 TEXT CHARACTER SET ujis COLLATE ujis_japanese_ci,
165 j2 VARCHAR(200) CHARACTER SET sjis COLLATE sjis_japanese_ci,
166 j3 VARCHAR(200) CHARACTER SET ujis,
167 k1 CHAR(200) CHARACTER SET euckr COLLATE euckr_korean_ci,
168 k2 CHAR(200) CHARACTER SET utf8,
169 e1 CHAR(200) CHARACTER SET latin1,
170 FULLTEXT KEY `con1` (c1),
171 FULLTEXT KEY `con2` (j1,j3),
172 FULLTEXT KEY `con3` (k2) WITH PARSER ngram
173 ) ENGINE=InnoDB ;
174 Warnings:
175 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
176 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
177 SET DEBUG='+d,alter_table_rollback_new_index';
178 ALTER TABLE articles ADD FULLTEXT INDEX (c2(64));
179 ERROR HY000: Unknown error
180 ALTER TABLE articles ADD FULLTEXT INDEX (j1,j3);
181 ERROR HY000: Unknown error
182 ALTER TABLE articles ADD FULLTEXT INDEX (k1);
183 ERROR HY000: Unknown error
184 ALTER TABLE articles ADD FULLTEXT INDEX (e1);
185 ERROR HY000: Unknown error
186 SET DEBUG='-d,alter_table_rollback_new_index';
187 SET DEBUG="+d,ib_dict_create_index_tree_fail";
188 ALTER TABLE articles ADD FULLTEXT INDEX (c2(64));
189 ERROR HY000: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
190 ALTER TABLE articles ADD FULLTEXT INDEX (j1,j3);
191 ERROR HY000: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
192 ALTER TABLE articles ADD FULLTEXT INDEX (k1);
193 ERROR HY000: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
194 ALTER TABLE articles ADD FULLTEXT INDEX (e1);
195 ERROR HY000: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
196 SET DEBUG="-d,ib_dict_create_index_tree_fail";
197 ALTER TABLE articles ADD FULLTEXT INDEX (e1), ADD FULLTEXT INDEX (k1);
198 ERROR HY000: InnoDB presently supports one FULLTEXT index creation at a time
199 DROP TABLE articles;
200 SET GLOBAL innodb_ft_enable_diag_print = default;