diff options
author | unknown <sasha@mysql.sashanet.com> | 2001-04-12 13:46:19 -0600 |
---|---|---|
committer | unknown <sasha@mysql.sashanet.com> | 2001-04-12 13:46:19 -0600 |
commit | 4d4dbc94c2f386c36c5bcb64213bebb5693af208 (patch) | |
tree | 6b6eccc0d4314f9fdf07f9dfbc2a30d22af14870 /mysql-test/t/rpl000001.test | |
parent | fa30245c81d8a4412d4d10a44d84fb43cc6c6b1e (diff) | |
download | mariadb-git-4d4dbc94c2f386c36c5bcb64213bebb5693af208.tar.gz |
BitKeeper/triggers/post-commit
do REAL_EMAIL magic
mysql-test/mysql-test-run.sh
added show_failed_diffs
mysql-test/r/bench_count_distinct.result
tired of waiting :-)
mysql-test/r/rpl000001.result
new test results after implementing Monty's Hack (TM)
mysql-test/t/bench_count_distinct.test
tired of waiting
mysql-test/t/rpl000001.test
implemented Monty's Hack (TM) to kill a query in the middle of update
without generating a table with 30,000 rows. This will also avoice the
timing uncertainty
BitKeeper/triggers/post-commit:
do REAL_EMAIL magic
mysql-test/mysql-test-run.sh:
added show_failed_diffs
mysql-test/r/bench_count_distinct.result:
tired of waiting :-)
mysql-test/r/rpl000001.result:
new test results after implementing Monty's Hack (TM)
mysql-test/t/bench_count_distinct.test:
tired of waiting
mysql-test/t/rpl000001.test:
implemented Monty's Hack (TM) to kill a query in the middle of update
without generating a table with 30,000 rows. This will also avoice the
timing uncertainty
Diffstat (limited to 'mysql-test/t/rpl000001.test')
-rw-r--r-- | mysql-test/t/rpl000001.test | 13 |
1 files changed, 10 insertions, 3 deletions
diff --git a/mysql-test/t/rpl000001.test b/mysql-test/t/rpl000001.test index 1170cbebeaf..06b5d92fc8e 100644 --- a/mysql-test/t/rpl000001.test +++ b/mysql-test/t/rpl000001.test @@ -30,7 +30,7 @@ reset slave; connection master; drop table if exists t1,t2; create table t1(n int); -let $1=30000; +let $1=10; while ($1) { eval insert into t1 values($1); @@ -39,10 +39,17 @@ while ($1) create table t2(id int); insert into t2 values(connection_id()); save_master_pos; -send update t1 set n = n + 1; + +connection master1; +#avoid generating result +create temporary table t1_temp(n int); +insert into t1_temp select get_lock('crash_lock', 1) from t2; + +connection master; +send update t1 set n = n + get_lock('crash_lock', 2); connection master1; +sleep 2; select (@id := id) - id from t2; -sleep 0.1; kill @id; drop table t2; connection master; |