Spracherkennung für: .test vermutete Sprache: SQL {SQL[114] VDM[57] ABAP[51]} [Methode: maximale Elemente, drei Dimensionen]
--source include/have_innodb.inc
call mtr.add_suppression("\\[Error\\] InnoDB: \\(Operation interrupted\\) while reading FTS index.");
CREATE TABLE t1 (a VARCHAR(7), b text, FULLTEXT KEY idx (a,b)) ENGINE=InnoDB;
--disable_query_log
BEGIN;
let $n=1000;
while ($n) {
INSERT INTO t1 VALUES('foo bar','boo far');
dec $n;
}
--enable_query_log
COMMIT;
let $id = `SELECT CONNECTION_ID()`;
send SELECT COUNT(*) FROM t1
WHERE MATCH (a,b) AGAINST ('foo bar' IN BOOLEAN MODE);
connect (con1,localhost,root,,);
let $ignore= `SELECT @id := $ID`;
KILL QUERY @id;
disconnect con1;
connection default;
# The following would return a result set if the KILL was not fast enough.
--disable_result_log
--error 0,ER_QUERY_INTERRUPTED,HA_ERR_ABORTED_BY_USER
reap;
--enable_result_log
DROP TABLE t1;
[Dauer der Verarbeitung: 0.3 Sekunden, vorverarbeitet 2026-10-08]