diff options
Diffstat (limited to 'mysql-test/r/lock_multi_bug38499.result')
| -rw-r--r-- | mysql-test/r/lock_multi_bug38499.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/lock_multi_bug38499.result b/mysql-test/r/lock_multi_bug38499.result index 6922312b298..521ea010816 100644 --- a/mysql-test/r/lock_multi_bug38499.result +++ b/mysql-test/r/lock_multi_bug38499.result @@ -1,5 +1,8 @@ SET @odl_sync_frm = @@global.sync_frm; SET @@global.sync_frm = OFF; +connect locker,localhost,root,,; +connect writer,localhost,root,,; +connection default; DROP TABLE IF EXISTS t1; CREATE TABLE t1( a INT, b INT ); CREATE TABLE t2( a INT, b INT ); @@ -11,7 +14,9 @@ INSERT INTO t2 VALUES (1, 1), (2, 2), (3, 3), (4, 4); # 1.1.2. PS mode # 1.2. test altering of columns that multiupdate uses # 1.2.1. normal mode +connection default; # 1.2.2. PS mode +connection default; ALTER TABLE t1 ADD COLUMN a INT; # 2. test UNIONs # 2.1. test altering of columns that multiupdate doesn't use @@ -19,6 +24,10 @@ ALTER TABLE t1 ADD COLUMN a INT; # 2.1.2. PS mode # 2.2. test altering of columns that multiupdate uses # 2.2.1. normal mode +connection default; # 2.2.2. PS mode +connection default; DROP TABLE t1,t2; +disconnect locker; +disconnect writer; SET @@global.sync_frm = @odl_sync_frm; |