Debian Codegraph @

mysql-test/suite/innodb/t/fts_exec_interrupt.test

raw
1 --source include/have_debug.inc
2 --source include/not_valgrind.inc
3 --source include/big_test.inc
4
5 CREATE TABLE `fttest04` (
6 `id` int(11) NOT NULL AUTO_INCREMENT,
7 `str` varchar(300) DEFAULT NULL,
8 `str2` mediumtext,
9 PRIMARY KEY (`id`),
10 FULLTEXT KEY `idx` (`str`,`str2`)
11 ) ENGINE=InnoDB AUTO_INCREMENT=65520 DEFAULT CHARSET=utf8mb4;
12
13 --disable_result_log
14 DELIMITER |;
15 CREATE PROCEDURE load_test_data()
16 BEGIN
17
18 DECLARE cnt INTEGER UNSIGNED DEFAULT 1;
19 WHILE (cnt <= 600220) DO
20 INSERT INTO fttest04(str, str2) VALUES('徳島県','徳島県');
21 SET cnt= cnt+1;
22 END WHILE;
23 END|
24 DELIMITER ;|
25
26 CALL load_test_data();
27 DROP PROCEDURE load_test_data;
28
29 --enable_result_log
30 --error ER_QUERY_TIMEOUT
31 SELECT /*+ max_execution_time(2000) */ COUNT(id) FROM fttest04 WHERE
32 MATCH (str,str2) AGAINST ('徳島県' IN BOOLEAN MODE) ;
33
34 DROP TABLE fttest04;