Debian Codegraph @

mysql-test/suite/innodb_fts/t/ft_result_cache_limit.test

raw
1 --echo #
2 --echo # Bug 1634932: Assertion failure in thread x in
3 --echo # file fts0que.cc
4 --echo #
5
6 --source include/have_innodb.inc
7 --source include/have_debug.inc
8
9 SET @saved_innodb_ft_result_cache_limit= @@global.innodb_ft_result_cache_limit;
10
11 CREATE TABLE `t1` (
12 `FTS_DOC_ID` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
13 `text_content` MEDIUMTEXT, PRIMARY KEY (`FTS_DOC_ID`)
14 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
15
16 CREATE UNIQUE INDEX FTS_DOC_ID_INDEX ON t1(FTS_DOC_ID);
17
18 SET autocommit=0;
19
20 DELIMITER //;
21 CREATE PROCEDURE populate_t1()
22 BEGIN
23 DECLARE i INT DEFAULT 1;
24 WHILE (i <= 250) DO
25 INSERT INTO t1 (text_content) VALUES ("some_text_1234 aaa");
26 SET i = i + 1;
27 END WHILE;
28 END//
29
30 DELIMITER ;//
31
32 CALL populate_t1;
33 SET autocommit=1;
34
35 SET SESSION debug_dbug="+d,fts_instrument_result_cache_limit";
36
37 ALTER TABLE t1 ADD FULLTEXT INDEX `text_content_idx` (`text_content`);
38
39 # HA_ERR_FTS_EXCEED_RESULT_CACHE_LIMIT = 188
40 --error 128
41 SELECT FTS_DOC_ID, text_content
42 FROM t1
43 WHERE MATCH text_content AGAINST ('+some_text_1234' IN BOOLEAN MODE);
44
45 --error 128
46 UPDATE t1
47 SET text_content='some_text_12345'
48 where MATCH text_content AGAINST ('+some_text_1234' IN BOOLEAN MODE);
49
50 --error 128
51 DELETE FROM t1
52 WHERE MATCH text_content AGAINST ('+some_text_1234' IN BOOLEAN MODE);
53
54 SET GLOBAL innodb_ft_result_cache_limit = @saved_innodb_ft_result_cache_limit;
55
56 DROP TABLE t1;
57 DROP PROCEDURE populate_t1;