146
146
# Some other simple tests with the current character set
148
148
create table t1 (a varchar(10), key(a), fulltext (a)) ENGINE = InnoDB;
149
150
insert into t1 values ("a"),("abc"),("abcd"),("hello"),("test");
150
151
select * from t1 where a like "abc%";
151
152
select * from t1 where a like "test%";
209
210
DROP TABLE t1,t2;
212
212
--echo End of 5.1 tests
214
--echo # Bug #19950568 WRONG RELEVANCE RANKING FOR INNODB FULL TEXT
215
--echo # SEARCHES UNDER CERTAIN CONDITIONS
219
id int(11) NOT NULL AUTO_INCREMENT,
220
first_name VARCHAR(50) NOT NULL,
221
last_name VARCHAR(50) NOT NULL,
223
UNIQUE KEY idx_1 (first_name, last_name),
224
FULLTEXT KEY `idx_2` (first_name)
227
INSERT INTO t1 (id, first_name, last_name) VALUES
228
(1, 'Bart', 'Simpson'),
229
(2, 'Homer', 'Simpson'),
230
(3, 'Marge', 'Simpson'),
231
(4, 'Lisa', 'Simpson'),
232
(5, 'Maggie', 'Simpson'),
233
(6, 'Ned', 'Flanders'),
234
(7, 'Nelson', 'Muntz');
238
let $query= SELECT id, first_name, last_name, MATCH(first_name) AGAINST('Homer' IN
239
BOOLEAN MODE) AS score FROM t1;
244
let $query=SELECT id, first_name, last_name, MATCH(first_name) AGAINST('Homer' IN
245
BOOLEAN MODE) AS score FROM t1 ORDER BY id;
253
FTS_DOC_ID BIGINT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
254
id int(11) NOT NULL ,
255
first_name VARCHAR(50) NOT NULL,
256
last_name VARCHAR(50) NOT NULL,
258
UNIQUE KEY (FTS_DOC_ID),
259
UNIQUE KEY idx_1 (first_name, last_name),
260
FULLTEXT KEY `idx_2` (first_name)
263
INSERT INTO t1 (id, first_name, last_name) VALUES
264
(1, 'Bart', 'Simpson'),
265
(2, 'Homer', 'Simpson'),
266
(3, 'Marge', 'Simpson'),
267
(4, 'Lisa', 'Simpson'),
268
(5, 'Maggie', 'Simpson'),
269
(6, 'Ned', 'Flanders'),
270
(7, 'Nelson', 'Muntz');
274
let $query=SELECT id, first_name, last_name, MATCH(first_name) AGAINST('Homer' IN
275
BOOLEAN MODE) AS score FROM t1;
280
let $query=SELECT id, first_name, last_name, MATCH(first_name) AGAINST('Homer' IN
281
BOOLEAN MODE) AS score FROM t1 ORDER BY fts_doc_id;
288
--echo # Adding test case for Bug#20261601
290
CREATE TABLE t1(a INT PRIMARY KEY)ENGINE=INNODB;
291
INSERT INTO t1 VALUES(1),(2);
292
--error ER_FT_MATCHING_KEY_NOT_FOUND
293
SELECT (SELECT MATCH(`a`)AGAINST('1') FROM t1) FROM t1;
294
SELECT 1, a IN (SELECT a FROM t1) FROM t1;
297
--echo # End of test for Bug#19950568 and Bug#20261601