diff options
| author | Guilhem Bichot <guilhem@mysql.com> | 2009-03-11 16:32:42 +0100 |
|---|---|---|
| committer | Guilhem Bichot <guilhem@mysql.com> | 2009-03-11 16:32:42 +0100 |
| commit | e64f438ec7d50f18c82719a3d1c2e5597ea27aab (patch) | |
| tree | ee09976ab4dd9dee924a4c7e30eb0fc9f5e7d63f /mysql-test/r/delayed.result | |
| parent | f34ec421e6d61cbc09feaf86633fd376048952bd (diff) | |
| parent | 197bb45e0c3a97c1e927ea8771d386e63f70c69e (diff) | |
| download | mariadb-git-e64f438ec7d50f18c82719a3d1c2e5597ea27aab.tar.gz | |
merge of 5.1-main into 5.1-maria; MyISAM changes are also ported to Maria.
Diffstat (limited to 'mysql-test/r/delayed.result')
| -rw-r--r-- | mysql-test/r/delayed.result | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/mysql-test/r/delayed.result b/mysql-test/r/delayed.result index 65b358615cf..74fbcc86554 100644 --- a/mysql-test/r/delayed.result +++ b/mysql-test/r/delayed.result @@ -288,4 +288,30 @@ ERROR 22007: Incorrect date value: '0000-00-00' for column 'f1' at row 1 INSERT DELAYED INTO t2 VALUES (0,'2007-00-00'); ERROR 22007: Incorrect date value: '2007-00-00' for column 'f1' at row 1 DROP TABLE t1,t2; +set @old_delayed_updates = @@global.low_priority_updates; +set global low_priority_updates = 1; +select @@global.low_priority_updates; +@@global.low_priority_updates +1 +drop table if exists t1; +create table t1 (a int, b int); +insert into t1 values (1,1); +lock table t1 read; +connection: update +insert delayed into t1 values (2,2);; +connection: select +select * from t1; +a b +1 1 +connection: default +select * from t1; +a b +1 1 +unlock tables; +select * from t1; +a b +1 1 +2 2 +drop table t1; +set global low_priority_updates = @old_delayed_updates; End of 5.1 tests |