Debian Codegraph @

mysql-test/suite/sys_vars/t/mysqlx_wait_timeout_basic.test

raw
1 # Variable Name: mysqlx_wait_timeout #
2 # Creation Date: 2017-12-20 #
3 # Author: Horst Hunger #
4
5 --source include/not_windows.inc
6 --source include/load_sysvars.inc
7
8 SET @start_global_value = @@global.mysqlx_wait_timeout;
9 SET @start_session_value = @@session.mysqlx_wait_timeout;
10
11 SET @@global.mysqlx_wait_timeout = 100;
12 SET @@global.mysqlx_wait_timeout = DEFAULT;
13 SELECT @@global.mysqlx_wait_timeout;
14
15 SET @@session.mysqlx_wait_timeout = 200;
16 SET @@session.mysqlx_wait_timeout = DEFAULT;
17 SELECT @@session.mysqlx_wait_timeout;
18
19 SET @@global.mysqlx_wait_timeout = DEFAULT;
20 SELECT @@global.mysqlx_wait_timeout = @default_mysqlx_wait_timeout;
21
22 SET @@session.mysqlx_wait_timeout = DEFAULT;
23 SELECT @@session.mysqlx_wait_timeout = @default_mysqlx_wait_timeout;
24
25 SET @@global.mysqlx_wait_timeout= 1;
26 SELECT @@global.mysqlx_wait_timeout;
27
28 SET @@global.mysqlx_wait_timeout = 60020;
29 SELECT @@global.mysqlx_wait_timeout;
30
31 SET @@global.mysqlx_wait_timeout = 31536000;
32 SELECT @@global.mysqlx_wait_timeout = @max_mysqlx_wait_timeout;
33
34 SET @@session.mysqlx_wait_timeout =6000;
35 SELECT @@session.mysqlx_wait_timeout;
36
37 SET @@global.mysqlx_wait_timeout = 0;
38 SELECT @@global.mysqlx_wait_timeout;
39 SET @@global.mysqlx_wait_timeout = -1024;
40 SELECT @@global.mysqlx_wait_timeout;
41 SET @@global.mysqlx_wait_timeout = 123456789031;
42 SELECT @@global.mysqlx_wait_timeout;
43 SET @@global.mysqlx_wait_timeout = 31536003;
44 SELECT @@global.mysqlx_wait_timeout;
45 --Error ER_WRONG_TYPE_FOR_VAR
46 SET @@global.mysqlx_wait_timeout = ' ';
47 SELECT @@global.mysqlx_wait_timeout;
48
49 --Error ER_WRONG_TYPE_FOR_VAR
50 SET @@global.mysqlx_wait_timeout = ON;
51
52 --Error ER_WRONG_TYPE_FOR_VAR
53 SET @@global.mysqlx_wait_timeout = OFF;
54
55 SET @@global.mysqlx_wait_timeout = True;
56 SELECT @@global.mysqlx_wait_timeout;
57
58 SET @@global.mysqlx_wait_timeout = False;
59 SELECT @@global.mysqlx_wait_timeout;
60 --Error ER_WRONG_TYPE_FOR_VAR
61 SET @@global.mysqlx_wait_timeout = 65530.34;
62 SELECT @@global.mysqlx_wait_timeout;
63
64 --Error ER_WRONG_TYPE_FOR_VAR
65 SET @@global.mysqlx_wait_timeout ="Test";
66
67 --Error ER_WRONG_TYPE_FOR_VAR
68 SET @@session.mysqlx_wait_timeout = ON;
69
70 --Error ER_WRONG_TYPE_FOR_VAR
71 SET @@session.mysqlx_wait_timeout = OFF;
72
73 SET @@session.mysqlx_wait_timeout = True;
74 SELECT @@session.mysqlx_wait_timeout;
75
76 SET @@session.mysqlx_wait_timeout = False;
77 SELECT @@session.mysqlx_wait_timeout;
78
79 --Error ER_WRONG_TYPE_FOR_VAR
80 SET @@session.mysqlx_wait_timeout = "Test";
81 --Error ER_WRONG_TYPE_FOR_VAR
82 SET @@session.mysqlx_wait_timeout = 65530.34;
83 SELECT @@session.mysqlx_wait_timeout;
84 --Error ER_WRONG_TYPE_FOR_VAR
85 SET @@session.mysqlx_wait_timeout = 'test';
86 SET @@session.mysqlx_wait_timeout = 0;
87 SELECT @@session.mysqlx_wait_timeout;
88 SELECT @@session.mysqlx_wait_timeout = @max_mysqlx_wait_timeout;
89 SELECT @@session.mysqlx_wait_timeout;
90 --Error ER_WRONG_TYPE_FOR_VAR
91 SET @@session.mysqlx_wait_timeout = ' ';
92 SELECT @@session.mysqlx_wait_timeout;
93
94 --disable_warnings
95 SELECT @@global.mysqlx_wait_timeout = VARIABLE_VALUE
96 FROM performance_schema.global_variables
97 WHERE VARIABLE_NAME='mysqlx_wait_timeout';
98 --enable_warnings
99
100 --disable_warnings
101 SELECT @@session.mysqlx_wait_timeout = VARIABLE_VALUE
102 FROM performance_schema.session_variables
103 WHERE VARIABLE_NAME='mysqlx_wait_timeout';
104 --enable_warnings
105
106 SET @@global.mysqlx_wait_timeout = 30000;
107 SET @@global.mysqlx_wait_timeout = 40000;
108 SELECT @@mysqlx_wait_timeout = @@global.mysqlx_wait_timeout;
109
110 SET @@mysqlx_wait_timeout = 100;
111 SELECT @@mysqlx_wait_timeout = @@local.mysqlx_wait_timeout;
112 SELECT @@local.mysqlx_wait_timeout = @@session.mysqlx_wait_timeout;
113
114 SET mysqlx_wait_timeout = 1027;
115 SELECT @@mysqlx_wait_timeout;
116
117 --Error ER_UNKNOWN_TABLE
118 SELECT local.mysqlx_wait_timeout;
119
120 --Error ER_UNKNOWN_TABLE
121 SELECT session.mysqlx_wait_timeout;
122
123 --Error ER_BAD_FIELD_ERROR
124 SELECT mysqlx_wait_timeout = @@session.mysqlx_wait_timeout;
125
126 SET @@global.mysqlx_wait_timeout = @start_global_value;
127 SET @@session.mysqlx_wait_timeout = @start_session_value;