Debian Codegraph @

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

raw
1 SET @start_value = @@global.delayed_insert_timeout;
2 SELECT @start_value;
3 @start_value
4 300
5 '#--------------------FN_DYNVARS_025_01------------------------#'
6 SET @@global.delayed_insert_timeout = 100;
7 SET @@global.delayed_insert_timeout = DEFAULT;
8 SELECT @@global.delayed_insert_timeout;
9 @@global.delayed_insert_timeout
10 300
11 '#---------------------FN_DYNVARS_025_02-------------------------#'
12 SET @@global.delayed_insert_timeout = @start_value;
13 SELECT @@global.delayed_insert_timeout = 300;
14 @@global.delayed_insert_timeout = 300
15 1
16 '#--------------------FN_DYNVARS_025_03------------------------#'
17 SET @@global.delayed_insert_timeout = 10000;
18 SELECT @@global.delayed_insert_timeout;
19 @@global.delayed_insert_timeout
20 10000
21 SET @@global.delayed_insert_timeout = 429;
22 SELECT @@global.delayed_insert_timeout;
23 @@global.delayed_insert_timeout
24 429
25 SET @@global.delayed_insert_timeout = 1;
26 SELECT @@global.delayed_insert_timeout;
27 @@global.delayed_insert_timeout
28 1
29 '#--------------------FN_DYNVARS_025_04-------------------------#'
30 SET @@global.delayed_insert_timeout = 0;
31 Warnings:
32 Warning 1292 Truncated incorrect delayed_insert_timeout value: '0'
33 SELECT @@global.delayed_insert_timeout;
34 @@global.delayed_insert_timeout
35 1
36 SET @@global.delayed_insert_timeout = -1024;
37 Warnings:
38 Warning 1292 Truncated incorrect delayed_insert_timeout value: '-1024'
39 SELECT @@global.delayed_insert_timeout;
40 @@global.delayed_insert_timeout
41 1
42 SET @@global.delayed_insert_timeout = 42949672950;
43 Warnings:
44 Warning 1292 Truncated incorrect delayed_insert_timeout value: '42949672950'
45 SELECT @@global.delayed_insert_timeout;
46 @@global.delayed_insert_timeout
47 31536000
48 SET @@global.delayed_insert_timeout = 429496729.5;
49 ERROR 42000: Incorrect argument type to variable 'delayed_insert_timeout'
50 SELECT @@global.delayed_insert_timeout;
51 @@global.delayed_insert_timeout
52 31536000
53 SET @@global.delayed_insert_timeout = ON;
54 ERROR 42000: Incorrect argument type to variable 'delayed_insert_timeout'
55 SELECT @@global.delayed_insert_timeout;
56 @@global.delayed_insert_timeout
57 31536000
58 '#-------------------FN_DYNVARS_025_05----------------------------#'
59 SET @@session.delayed_insert_timeout = 0;
60 ERROR HY000: Variable 'delayed_insert_timeout' is a GLOBAL variable and should be set with SET GLOBAL
61 SELECT @@session.dalayed_insert_timeout;
62 ERROR HY000: Unknown system variable 'dalayed_insert_timeout'
63 '#----------------------FN_DYNVARS_025_06------------------------#'
64 SELECT @@global.delayed_insert_timeout = VARIABLE_VALUE
65 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
66 WHERE VARIABLE_NAME='delayed_insert_timeout';
67 @@global.delayed_insert_timeout = VARIABLE_VALUE
68 1
69 SELECT @@delayed_insert_timeout = VARIABLE_VALUE
70 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
71 WHERE VARIABLE_NAME='delayed_insert_timeout';
72 @@delayed_insert_timeout = VARIABLE_VALUE
73 1
74 '#---------------------FN_DYNVARS_025_07----------------------#'
75 SET @@global.delayed_insert_timeout = TRUE;
76 SELECT @@global.delayed_insert_timeout;
77 @@global.delayed_insert_timeout
78 1
79 SET @@global.delayed_insert_timeout = FALSE;
80 Warnings:
81 Warning 1292 Truncated incorrect delayed_insert_timeout value: '0'
82 SELECT @@global.delayed_insert_timeout;
83 @@global.delayed_insert_timeout
84 1
85 '#---------------------FN_DYNVARS_025_08----------------------#'
86 SET @@global.delayed_insert_timeout = 1;
87 SELECT @@delayed_insert_timeout = @@global.delayed_insert_timeout;
88 @@delayed_insert_timeout = @@global.delayed_insert_timeout
89 1
90 '#---------------------FN_DYNVARS_025_09----------------------#'
91 SET delayed_insert_timeout = 1;
92 ERROR HY000: Variable 'delayed_insert_timeout' is a GLOBAL variable and should be set with SET GLOBAL
93 SELECT @@delayed_insert_timeout;
94 @@delayed_insert_timeout
95 1
96 SELECT local.delayed_insert_timeout;
97 ERROR 42S02: Unknown table 'local' in SELECT
98 SELECT global.delayed_insert_timeout;
99 ERROR 42S02: Unknown table 'global' in SELECT
100 SELECT delayed_insert_timeout = @@session.delayed_insert_timeout;
101 ERROR 42S22: Unknown column 'delayed_insert_timeout' in 'SELECT'
102 SET @@global.delayed_insert_timeout = @start_value;
103 SELECT @@global.delayed_insert_timeout;
104 @@global.delayed_insert_timeout
105 300
106 SET @@global.delayed_insert_timeout = @start_value;
107 SELECT @@global.delayed_insert_timeout;
108 @@global.delayed_insert_timeout
109 300