Debian Codegraph @

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

raw
1 drop table if exists t1;
2 CREATE TABLE t1 (
3 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
4 a VARCHAR(200),
5 b TEXT
6 ) ENGINE= InnoDB;
7 CREATE FULLTEXT INDEX idx on t1 (a,b);
8 Warnings:
9 Warning 124 InnoDB rebuilding table to add column FTS_DOC_ID
10 INSERT INTO t1 (a,b) VALUES
11 ('MySQL from Tutorial','DBMS stands for DataBase ...') ,
12 ('when To Use MySQL Well','After that you went through a ...'),
13 ('where will Optimizing MySQL','what In this tutorial we will show ...');
14 SELECT * FROM t1 WHERE MATCH(a,b) AGAINST ("where will");
15 id a b
16 SELECT * FROM t1 WHERE MATCH(a,b) AGAINST ("when");
17 id a b
18 SELECT * FROM t1 WHERE MATCH(a,b) AGAINST ("what" WITH QUERY EXPANSION);
19 id a b
20 SELECT * FROM t1 WHERE MATCH(a,b) AGAINST("whe*" IN BOOLEAN MODE);
21 id a b
22 SELECT * FROM t1 WHERE MATCH(a,b) AGAINST("+what +will" IN BOOLEAN MODE);
23 id a b
24 SELECT * FROM t1 WHERE MATCH(a,b) AGAINST("+from" IN BOOLEAN MODE);
25 id a b
26 SELECT * FROM t1 WHERE MATCH(a,b) AGAINST("+where +(show what)" IN BOOLEAN MODE);
27 id a b
28 SELECT * FROM t1
29 WHERE MATCH (a,b)
30 AGAINST ('"where will"@6' IN BOOLEAN MODE);
31 id a b
32 SELECT * FROM t1
33 WHERE MATCH (a,b)
34 AGAINST ('"where will"@9' IN BOOLEAN MODE);
35 id a b
36 INSERT INTO t1 (a,b) VALUES
37 ('MySQL Tutorial','request [email protected] ...') ,
38 ('Trial version','query performace @1255 minute on 2.1Hz Memory 2GB...') ,
39 ('when To Use MySQL Well','for free faq [email protected] ...');
40 SELECT * FROM t1
41 WHERE MATCH (a,b)
42 AGAINST ('"request"@10' IN BOOLEAN MODE);
43 id a b
44 4 MySQL Tutorial request [email protected] ...
45 SELECT * FROM t1
46 WHERE MATCH (a,b)
47 AGAINST ('"Trial version"@0' IN BOOLEAN MODE);
48 id a b
49 5 Trial version query performace @1255 minute on 2.1Hz Memory 2GB...
50 SELECT * FROM t1
51 WHERE MATCH (a,b)
52 AGAINST ('"request [email protected]"@10' IN BOOLEAN MODE);
53 id a b
54 4 MySQL Tutorial request [email protected] ...
55 SELECT * FROM t1
56 WHERE MATCH (a,b)
57 AGAINST ('"1255 minute"@1' IN BOOLEAN MODE);
58 id a b
59 SELECT * FROM t1
60 WHERE MATCH (a,b)
61 AGAINST ('"1255 minute"@2' IN BOOLEAN MODE);
62 id a b
63 5 Trial version query performace @1255 minute on 2.1Hz Memory 2GB...
64 SELECT * FROM t1
65 WHERE MATCH (a,b)
66 AGAINST ('"1255"@10' IN BOOLEAN MODE);
67 id a b
68 5 Trial version query performace @1255 minute on 2.1Hz Memory 2GB...
69 SELECT * FROM t1
70 WHERE MATCH (a,b)
71 AGAINST ('1255' WITH QUERY EXPANSION);
72 id a b
73 5 Trial version query performace @1255 minute on 2.1Hz Memory 2GB...
74 SELECT * FROM t1
75 WHERE MATCH (a,b)
76 AGAINST ('"request docteam"@2' IN BOOLEAN MODE);
77 id a b
78 4 MySQL Tutorial request [email protected] ...
79 SELECT * FROM t1
80 WHERE MATCH (a,b)
81 AGAINST ('"1255 minute"' IN BOOLEAN MODE);
82 id a b
83 5 Trial version query performace @1255 minute on 2.1Hz Memory 2GB...
84 SELECT * FROM t1
85 WHERE MATCH (a,b)
86 AGAINST ('request [email protected]');
87 id a b
88 4 MySQL Tutorial request [email protected] ...
89 SELECT * FROM t1
90 WHERE MATCH (a,b)
91 AGAINST ('"MySQL request"@3' IN BOOLEAN MODE);
92 id a b
93 4 MySQL Tutorial request [email protected] ...
94 SELECT * FROM t1
95 WHERE MATCH (a,b)
96 AGAINST ('"Trial memory"@10' IN BOOLEAN MODE);
97 id a b
98 5 Trial version query performace @1255 minute on 2.1Hz Memory 2GB...
99 SELECT * FROM t1
100 WHERE MATCH (a,b)
101 AGAINST ('"Trial memory"@9' IN BOOLEAN MODE);
102 id a b
103 DROP TABLE t1;
104 CREATE TABLE t1 (
105 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
106 a VARCHAR(200),
107 b TEXT
108 ) CHARACTER SET = UTF8, ENGINE= InnoDB;
109 Warnings:
110 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.
111 INSERT INTO t1 (a,b) VALUES
112 ('MySQL from Tutorial','DBMS stands for DataBase ...') ,
113 ('when To Use MySQL Well','After that you went through a ...'),
114 ('where will Optimizing MySQL','what In this tutorial we will show ...');
115 CREATE FULLTEXT INDEX idx on t1 (a,b);
116 Warnings:
117 Warning 124 InnoDB rebuilding table to add column FTS_DOC_ID
118 INSERT INTO t1 (a,b) VALUES
119 ('MySQL Tutorial','request [email protected] ...') ,
120 ('Trial version','query performace @1255 minute on 2.1Hz Memory 2GB...'),
121 ('when To Use MySQL Well','for free faq [email protected] ...');
122 SELECT * FROM t1
123 WHERE MATCH (a,b)
124 AGAINST ('"mysql use"@2' IN BOOLEAN MODE);
125 id a b
126 2 when To Use MySQL Well After that you went through a ...
127 6 when To Use MySQL Well for free faq [email protected] ...
128 SELECT * FROM t1
129 WHERE MATCH (a,b)
130 AGAINST ('"mysql use"@1' IN BOOLEAN MODE);
131 id a b
132 INSERT INTO t1 (a,b) VALUES ('XYZ, long blob', repeat("a", 9000));
133 INSERT IGNORE INTO t1 (a,b) VALUES (repeat("b", 9000), 'XYZ, long blob');
134 Warnings:
135 Warning 1265 Data truncated for column 'a' at row 1
136 SELECT count(*) FROM t1
137 WHERE MATCH (a,b)
138 AGAINST ('"xyz blob"@3' IN BOOLEAN MODE);
139 count(*)
140 2
141 DROP TABLE t1;
142 set global innodb_file_per_table=1;
143 CREATE TABLE t1 (
144 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
145 a TEXT,
146 b TEXT,
147 c TEXT
148 ) CHARACTER SET = UTF8, ROW_FORMAT=DYNAMIC, ENGINE= InnoDB;
149 Warnings:
150 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.
151 INSERT INTO t1 (a,b,c) VALUES (repeat("b", 19000), 'XYZ, long text', 'very long blob');
152 INSERT INTO t1 (a,b,c) VALUES (repeat("b", 19000), 'XYZ, very little long blob very much blob', 'very long blob');
153 INSERT INTO t1 (a,b,c) VALUES (repeat("b", 19000),"very 租车 供 blob","new 供需分析information");
154 CREATE FULLTEXT INDEX idx on t1 (a,b,c);
155 Warnings:
156 Warning 124 InnoDB rebuilding table to add column FTS_DOC_ID
157 INSERT INTO t1 (a,b,c) VALUES (repeat("x", 19000), 'new, long text', 'very new blob');
158 INSERT INTO t1 (a,b,c) VALUES ('interesting, long text', repeat("x", 19000), 'very very good new blob');
159 SELECT count(*) FROM t1
160 WHERE MATCH (a,b,c)
161 AGAINST ('"very blob"@3' IN BOOLEAN MODE);
162 count(*)
163 3
164 SELECT count(*) FROM t1
165 WHERE MATCH (a,b,c)
166 AGAINST ('"very long blob"@0' IN BOOLEAN MODE);
167 count(*)
168 2
169 SELECT count(*) FROM t1
170 WHERE MATCH (a,b,c)
171 AGAINST ('"very blob"@4' IN BOOLEAN MODE);
172 count(*)
173 5
174 SELECT count(*) FROM t1
175 WHERE MATCH (a,b,c)
176 AGAINST ('"interesting blob"@9' IN BOOLEAN MODE);
177 count(*)
178 1
179 SELECT COUNT(*) FROM t1
180 WHERE MATCH (a,b,c)
181 AGAINST ('"interesting blob"@9 "very long blob"@0' IN BOOLEAN MODE);
182 COUNT(*)
183 3
184 SELECT COUNT(*) FROM t1
185 WHERE MATCH (a,b,c)
186 AGAINST ('"very blob"@4 - "interesting blob"@9' IN BOOLEAN MODE);
187 COUNT(*)
188 4
189 DROP TABLE t1;
190 CREATE TABLE t1 (
191 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
192 a VARCHAR(200),
193 b TEXT
194 ) CHARACTER SET = UTF8, ENGINE= InnoDB;
195 Warnings:
196 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.
197 INSERT INTO t1 (a,b) VALUES
198 ('MySQL from Tutorial','DBMS stands for + DataBase ...');
199 CREATE FULLTEXT INDEX idx on t1 (a,b);
200 Warnings:
201 Warning 124 InnoDB rebuilding table to add column FTS_DOC_ID
202 SELECT * FROM t1
203 WHERE MATCH (a,b)
204 AGAINST ('"stands database"@3' IN BOOLEAN MODE);
205 id a b
206 1 MySQL from Tutorial DBMS stands for + DataBase ...
207 DROP TABLE t1;
208 CREATE TABLE t1 (
209 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
210 a TEXT,
211 b TEXT,
212 c TEXT
213 ) CHARACTER SET = UTF8, ROW_FORMAT=DYNAMIC, ENGINE= InnoDB;
214 Warnings:
215 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.
216 INSERT INTO t1 (a,b,c) VALUES (repeat("b", 19000), 'XYZ, long text', 'very long blob');
217 INSERT INTO t1 (a,b,c) VALUES ('XYZ, 租车 very little long blob very much blob', repeat("b", 19000), 'very long but smaller blob');
218 CREATE FULLTEXT INDEX idx on t1 (a,b,c);
219 Warnings:
220 Warning 124 InnoDB rebuilding table to add column FTS_DOC_ID
221 DELETE FROM t1;
222 INSERT INTO t1 (a,b,c) VALUES (repeat("b", 19000), 'XYZ, long text', 'very long blob');
223 INSERT INTO t1 (a,b,c) VALUES ('XYZ, 租车 very little long blob is a very much longer blob', repeat("b", 19000), 'this is very long but smaller blob');
224 SELECT count(*) FROM t1
225 WHERE MATCH (a,b,c)
226 AGAINST ('"very blob"@4' IN BOOLEAN MODE);
227 count(*)
228 2
229 SELECT count(*) FROM t1
230 WHERE MATCH (a,b,c)
231 AGAINST ('"very blob"@3' IN BOOLEAN MODE);
232 count(*)
233 1
234 DROP TABLE t1;
235 SET GLOBAL innodb_file_per_table=1;