Debian Codegraph @

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

raw
1 # Variable Name: interactive_timeout #
2 # Creation Date: 2017-12-20 #
3 # Author: Horst Hunger #
4
5 --source include/load_sysvars.inc
6
7 SET @start_global_value = @@global.mysqlx_interactive_timeout;
8 SELECT @start_global_value;
9
10 SET @@global.mysqlx_interactive_timeout = 100;
11 SET @@global.mysqlx_interactive_timeout = DEFAULT;
12 SELECT @@global.mysqlx_interactive_timeout;
13
14 --error ER_GLOBAL_VARIABLE
15 SET @@session.mysqlx_interactive_timeout = DEFAULT;
16
17 SET @@global.mysqlx_interactive_timeout = DEFAULT;
18 SELECT @@global.mysqlx_interactive_timeout = 28800;
19
20 SET @@global.mysqlx_interactive_timeout = 1;
21 SELECT @@global.mysqlx_interactive_timeout;
22 SET @@global.mysqlx_interactive_timeout = 60020;
23 SELECT @@global.mysqlx_interactive_timeout;
24 SET @@global.mysqlx_interactive_timeout = 65535;
25 SELECT @@global.mysqlx_interactive_timeout;
26 SET @@global.mysqlx_interactive_timeout = 31536000;
27 SELECT @@global.mysqlx_interactive_timeout;
28
29 SET @@global.mysqlx_interactive_timeout = 0;
30 SELECT @@global.mysqlx_interactive_timeout;
31 SET @@global.mysqlx_interactive_timeout = -1024;
32 SELECT @@global.mysqlx_interactive_timeout;
33 SET @@global.mysqlx_interactive_timeout = 31536001;
34 SELECT @@global.mysqlx_interactive_timeout;
35 SET @@global.mysqlx_interactive_timeout = 1000000000;
36 SELECT @@global.mysqlx_interactive_timeout;
37 --Error ER_WRONG_TYPE_FOR_VAR
38 SET @@global.mysqlx_interactive_timeout = 65530.34;
39 SELECT @@global.mysqlx_interactive_timeout;
40 --Error ER_WRONG_TYPE_FOR_VAR
41 SET @@global.mysqlx_interactive_timeout = test;
42 SELECT @@global.mysqlx_interactive_timeout;
43
44 --disable_warnings
45 SELECT @@global.mysqlx_interactive_timeout = VARIABLE_VALUE
46 FROM performance_schema.global_variables
47 WHERE VARIABLE_NAME='mysqlx_interactive_timeout';
48 --enable_warnings
49
50 SET @@global.mysqlx_interactive_timeout = TRUE;
51 SELECT @@global.mysqlx_interactive_timeout;
52 SET @@global.mysqlx_interactive_timeout = FALSE;
53 SELECT @@global.mysqlx_interactive_timeout;
54
55 SET @@global.mysqlx_interactive_timeout = 10;
56 SELECT @@mysqlx_interactive_timeout = @@global.mysqlx_interactive_timeout;
57
58 --error ER_GLOBAL_VARIABLE
59 SET @@mysqlx_interactive_timeout = 100;
60
61 --error ER_GLOBAL_VARIABLE
62 SET mysqlx_interactive_timeout = 1;
63
64 SET @@global.mysqlx_interactive_timeout = @start_global_value;
65