diff options
Diffstat (limited to 'mysql-test/t/insert_notembedded.test')
-rw-r--r-- | mysql-test/t/insert_notembedded.test | 36 |
1 files changed, 0 insertions, 36 deletions
diff --git a/mysql-test/t/insert_notembedded.test b/mysql-test/t/insert_notembedded.test index 713eaf5db40..2769aee8d8a 100644 --- a/mysql-test/t/insert_notembedded.test +++ b/mysql-test/t/insert_notembedded.test @@ -156,41 +156,5 @@ connection default; DROP DATABASE meow; -# -# Bug#28587 SELECT is blocked by INSERT waiting on read lock, even with low_priority_updates -# ---echo connection: default -set low_priority_updates=1; ---disable_warnings -drop table if exists t1; ---enable_warnings -create table t1 (a int, b int, unique key t1$a (a)); -lock table t1 read; -connect (update,localhost,root,,); -connection update; ---echo connection: update -set low_priority_updates=1; -show variables like 'low_priority_updates'; -let $ID= `select connection_id()`; ---send insert into t1 values (1, 2) ON DUPLICATE KEY UPDATE b = 2; -connection default; -# we must wait till the insert opens and locks the table -let $wait_condition= - select count(*) = 1 from information_schema.processlist - where state = "Waiting for table level lock" and id = $ID; ---source include/wait_condition.inc -connect (select,localhost,root,,); ---echo connection: select -select * from t1; -connection default; ---echo connection: default -select * from t1; -connection default; -disconnect update; -disconnect select; -unlock tables; -drop table t1; -set low_priority_updates=default; - set local sql_mode=default; set global sql_mode=default; |