Debian Codegraph @

mysql-test/suite/sys_vars/r/sql_low_priority_updates_func.result

raw
1 ** Setup **
2
3 ** Connecting con0 using root **
4 ** Connecting con1 using root **
5 ** Connection default **
6 SET @global_low_priority_updates = @@GLOBAL.low_priority_updates;
7 SET @session_low_priority_updates = @@SESSION.low_priority_updates;
8 CREATE TABLE t1 (a varchar(100));
9 create view v1 as select * from t1;
10 '#--------------------FN_DYNVARS_160_01-------------------------#'
11 ** Connection con0 **
12 SET SESSION low_priority_updates = ON;
13 ** Connection con1 **
14 SET SESSION low_priority_updates = ON;
15 ** Connection default **
16 SET SESSION low_priority_updates = ON;
17 INSERT INTO t1 VALUES('1');
18 INSERT INTO t1 VALUES('2');
19 INSERT INTO t1 VALUES('3');
20 INSERT INTO t1 VALUES('4');
21 INSERT INTO t1 VALUES('5');
22 INSERT INTO t1 VALUES('6');
23 LOCK TABLE v1 WRITE;
24 ** Connection con1 **
25 ** Asynchronous Execution **
26 UPDATE t1 SET a = CONCAT(a,"-updated");|
27 ** Connection con0 **
28 ** Asynchronous Execution **
29 LOCK TABLE t1 READ;
30 SELECT * FROM t1;
31 UNLOCK TABLES;|
32 ** Connection default **
33 UNLOCK TABLES;
34 ** Connection con0 **
35 ** Asynchronous Result **
36 a
37 1
38 2
39 3
40 4
41 5
42 6
43 Expected values of a without -updated;
44 ** Connection default **
45 DELETE FROM t1;
46 '#--------------------FN_DYNVARS_160_02-------------------------#'
47 ** Connection con0 **
48 SET SESSION low_priority_updates = OFF;
49 ** Connection con1 **
50 SET SESSION low_priority_updates = OFF;
51 ** Connection default**
52 SET SESSION low_priority_updates = OFF;
53 INSERT INTO t1 VALUES('1');
54 INSERT INTO t1 VALUES('2');
55 INSERT INTO t1 VALUES('3');
56 INSERT INTO t1 VALUES('4');
57 INSERT INTO t1 VALUES('5');
58 INSERT INTO t1 VALUES('6');
59 LOCK TABLE v1 WRITE;
60 ** Connection con1 **
61 ** Asynchronous Execution **
62 UPDATE t1 SET a = CONCAT(a,"-updated");|
63 ** Connection con0 **
64 ** Asynchronous Execution **
65 LOCK TABLE t1 READ;
66 SELECT * FROM t1 ORDER BY a ASC;
67 UNLOCK TABLES;|
68 ** Connection default **
69 UNLOCK TABLES;
70 ** Connection con0 **
71 ** Asynchronous Result **
72 a
73 1-updated
74 2-updated
75 3-updated
76 4-updated
77 5-updated
78 6-updated
79 Expected values of a with -updated;
80 ** Connection default**
81 DELETE FROM t1;
82 '#--------------------FN_DYNVARS_160_03-------------------------#'
83 ** Connecting con_int1 using root **
84 ** Connection con_int1 **
85 SELECT @@SESSION.low_priority_updates;
86 @@SESSION.low_priority_updates
87 0
88 1 / TRUE Expected
89 SET SESSION low_priority_updates = FALSE;
90 ** Connecting con_int2 using root **
91 ** Connection con_int2 **
92 SELECT @@SESSION.low_priority_updates;
93 @@SESSION.low_priority_updates
94 0
95 1 / TRUE Expected
96 SET SESSION low_priority_updates = TRUE;
97 ** Connection con_int1 **
98 SELECT @@SESSION.low_priority_updates;
99 @@SESSION.low_priority_updates
100 0
101 0 / FALSE Expected
102 ** Connection con_int2 **
103 SELECT @@SESSION.low_priority_updates;
104 @@SESSION.low_priority_updates
105 1
106 1 / TRUE Expected
107 ** Connection default **
108 Disconnecting Connections con_int1, con_int2
109 ** Connection default **
110 Disconnecting Connections con0, con1
111 drop view v1;
112 DROP TABLE t1;
113 CREATE USER foo, bar;
114 GRANT SESSION_VARIABLES_ADMIN ON *.* TO bar;
115 SELECT @@session.low_priority_updates;
116 @@session.low_priority_updates
117 0
118 SET @@session.low_priority_updates = TRUE;
119 ERROR 42000: Access denied; you need (at least one of) the SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege(s) for this operation
120 SELECT @@session.low_priority_updates;
121 @@session.low_priority_updates
122 0
123 SET @@session.low_priority_updates = TRUE;
124 SELECT @@session.low_priority_updates;
125 @@session.low_priority_updates
126 1
127 DROP USER foo, bar;
128 SET @@GLOBAL.low_priority_updates = @global_low_priority_updates;
129 SET @@SESSION.low_priority_updates = @session_low_priority_updates;