Debian Codegraph @

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

raw
1 SET @global_start_value = @@global.init_connect;
2 SELECT @global_start_value AS INIT_VALUE;
3 INIT_VALUE
4
5 '#--------------------FN_DYNVARS_036_01------------------#'
6 SELECT init_connect;
7 ERROR 42S22: Unknown column 'init_connect' in 'field list'
8 SELECT @@init_connect;
9 @@init_connect
10
11 SET @@global.init_connect='SET autocomit=0';
12 SELECT @@global.init_connect;
13 @@global.init_connect
14 SET autocomit=0
15 SET global init_connect='SET autocomit=0';
16 SELECT global init_connect;
17 ERROR 42S22: Unknown column 'global' in 'field list'
18 SELECT @@global init_connect;
19 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'init_connect' at line 1
20 '#--------------------FN_DYNVARS_036_02-------------------------#'
21 SET @@global.init_connect = 'SET join_buffer_size=8200';
22 SET @@global.init_connect = DEFAULT;
23 SELECT @@global.init_connect;
24 @@global.init_connect
25
26 '#--------------------FN_DYNVARS_036_03-------------------------#'
27 SET @@session.init_connect = '';
28 ERROR HY000: Variable 'init_connect' is a GLOBAL variable and should be set with SET GLOBAL
29 SET @@init_connect = '';
30 ERROR HY000: Variable 'init_connect' is a GLOBAL variable and should be set with SET GLOBAL
31 SELECT @@session.init_connect;
32 ERROR HY000: Variable 'init_connect' is a GLOBAL variable
33 SELECT @@local.init_connect;
34 ERROR HY000: Variable 'init_connect' is a GLOBAL variable
35 '#--------------------FN_DYNVARS_036_04-------------------------#'
36 SET @@global.init_connect="";
37 SELECT @@global.init_connect;
38 @@global.init_connect
39
40 SET @@global.init_connect='SELECT 1,"abc"';
41 SELECT @@global.init_connect;
42 @@global.init_connect
43 SELECT 1,"abc"
44 SET @@global.init_connect='SET @yoursql="mysql"';
45 SELECT @@global.init_connect;
46 @@global.init_connect
47 SET @yoursql="mysql"
48 SET @@global.init_connect="SET autocomit=0;REVOKE ALL ON INFORMATION_SCHEMA.*";
49 SELECT @@global.init_connect;
50 @@global.init_connect
51 SET autocomit=0;REVOKE ALL ON INFORMATION_SCHEMA.*
52 SET @@global.init_connect='set @a="12\034"';
53 SELECT @@global.init_connect;
54 @@global.init_connect
55 set @a="1234"
56 SELECT hex(@@global.init_connect);
57 hex(@@global.init_connect)
58 7365742040613D22313200333422
59 SHOW VARIABLES LIKE 'init_connect';
60 Variable_name Value
61 init_connect set @a="1234"
62 SET @@global.init_connect='SHOW VARIABLES';
63 SELECT @@global.init_connect;
64 @@global.init_connect
65 SHOW VARIABLES
66 SET @@global.init_connect = NULL;
67 SELECT @@global.init_connect;
68 @@global.init_connect
69
70 SET @@global.init_connect='abc 123 +-*/';
71 SELECT @@global.init_connect;
72 @@global.init_connect
73 abc 123 +-*/
74 SET @@global.init_connect=this_will_give_syntax_error;
75 SELECT @@global.init_connect;
76 @@global.init_connect
77 this_will_give_syntax_error
78 SET @@global.init_connect = init_replica;
79 SELECT @@global.init_connect;
80 @@global.init_connect
81 init_replica
82 '#--------------------FN_DYNVARS_036_05-------------------------#'
83 SET @@global.init_connect = true;
84 ERROR 42000: Incorrect argument type to variable 'init_connect'
85 SET @@global.init_connect = false;
86 ERROR 42000: Incorrect argument type to variable 'init_connect'
87 SET @@global.init_connect = 1.1;
88 ERROR 42000: Incorrect argument type to variable 'init_connect'
89 SET @@global.init_connect = 0;
90 ERROR 42000: Incorrect argument type to variable 'init_connect'
91 SET @@global.init_connect = 1;
92 ERROR 42000: Incorrect argument type to variable 'init_connect'
93 SET @@global.init_connect = -1;
94 ERROR 42000: Incorrect argument type to variable 'init_connect'
95 SET @@global.init_connect = ON;
96 SELECT @@global.init_connect;
97 @@global.init_connect
98 ON
99 '#--------------------FN_DYNVARS_036_06-------------------------#'
100 SELECT @@global.init_connect = (SELECT VARIABLE_VALUE
101 FROM performance_schema.global_variables
102 WHERE VARIABLE_NAME='init_connect') AS res;
103 res
104 1
105 SET @@global.init_connect = @global_start_value;
106 SELECT @@global.init_connect;
107 @@global.init_connect
108