diff options
| author | Vladislav Vaintroub <vvaintroub@mysql.com> | 2009-12-16 15:34:11 +0100 |
|---|---|---|
| committer | Vladislav Vaintroub <vvaintroub@mysql.com> | 2009-12-16 15:34:11 +0100 |
| commit | 23449e4c854d953e23c76d44021e19f44e2597d0 (patch) | |
| tree | 6ef380be281adedf087a0aeebda5286409211a25 /mysql-test/t/delayed.test | |
| parent | d9aed0bb2a60f11a0e7668602c63dcb456eb71dd (diff) | |
| parent | 65b90d85a5e40dc08e280a4c1b1798f7aa079a00 (diff) | |
| download | mariadb-git-23449e4c854d953e23c76d44021e19f44e2597d0.tar.gz | |
merge
Diffstat (limited to 'mysql-test/t/delayed.test')
| -rw-r--r-- | mysql-test/t/delayed.test | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/t/delayed.test b/mysql-test/t/delayed.test index ee658d70d16..d1e9bc154f5 100644 --- a/mysql-test/t/delayed.test +++ b/mysql-test/t/delayed.test @@ -328,6 +328,30 @@ drop table t1; set global low_priority_updates = @old_delayed_updates; + +--echo # +--echo # Bug #47682 strange behaviour of INSERT DELAYED +--echo # + +--disable_warnings +DROP TABLE IF EXISTS t1, t2; +--enable_warnings + +CREATE TABLE t1 (f1 integer); +CREATE TABLE t2 (f1 integer); + +FLUSH TABLES WITH READ LOCK; +LOCK TABLES t1 READ; + +# ER_CANT_UPDATE_WITH_READLOCK with normal execution +# ER_TABLE_NOT_LOCKED when executed as prepared statement +--error ER_CANT_UPDATE_WITH_READLOCK, ER_TABLE_NOT_LOCKED +INSERT DELAYED INTO t2 VALUES (1); + +UNLOCK TABLES; +DROP TABLE t1, t2; + + --echo End of 5.1 tests |