diff options
author | Igor Babaev <igor@askmonty.org> | 2012-06-01 13:42:39 -0700 |
---|---|---|
committer | Igor Babaev <igor@askmonty.org> | 2012-06-01 13:42:39 -0700 |
commit | 27ab01243cbc7ddba29704afe31d0812652be19b (patch) | |
tree | b50e061d5fe668cc49d270664a67422dd043e9d5 /mysql-test/t/log_state.test | |
parent | 6ac0363426f96c26c64447f0aa7fbd8a13ecc313 (diff) | |
parent | afedd72e225654225b20a91b072b012e4c57a9d4 (diff) | |
download | mariadb-git-27ab01243cbc7ddba29704afe31d0812652be19b.tar.gz |
Merge
Diffstat (limited to 'mysql-test/t/log_state.test')
-rw-r--r-- | mysql-test/t/log_state.test | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/mysql-test/t/log_state.test b/mysql-test/t/log_state.test index d47044fbbee..e8f0bf8c511 100644 --- a/mysql-test/t/log_state.test +++ b/mysql-test/t/log_state.test @@ -332,13 +332,13 @@ CREATE TABLE t2 (b INT, PRIMARY KEY (b)); INSERT INTO t2 VALUES (3),(4); connect (con2,localhost,root,,); -INSERT INTO t1 VALUES (1+sleep(.01)),(2); -INSERT INTO t1 SELECT b+sleep(.01) from t2; -UPDATE t1 SET a=a+sleep(.01) WHERE a>2; -UPDATE t1 SET a=a+sleep(.01) ORDER BY a DESC; -UPDATE t2 set b=b+sleep(.01) limit 1; -UPDATE t1 SET a=a+sleep(.01) WHERE a in (SELECT b from t2); -DELETE FROM t1 WHERE a=a+sleep(.01) ORDER BY a LIMIT 2; +INSERT INTO t1 VALUES (1+sleep(.02)),(2); +INSERT INTO t1 SELECT b+sleep(.02) from t2; +UPDATE t1 SET a=a+sleep(.02) WHERE a>2; +UPDATE t1 SET a=a+sleep(.02) ORDER BY a DESC; +UPDATE t2 set b=b+sleep(.02) limit 1; +UPDATE t1 SET a=a+sleep(.02) WHERE a in (SELECT b from t2); +DELETE FROM t1 WHERE a=a+sleep(.02) ORDER BY a LIMIT 2; SELECT rows_examined,sql_text FROM mysql.slow_log; disconnect con2; |