diff options
| author | unknown <davi@moksha.local> | 2007-09-06 13:22:34 -0300 |
|---|---|---|
| committer | unknown <davi@moksha.local> | 2007-09-06 13:22:34 -0300 |
| commit | 16c328056cf20e22c934f009d2a9ccabe445e7b5 (patch) | |
| tree | db68548371b3fce08212ad59077e39f67fe442e3 /mysql-test/r/insert_notembedded.result | |
| parent | bfbe3350dde27a30e999a375228873a07880d5b4 (diff) | |
| download | mariadb-git-16c328056cf20e22c934f009d2a9ccabe445e7b5.tar.gz | |
The test case for bug 28587 doesn't work with the embedded version,
the first query is not running while we are doing wait queries on
a second connection.
mysql-test/r/insert_notembedded.result:
Test case result for bug 28587 moved from insert_update.result
mysql-test/r/insert_update.result:
Remove test case result for bug 28587, moving to insert_notembedded.result
mysql-test/t/insert_notembedded.test:
Test case result for bug 28587, moved from insert_update.test
mysql-test/t/insert_update.test:
Remove test case for bug 28587, moving to insert_notembedded.test
Diffstat (limited to 'mysql-test/r/insert_notembedded.result')
| -rw-r--r-- | mysql-test/r/insert_notembedded.result | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/r/insert_notembedded.result b/mysql-test/r/insert_notembedded.result index 816060b7ec9..ac69cb65972 100644 --- a/mysql-test/r/insert_notembedded.result +++ b/mysql-test/r/insert_notembedded.result @@ -105,3 +105,22 @@ DROP VIEW view_target2; DROP VIEW view_target3; DROP USER user20989@localhost; DROP DATABASE meow; +connection: default +set low_priority_updates=1; +drop table if exists t1; +create table t1 (a int, b int, unique key t1$a (a)); +lock table t1 read; +connection: update +set low_priority_updates=1; +show variables like 'low_priority_updates'; +Variable_name Value +low_priority_updates ON +insert into t1 values (1, 2) ON DUPLICATE KEY UPDATE b = 2;; +connection: select +select * from t1; +a b +connection: default +select * from t1; +a b +drop table t1; +set low_priority_updates=default; |