diff options
Diffstat (limited to 'mysql-test/suite/storage_engine/insert_low_prio.result')
-rw-r--r-- | mysql-test/suite/storage_engine/insert_low_prio.result | 39 |
1 files changed, 39 insertions, 0 deletions
diff --git a/mysql-test/suite/storage_engine/insert_low_prio.result b/mysql-test/suite/storage_engine/insert_low_prio.result new file mode 100644 index 00000000000..561b6296380 --- /dev/null +++ b/mysql-test/suite/storage_engine/insert_low_prio.result @@ -0,0 +1,39 @@ +DROP TABLE IF EXISTS t1; +SET @low_prio_updates = @@global.low_priority_updates; +SET @concur_insert = @@global.concurrent_insert; +SET GLOBAL concurrent_insert = NEVER; +CREATE TABLE t1 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>; +INSERT INTO t1 (a,b) VALUES (1,'f'),(2,'b'); +connect con0,localhost,root,,; +SET lock_wait_timeout = 4; +connect con1,localhost,root,,; +SET lock_wait_timeout = 4; +connect con2,localhost,root,,; +SET lock_wait_timeout = 4; +connection con1; +SELECT SLEEP(1) FROM t1; +connection con0; +INSERT LOW_PRIORITY INTO t1 (a,b) VALUES (3,'z'); +connection con2; +# Should return only 2 rows +SELECT SLEEP(1) FROM t1; +SLEEP(1) +0 +0 +connection con1; +SLEEP(1) +0 +0 +connection con0; +SELECT * FROM t1; +a b +1 f +2 b +3 z +disconnect con0; +disconnect con1; +disconnect con2; +connection default; +SET GLOBAL low_priority_updates = @low_prio_updates; +SET GLOBAL concurrent_insert = @concur_insert; +DROP TABLE t1; |