Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.myisam_data_pointer_size;
2 SELECT @start_global_value;
3 @start_global_value
4 6
5 '#--------------------FN_DYNVARS_093_01-------------------------#'
6 SET @@global.myisam_data_pointer_size = 5;
7 SET @@global.myisam_data_pointer_size = DEFAULT;
8 SELECT @@global.myisam_data_pointer_size;
9 @@global.myisam_data_pointer_size
10 6
11 '#--------------------FN_DYNVARS_093_02-------------------------#'
12 SET @@global.myisam_data_pointer_size = DEFAULT;
13 SELECT @@global.myisam_data_pointer_size = 6;
14 @@global.myisam_data_pointer_size = 6
15 1
16 '#--------------------FN_DYNVARS_093_03-------------------------#'
17 SET @@global.myisam_data_pointer_size = 2;
18 SELECT @@global.myisam_data_pointer_size;
19 @@global.myisam_data_pointer_size
20 2
21 SET @@global.myisam_data_pointer_size = 3;
22 SELECT @@global.myisam_data_pointer_size;
23 @@global.myisam_data_pointer_size
24 3
25 SET @@global.myisam_data_pointer_size = 4;
26 SELECT @@global.myisam_data_pointer_size;
27 @@global.myisam_data_pointer_size
28 4
29 SET @@global.myisam_data_pointer_size = 5;
30 SELECT @@global.myisam_data_pointer_size;
31 @@global.myisam_data_pointer_size
32 5
33 SET @@global.myisam_data_pointer_size = 6;
34 SELECT @@global.myisam_data_pointer_size;
35 @@global.myisam_data_pointer_size
36 6
37 SET @@global.myisam_data_pointer_size = 7;
38 SELECT @@global.myisam_data_pointer_size;
39 @@global.myisam_data_pointer_size
40 7
41 '#--------------------FN_DYNVARS_093_04-------------------------#'
42 SET @@myisam_data_pointer_size = 2;
43 ERROR HY000: Variable 'myisam_data_pointer_size' is a GLOBAL variable and should be set with SET GLOBAL
44 SET @@session.myisam_data_pointer_size = 3;
45 ERROR HY000: Variable 'myisam_data_pointer_size' is a GLOBAL variable and should be set with SET GLOBAL
46 SET @@local.myisam_data_pointer_size = 4;
47 ERROR HY000: Variable 'myisam_data_pointer_size' is a GLOBAL variable and should be set with SET GLOBAL
48 '#------------------FN_DYNVARS_093_05-----------------------#'
49 SET @@global.myisam_data_pointer_size = -1;
50 Warnings:
51 Warning 1292 Truncated incorrect myisam_data_pointer_size value: '-1'
52 SELECT @@global.myisam_data_pointer_size;
53 @@global.myisam_data_pointer_size
54 2
55 SET @@global.myisam_data_pointer_size = 8;
56 Warnings:
57 Warning 1292 Truncated incorrect myisam_data_pointer_size value: '8'
58 SELECT @@global.myisam_data_pointer_size;
59 @@global.myisam_data_pointer_size
60 7
61 SET @@global.myisam_data_pointer_size = 1;
62 Warnings:
63 Warning 1292 Truncated incorrect myisam_data_pointer_size value: '1'
64 SELECT @@global.myisam_data_pointer_size;
65 @@global.myisam_data_pointer_size
66 2
67 SET @@global.myisam_data_pointer_size = 4294967296;
68 Warnings:
69 Warning 1292 Truncated incorrect myisam_data_pointer_size value: '4294967296'
70 SELECT @@global.myisam_data_pointer_size;
71 @@global.myisam_data_pointer_size
72 7
73 SET @@global.myisam_data_pointer_size = -1024;
74 Warnings:
75 Warning 1292 Truncated incorrect myisam_data_pointer_size value: '-1024'
76 SELECT @@global.myisam_data_pointer_size;
77 @@global.myisam_data_pointer_size
78 2
79 SET @@global.myisam_data_pointer_size = 65530.34;
80 ERROR 42000: Incorrect argument type to variable 'myisam_data_pointer_size'
81 SELECT @@global.myisam_data_pointer_size;
82 @@global.myisam_data_pointer_size
83 2
84 SET @@global.myisam_data_pointer_size = two;
85 ERROR 42000: Incorrect argument type to variable 'myisam_data_pointer_size'
86 SELECT @@global.myisam_data_pointer_size;
87 @@global.myisam_data_pointer_size
88 2
89 SET @@global.myisam_data_pointer_size = ' ';
90 ERROR 42000: Incorrect argument type to variable 'myisam_data_pointer_size'
91 SELECT @@global.myisam_data_pointer_size;
92 @@global.myisam_data_pointer_size
93 2
94 '#------------------FN_DYNVARS_093_06-----------------------#'
95 SET @@global.myisam_data_pointer_size = 3;
96 SELECT @@global.myisam_data_pointer_size = VARIABLE_VALUE
97 FROM performance_schema.global_variables
98 WHERE VARIABLE_NAME='myisam_data_pointer_size';
99 @@global.myisam_data_pointer_size = VARIABLE_VALUE
100 1
101 '#------------------FN_DYNVARS_093_07-----------------------#'
102 SELECT count(VARIABLE_VALUE)
103 FROM performance_schema.session_variables
104 WHERE VARIABLE_NAME='myisam_data_pointer_size';
105 count(VARIABLE_VALUE)
106 1
107 '#------------------FN_DYNVARS_093_08-----------------------#'
108 SET @@global.myisam_data_pointer_size = TRUE;
109 Warnings:
110 Warning 1292 Truncated incorrect myisam_data_pointer_size value: '1'
111 SELECT @@global.myisam_data_pointer_size;
112 @@global.myisam_data_pointer_size
113 2
114 SET @@global.myisam_data_pointer_size = FALSE;
115 Warnings:
116 Warning 1292 Truncated incorrect myisam_data_pointer_size value: '0'
117 SELECT @@global.myisam_data_pointer_size;
118 @@global.myisam_data_pointer_size
119 2
120 '#---------------------FN_DYNVARS_001_09----------------------#'
121 SET @@global.myisam_data_pointer_size = 5;
122 SELECT @@myisam_data_pointer_size = @@global.myisam_data_pointer_size;
123 @@myisam_data_pointer_size = @@global.myisam_data_pointer_size
124 1
125 '#---------------------FN_DYNVARS_001_10----------------------#'
126 SET myisam_data_pointer_size = 7;
127 ERROR HY000: Variable 'myisam_data_pointer_size' is a GLOBAL variable and should be set with SET GLOBAL
128 SELECT myisam_data_pointer_size;
129 ERROR 42S22: Unknown column 'myisam_data_pointer_size' in 'field list'
130 SELECT @@myisam_data_pointer_size;
131 @@myisam_data_pointer_size
132 5
133 SET global myisam_data_pointer_size = 2;
134 SET @@global.myisam_data_pointer_size = @start_global_value;
135 SELECT @@global.myisam_data_pointer_size;
136 @@global.myisam_data_pointer_size
137 6