Debian Codegraph @

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

raw
1 SET @start_session_value = @@session.default_master_connection;
2 SELECT @start_session_value;
3 @start_session_value
4
5 SET @@session.default_master_connection = 'bar';
6 SET @@session.default_master_connection = DEFAULT;
7 SELECT @@session.default_master_connection;
8 @@session.default_master_connection
9
10 SET @@session.default_master_connection = @start_session_value;
11 SELECT @@session.default_master_connection = '';
12 @@session.default_master_connection = ''
13 1
14 SET @@global.default_master_connection = 'master1';
15 ERROR HY000: Variable 'default_master_connection' is a SESSION variable and can't be used with SET GLOBAL
16 SELECT @@global.default_master_connection;
17 ERROR HY000: Variable 'default_master_connection' is a SESSION variable
18 SET @@session.default_master_connection = 'master1';
19 SELECT @@session.default_master_connection;
20 @@session.default_master_connection
21 master1
22 SET @@session.default_master_connection = '';
23 SELECT @@session.default_master_connection;
24 @@session.default_master_connection
25
26 SET @@session.default_master_connection = '1234-5678';
27 SELECT @@session.default_master_connection;
28 @@session.default_master_connection
29 1234-5678
30 SET @@session.default_master_connection = '@!*/"';
31 SELECT @@session.default_master_connection;
32 @@session.default_master_connection
33 @!*/"
34 SET @@session.default_master_connection = REPEAT('a',191);
35 SELECT @@session.default_master_connection;
36 @@session.default_master_connection
37 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
38 SET @@session.default_master_connection = master2;
39 SELECT @@session.default_master_connection;
40 @@session.default_master_connection
41 master2
42 SET @@session.default_master_connection = 1;
43 ERROR 42000: Incorrect argument type to variable 'default_master_connection'
44 SET @@session.default_master_connection = 65530.30;
45 ERROR 42000: Incorrect argument type to variable 'default_master_connection'
46 SET @@session.default_master_connection = FALSE;
47 ERROR 42000: Incorrect argument type to variable 'default_master_connection'
48 SELECT @@session.default_master_connection;
49 @@session.default_master_connection
50 master2
51 SET @@session.default_master_connection = REPEAT('a',192);
52 ERROR 42000: Variable 'default_master_connection' can't be set to the value of 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'
53 SELECT @@session.default_master_connection;
54 @@session.default_master_connection
55 master2
56 SET @@session.default_master_connection = NULL;
57 ERROR 42000: Variable 'default_master_connection' can't be set to the value of 'NULL'
58 SELECT @@session.default_master_connection;
59 @@session.default_master_connection
60 master2
61 SELECT @@global.default_master_connection = VARIABLE_VALUE
62 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
63 WHERE VARIABLE_NAME='default_master_connection';
64 ERROR HY000: Variable 'default_master_connection' is a SESSION variable
65 SELECT @@session.default_master_connection = VARIABLE_VALUE
66 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
67 WHERE VARIABLE_NAME='default_master_connection';
68 @@session.default_master_connection = VARIABLE_VALUE
69 1
70 SET @@default_master_connection = 'foo';
71 SELECT @@default_master_connection = @@local.default_master_connection;
72 @@default_master_connection = @@local.default_master_connection
73 1
74 SELECT @@local.default_master_connection = @@session.default_master_connection;
75 @@local.default_master_connection = @@session.default_master_connection
76 1
77 SET default_master_connection = 'foo';
78 SELECT @@default_master_connection;
79 @@default_master_connection
80 foo
81 SELECT local.default_master_connection;
82 ERROR 42S02: Unknown table 'local' in SELECT
83 SELECT session.default_master_connection;
84 ERROR 42S02: Unknown table 'session' in SELECT
85 SELECT default_master_connection = @@session.default_master_connection;
86 ERROR 42S22: Unknown column 'default_master_connection' in 'SELECT'
87 SET @@session.default_master_connection = @start_session_value;
88 SELECT @@session.default_master_connection;
89 @@session.default_master_connection
90