Debian Codegraph @

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

raw
1 --source include/have_innodb.inc
2
3 CREATE TABLE t1 (a VARCHAR(7), b text, FULLTEXT KEY idx (a,b)) ENGINE=InnoDB;
4
5 --disable_query_log
6 BEGIN;
7 let $n=1000;
8 while ($n) {
9 INSERT INTO t1 VALUES('foo bar','boo far');
10 dec $n;
11 }
12 --enable_query_log
13 COMMIT;
14
15 let $id = `SELECT CONNECTION_ID()`;
16 send SELECT COUNT(*) FROM t1
17 WHERE MATCH (a,b) AGAINST ('foo bar' IN BOOLEAN MODE);
18
19 connect (con1,localhost,root,,);
20 let $ignore= `SELECT @id := $ID`;
21 KILL QUERY @id;
22 disconnect con1;
23
24 connection default;
25 # The following would return a result set if the KILL was not fast enough.
26 --disable_result_log
27 --error 0,ER_QUERY_INTERRUPTED,HA_ERR_ABORTED_BY_USER
28 reap;
29 --enable_result_log
30 DROP TABLE t1;