1** Setup ** 2 3** Connecting con0 using root ** 4** Connecting con1 using root ** 5** Connection default ** 6SET @global_low_priority_updates = @@GLOBAL.low_priority_updates; 7SET @session_low_priority_updates = @@SESSION.low_priority_updates; 8CREATE TABLE t1 (a varchar(100)); 9create view v1 as select * from t1; 10'#--------------------FN_DYNVARS_160_01-------------------------#' 11** Connection con0 ** 12SET SESSION low_priority_updates = ON; 13** Connection con1 ** 14SET SESSION low_priority_updates = ON; 15** Connection default ** 16SET SESSION low_priority_updates = ON; 17INSERT INTO t1 VALUES('1'); 18INSERT INTO t1 VALUES('2'); 19INSERT INTO t1 VALUES('3'); 20INSERT INTO t1 VALUES('4'); 21INSERT INTO t1 VALUES('5'); 22INSERT INTO t1 VALUES('6'); 23LOCK TABLE v1 WRITE; 24** Connection con1 ** 25** Asynchronous Execution ** 26UPDATE t1 SET a = CONCAT(a,"-updated");| 27** Connection con0 ** 28** Asynchronous Execution ** 29LOCK TABLE t1 READ; 30SELECT * FROM t1; 31UNLOCK TABLES;| 32** Connection default ** 33UNLOCK TABLES; 34** Connection con0 ** 35** Asynchronous Result ** 36a 371 382 393 404 415 426 43Expected values of a without -updated; 44** Connection default ** 45DELETE FROM t1; 46'#--------------------FN_DYNVARS_160_02-------------------------#' 47** Connection con0 ** 48SET SESSION low_priority_updates = OFF; 49** Connection con1 ** 50SET SESSION low_priority_updates = OFF; 51** Connection default** 52SET SESSION low_priority_updates = OFF; 53INSERT INTO t1 VALUES('1'); 54INSERT INTO t1 VALUES('2'); 55INSERT INTO t1 VALUES('3'); 56INSERT INTO t1 VALUES('4'); 57INSERT INTO t1 VALUES('5'); 58INSERT INTO t1 VALUES('6'); 59LOCK TABLE v1 WRITE; 60** Connection con1 ** 61** Asynchronous Execution ** 62UPDATE t1 SET a = CONCAT(a,"-updated");| 63** Connection con0 ** 64** Asynchronous Execution ** 65LOCK TABLE t1 READ; 66SELECT * FROM t1; 67UNLOCK TABLES;| 68** Connection default ** 69UNLOCK TABLES; 70** Connection con0 ** 71** Asynchronous Result ** 72a 731-updated 742-updated 753-updated 764-updated 775-updated 786-updated 79Expected values of a with -updated; 80** Connection default** 81DELETE FROM t1; 82'#--------------------FN_DYNVARS_160_03-------------------------#' 83** Connecting con_int1 using root ** 84** Connection con_int1 ** 85SELECT @@SESSION.low_priority_updates; 86@@SESSION.low_priority_updates 870 881 / TRUE Expected 89SET SESSION low_priority_updates = FALSE; 90** Connecting con_int2 using root ** 91** Connection con_int2 ** 92SELECT @@SESSION.low_priority_updates; 93@@SESSION.low_priority_updates 940 951 / TRUE Expected 96SET SESSION low_priority_updates = TRUE; 97** Connection con_int1 ** 98SELECT @@SESSION.low_priority_updates; 99@@SESSION.low_priority_updates 1000 1010 / FALSE Expected 102** Connection con_int2 ** 103SELECT @@SESSION.low_priority_updates; 104@@SESSION.low_priority_updates 1051 1061 / TRUE Expected 107** Connection default ** 108Disconnecting Connections con_int1, con_int2 109** Connection default ** 110Disconnecting Connections con0, con1 111drop view v1; 112DROP TABLE t1; 113SET @@GLOBAL.low_priority_updates = @global_low_priority_updates; 114SET @@SESSION.low_priority_updates = @session_low_priority_updates; 115