summaryrefslogtreecommitdiff
path: root/mysql-test/t/rpl000001.test
diff options
context:
space:
mode:
authorunknown <sasha@mysql.sashanet.com>2001-04-12 13:46:19 -0600
committerunknown <sasha@mysql.sashanet.com>2001-04-12 13:46:19 -0600
commit4d4dbc94c2f386c36c5bcb64213bebb5693af208 (patch)
tree6b6eccc0d4314f9fdf07f9dfbc2a30d22af14870 /mysql-test/t/rpl000001.test
parentfa30245c81d8a4412d4d10a44d84fb43cc6c6b1e (diff)
downloadmariadb-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.test13
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;