Debian Codegraph @

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

raw
1 #
2 # Bug 1634932: Assertion failure in thread x in
3 # file fts0que.cc
4 #
5 SET @saved_innodb_ft_result_cache_limit= @@global.innodb_ft_result_cache_limit;
6 CREATE TABLE `t1` (
7 `FTS_DOC_ID` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
8 `text_content` MEDIUMTEXT, PRIMARY KEY (`FTS_DOC_ID`)
9 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
10 CREATE UNIQUE INDEX FTS_DOC_ID_INDEX ON t1(FTS_DOC_ID);
11 SET autocommit=0;
12 CREATE PROCEDURE populate_t1()
13 BEGIN
14 DECLARE i INT DEFAULT 1;
15 WHILE (i <= 250) DO
16 INSERT INTO t1 (text_content) VALUES ("some_text_1234 aaa");
17 SET i = i + 1;
18 END WHILE;
19 END//
20 CALL populate_t1;
21 SET autocommit=1;
22 SET SESSION debug_dbug="+d,fts_instrument_result_cache_limit";
23 ALTER TABLE t1 ADD FULLTEXT INDEX `text_content_idx` (`text_content`);
24 SELECT FTS_DOC_ID, text_content
25 FROM t1
26 WHERE MATCH text_content AGAINST ('+some_text_1234' IN BOOLEAN MODE);
27 ERROR HY000: Table handler out of memory
28 UPDATE t1
29 SET text_content='some_text_12345'
30 where MATCH text_content AGAINST ('+some_text_1234' IN BOOLEAN MODE);
31 ERROR HY000: Table handler out of memory
32 DELETE FROM t1
33 WHERE MATCH text_content AGAINST ('+some_text_1234' IN BOOLEAN MODE);
34 ERROR HY000: Table handler out of memory
35 SET GLOBAL innodb_ft_result_cache_limit = @saved_innodb_ft_result_cache_limit;
36 DROP TABLE t1;
37 DROP PROCEDURE populate_t1;