Debian Codegraph @

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

raw
1 # Variable Name: read_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_read_timeout;
8 SELECT @start_global_value;
9
10 SET @@global.mysqlx_read_timeout = 100;
11 SET @@global.mysqlx_read_timeout = DEFAULT;
12 SELECT @@global.mysqlx_read_timeout;
13
14 SET @@session.mysqlx_read_timeout = DEFAULT;
15
16 SET @@global.mysqlx_read_timeout = DEFAULT;
17 SELECT @@global.mysqlx_read_timeout = 28800;
18
19 SET @@global.mysqlx_read_timeout = 1;
20 SELECT @@global.mysqlx_read_timeout;
21 SET @@global.mysqlx_read_timeout = 60020;
22 SELECT @@global.mysqlx_read_timeout;
23 SET @@global.mysqlx_read_timeout = 65535;
24 SELECT @@global.mysqlx_read_timeout;
25 SET @@global.mysqlx_read_timeout = 31536000;
26 SELECT @@global.mysqlx_read_timeout;
27
28 SET @@global.mysqlx_read_timeout = 0;
29 SELECT @@global.mysqlx_read_timeout;
30 SET @@global.mysqlx_read_timeout = -1024;
31 SELECT @@global.mysqlx_read_timeout;
32 SET @@global.mysqlx_read_timeout = 31536001;
33 SELECT @@global.mysqlx_read_timeout;
34 SET @@global.mysqlx_read_timeout = 1000000000;
35 SELECT @@global.mysqlx_read_timeout;
36 --Error ER_WRONG_TYPE_FOR_VAR
37 SET @@global.mysqlx_read_timeout = 65530.34;
38 SELECT @@global.mysqlx_read_timeout;
39 --Error ER_WRONG_TYPE_FOR_VAR
40 SET @@global.mysqlx_read_timeout = test;
41 SELECT @@global.mysqlx_read_timeout;
42
43 --disable_warnings
44 SELECT @@global.mysqlx_read_timeout = VARIABLE_VALUE
45 FROM performance_schema.global_variables
46 WHERE VARIABLE_NAME='mysqlx_read_timeout';
47 --enable_warnings
48
49 SET @@global.mysqlx_read_timeout = TRUE;
50 SELECT @@global.mysqlx_read_timeout;
51 SET @@global.mysqlx_read_timeout = FALSE;
52 SELECT @@global.mysqlx_read_timeout;
53
54 SET @@global.mysqlx_read_timeout = 10;
55 SELECT @@mysqlx_read_timeout = @@global.mysqlx_read_timeout;
56
57 SET @@mysqlx_read_timeout = 100;
58
59 SET mysqlx_read_timeout = 1;
60
61 SET @@global.mysqlx_read_timeout = @start_global_value;
62