Debian Codegraph @

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

raw
1 SET @start_value = @@global.key_buffer_size;
2 '#--------------------FN_DYNVARS_055_01------------------------#'
3 SET @@global.key_buffer_size = DEFAULT;
4 SELECT @@global.key_buffer_size;
5 @@global.key_buffer_size
6 8388608
7 '#---------------------FN_DYNVARS_055_02-------------------------#'
8 SET @@global.key_buffer_size = @start_value;
9 SELECT @@global.key_buffer_size = @start_value;
10 @@global.key_buffer_size = @start_value
11 1
12 '#--------------------FN_DYNVARS_055_03------------------------#'
13 SET @@global.key_buffer_size = 4096;
14 SELECT @@global.key_buffer_size;
15 @@global.key_buffer_size
16 4096
17 SET @@global.key_buffer_size = 65535;
18 Warnings:
19 Warning 1292 Truncated incorrect key_buffer_size value: '65535'
20 SELECT @@global.key_buffer_size;
21 @@global.key_buffer_size
22 61440
23 '#--------------------FN_DYNVARS_055_04-------------------------#'
24 SET @@global.key_buffer_size = -1;
25 ERROR HY000: Cannot drop default keycache
26 SELECT @@global.key_buffer_size;
27 @@global.key_buffer_size
28 61440
29 SET @@global.key_buffer_size = 4;
30 ERROR HY000: Cannot drop default keycache
31 SELECT @@global.key_buffer_size;
32 @@global.key_buffer_size
33 61440
34 SET @@global.key_buffer_size = -1024;
35 ERROR HY000: Cannot drop default keycache
36 SELECT @@global.key_buffer_size;
37 @@global.key_buffer_size
38 61440
39 SET @@global.key_buffer_size = 10000.01;
40 ERROR 42000: Incorrect argument type to variable 'key_buffer_size'
41 SET @@global.key_buffer_size = ' ';
42 ERROR 42000: Incorrect argument type to variable 'key_buffer_size'
43 SET @@global.key_buffer_size = " ";
44 ERROR 42000: Incorrect argument type to variable 'key_buffer_size'
45 SET @@global.key_buffer_size = ON;
46 ERROR 42000: Incorrect argument type to variable 'key_buffer_size'
47 SET @@global.key_buffer_size = 'test';
48 ERROR 42000: Incorrect argument type to variable 'key_buffer_size'
49 '#-------------------FN_DYNVARS_055_05----------------------------#'
50 SET @@session.key_buffer_size = 0;
51 ERROR HY000: Variable 'key_buffer_size' is a GLOBAL variable and should be set with SET GLOBAL
52 '#----------------------FN_DYNVARS_055_06------------------------#'
53 SELECT @@global.key_buffer_size = VARIABLE_VALUE
54 FROM performance_schema.global_variables
55 WHERE VARIABLE_NAME='key_buffer_size';
56 @@global.key_buffer_size = VARIABLE_VALUE
57 1
58 SELECT @@key_buffer_size = VARIABLE_VALUE
59 FROM performance_schema.session_variables
60 WHERE VARIABLE_NAME='key_buffer_size';
61 @@key_buffer_size = VARIABLE_VALUE
62 1
63 '#---------------------FN_DYNVARS_055_07----------------------#'
64 SET @@global.key_buffer_size = TRUE;
65 ERROR HY000: Cannot drop default keycache
66 SET @@global.key_buffer_size = FALSE;
67 ERROR HY000: Cannot drop default keycache
68 '#---------------------FN_DYNVARS_055_08----------------------#'
69 SELECT @@key_buffer_size = @@global.key_buffer_size;
70 @@key_buffer_size = @@global.key_buffer_size
71 1
72 '#---------------------FN_DYNVARS_055_9----------------------#'
73 SET key_buffer_size = 8 ;
74 ERROR HY000: Variable 'key_buffer_size' is a GLOBAL variable and should be set with SET GLOBAL
75 SET local.key_buffer_size = 10;
76 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'local.key_buffer_size = 10' at line 1
77 SELECT local.key_buffer_size;
78 ERROR 42S02: Unknown table 'local' in field list
79 SET global.key_buffer_size = 10;
80 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'global.key_buffer_size = 10' at line 1
81 SELECT global.key_buffer_size;
82 ERROR 42S02: Unknown table 'global' in field list
83 SELECT key_buffer_size;
84 ERROR 42S22: Unknown column 'key_buffer_size' in 'field list'
85 SELECT @@session.key_buffer_size;
86 ERROR HY000: Variable 'key_buffer_size' is a GLOBAL variable
87 SET @@global.key_buffer_size = @start_value;