Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.mysqlx_read_timeout;
2 SELECT @start_global_value;
3 @start_global_value
4 30
5 SET @@global.mysqlx_read_timeout = 100;
6 SET @@global.mysqlx_read_timeout = DEFAULT;
7 SELECT @@global.mysqlx_read_timeout;
8 @@global.mysqlx_read_timeout
9 30
10 SET @@session.mysqlx_read_timeout = DEFAULT;
11 SET @@global.mysqlx_read_timeout = DEFAULT;
12 SELECT @@global.mysqlx_read_timeout = 28800;
13 @@global.mysqlx_read_timeout = 28800
14 0
15 SET @@global.mysqlx_read_timeout = 1;
16 SELECT @@global.mysqlx_read_timeout;
17 @@global.mysqlx_read_timeout
18 1
19 SET @@global.mysqlx_read_timeout = 60020;
20 SELECT @@global.mysqlx_read_timeout;
21 @@global.mysqlx_read_timeout
22 60020
23 SET @@global.mysqlx_read_timeout = 65535;
24 SELECT @@global.mysqlx_read_timeout;
25 @@global.mysqlx_read_timeout
26 65535
27 SET @@global.mysqlx_read_timeout = 31536000;
28 Warnings:
29 Warning 1292 Truncated incorrect mysqlx_read_timeout value: '31536000'
30 SELECT @@global.mysqlx_read_timeout;
31 @@global.mysqlx_read_timeout
32 2147483
33 SET @@global.mysqlx_read_timeout = 0;
34 Warnings:
35 Warning 1292 Truncated incorrect mysqlx_read_timeout value: '0'
36 SELECT @@global.mysqlx_read_timeout;
37 @@global.mysqlx_read_timeout
38 1
39 SET @@global.mysqlx_read_timeout = -1024;
40 Warnings:
41 Warning 1292 Truncated incorrect mysqlx_read_timeout value: '-1024'
42 SELECT @@global.mysqlx_read_timeout;
43 @@global.mysqlx_read_timeout
44 1
45 SET @@global.mysqlx_read_timeout = 31536001;
46 Warnings:
47 Warning 1292 Truncated incorrect mysqlx_read_timeout value: '31536001'
48 SELECT @@global.mysqlx_read_timeout;
49 @@global.mysqlx_read_timeout
50 2147483
51 SET @@global.mysqlx_read_timeout = 1000000000;
52 Warnings:
53 Warning 1292 Truncated incorrect mysqlx_read_timeout value: '1000000000'
54 SELECT @@global.mysqlx_read_timeout;
55 @@global.mysqlx_read_timeout
56 2147483
57 SET @@global.mysqlx_read_timeout = 65530.34;
58 ERROR 42000: Incorrect argument type to variable 'mysqlx_read_timeout'
59 SELECT @@global.mysqlx_read_timeout;
60 @@global.mysqlx_read_timeout
61 2147483
62 SET @@global.mysqlx_read_timeout = test;
63 ERROR 42000: Incorrect argument type to variable 'mysqlx_read_timeout'
64 SELECT @@global.mysqlx_read_timeout;
65 @@global.mysqlx_read_timeout
66 2147483
67 SELECT @@global.mysqlx_read_timeout = VARIABLE_VALUE
68 FROM performance_schema.global_variables
69 WHERE VARIABLE_NAME='mysqlx_read_timeout';
70 @@global.mysqlx_read_timeout = VARIABLE_VALUE
71 1
72 SET @@global.mysqlx_read_timeout = TRUE;
73 SELECT @@global.mysqlx_read_timeout;
74 @@global.mysqlx_read_timeout
75 1
76 SET @@global.mysqlx_read_timeout = FALSE;
77 Warnings:
78 Warning 1292 Truncated incorrect mysqlx_read_timeout value: '0'
79 SELECT @@global.mysqlx_read_timeout;
80 @@global.mysqlx_read_timeout
81 1
82 SET @@global.mysqlx_read_timeout = 10;
83 SELECT @@mysqlx_read_timeout = @@global.mysqlx_read_timeout;
84 @@mysqlx_read_timeout = @@global.mysqlx_read_timeout
85 0
86 SET @@mysqlx_read_timeout = 100;
87 SET mysqlx_read_timeout = 1;
88 SET @@global.mysqlx_read_timeout = @start_global_value;