Debian Codegraph @

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

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