| 1 |
CREATE TABLE `fttest04` ( |
| 2 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
| 3 |
`str` varchar(300) DEFAULT NULL, |
| 4 |
`str2` mediumtext, |
| 5 |
PRIMARY KEY (`id`), |
| 6 |
FULLTEXT KEY `idx` (`str`,`str2`) |
| 7 |
) ENGINE=InnoDB AUTO_INCREMENT=65520 DEFAULT CHARSET=utf8mb4; |
| 8 |
CREATE PROCEDURE load_test_data() |
| 9 |
BEGIN |
| 10 |
DECLARE cnt INTEGER UNSIGNED DEFAULT 1; |
| 11 |
WHILE (cnt <= 600220) DO |
| 12 |
INSERT INTO fttest04(str, str2) VALUES('徳島県','徳島県'); |
| 13 |
SET cnt= cnt+1; |
| 14 |
END WHILE; |
| 15 |
END| |
| 16 |
CALL load_test_data(); |
| 17 |
DROP PROCEDURE load_test_data; |
| 18 |
SELECT /*+ max_execution_time(2000) */ COUNT(id) FROM fttest04 WHERE |
| 19 |
MATCH (str,str2) AGAINST ('徳島県' IN BOOLEAN MODE) ; |
| 20 |
ERROR HY000: Query execution was interrupted, maximum statement execution time exceeded |
| 21 |
DROP TABLE fttest04; |