Spracherkennung für: .test vermutete Sprache: SQL {SQL[88] Lisp[69] Masm[69]} [Methode: maximale Elemente, drei Dimensionen]
source include/master-slave.inc;
create table t1 (a int);
create table t2 (a int);
disable_query_log;
SET @query="INSERT INTO t2 SELECT * FROM t1 WHERE a REGEXP \"0\"";
let $1 = 2000;
while ($1)
{
eval SET @query=concat(@query, " OR a REGEXP '$1'");
dec $1;
}
let $1=`select @query`;
eval $1;
enable_query_log;
# I have seen the slave crash either now or at shutdown
sync_slave_with_master;
connection master;
drop table t1;
drop table t2;
sync_slave_with_master;
# End of 4.1 tests
--source include/rpl_end.inc
[Dauer der Verarbeitung: 0.9 Sekunden]
