1
SET @start_global_value = @@global.myisam_data_pointer_size;
2
SELECT @start_global_value;
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
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
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
21
SET @@global.myisam_data_pointer_size = 3;
22
SELECT @@global.myisam_data_pointer_size;
23
@@global.myisam_data_pointer_size
25
SET @@global.myisam_data_pointer_size = 4;
26
SELECT @@global.myisam_data_pointer_size;
27
@@global.myisam_data_pointer_size
29
SET @@global.myisam_data_pointer_size = 5;
30
SELECT @@global.myisam_data_pointer_size;
31
@@global.myisam_data_pointer_size
33
SET @@global.myisam_data_pointer_size = 6;
34
SELECT @@global.myisam_data_pointer_size;
35
@@global.myisam_data_pointer_size
37
SET @@global.myisam_data_pointer_size = 7;
38
SELECT @@global.myisam_data_pointer_size;
39
@@global.myisam_data_pointer_size
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;
51
Warning 1292 Truncated incorrect myisam_data_pointer_size value: '0'
52
SELECT @@global.myisam_data_pointer_size;
53
@@global.myisam_data_pointer_size
55
SET @@global.myisam_data_pointer_size = 8;
57
Warning 1292 Truncated incorrect myisam_data_pointer_size value: '8'
58
SELECT @@global.myisam_data_pointer_size;
59
@@global.myisam_data_pointer_size
61
SET @@global.myisam_data_pointer_size = 1;
63
Warning 1292 Truncated incorrect myisam_data_pointer_size value: '1'
64
SELECT @@global.myisam_data_pointer_size;
65
@@global.myisam_data_pointer_size
67
SET @@global.myisam_data_pointer_size = 4294967296;
69
Warning 1292 Truncated incorrect myisam_data_pointer_size value: '4294967296'
70
SELECT @@global.myisam_data_pointer_size;
71
@@global.myisam_data_pointer_size
73
SET @@global.myisam_data_pointer_size = 65530.34.;
74
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 '.' at line 1
75
SELECT @@global.myisam_data_pointer_size;
76
@@global.myisam_data_pointer_size
78
SET @@global.myisam_data_pointer_size = two;
79
ERROR 42000: Incorrect argument type to variable 'myisam_data_pointer_size'
80
SELECT @@global.myisam_data_pointer_size;
81
@@global.myisam_data_pointer_size
83
'Bug # 34837: Errors are not coming on assigning invalid values to variable';
84
'#------------------FN_DYNVARS_093_06-----------------------#'
85
SET @@global.myisam_data_pointer_size = 3;
86
SELECT @@global.myisam_data_pointer_size = VARIABLE_VALUE
87
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
88
WHERE VARIABLE_NAME='myisam_data_pointer_size';
89
@@global.myisam_data_pointer_size = VARIABLE_VALUE
91
'#------------------FN_DYNVARS_093_07-----------------------#'
92
SELECT count(VARIABLE_VALUE)
93
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
94
WHERE VARIABLE_NAME='myisam_data_pointer_size';
97
'#------------------FN_DYNVARS_093_08-----------------------#'
98
SET @@global.myisam_data_pointer_size = TRUE;
100
Warning 1292 Truncated incorrect myisam_data_pointer_size value: '1'
101
SELECT @@global.myisam_data_pointer_size;
102
@@global.myisam_data_pointer_size
104
SET @@global.myisam_data_pointer_size = FALSE;
106
Warning 1292 Truncated incorrect myisam_data_pointer_size value: '0'
107
SELECT @@global.myisam_data_pointer_size;
108
@@global.myisam_data_pointer_size
110
'#---------------------FN_DYNVARS_001_09----------------------#'
111
SET @@global.myisam_data_pointer_size = 5;
112
SELECT @@myisam_data_pointer_size = @@global.myisam_data_pointer_size;
113
@@myisam_data_pointer_size = @@global.myisam_data_pointer_size
115
'#---------------------FN_DYNVARS_001_10----------------------#'
116
SET myisam_data_pointer_size = 7;
117
ERROR HY000: Variable 'myisam_data_pointer_size' is a GLOBAL variable and should be set with SET GLOBAL
118
SELECT myisam_data_pointer_size;
119
ERROR 42S22: Unknown column 'myisam_data_pointer_size' in 'field list'
120
SELECT @@myisam_data_pointer_size;
121
@@myisam_data_pointer_size
123
SET global myisam_data_pointer_size = 2;
124
SET @@global.myisam_data_pointer_size = @start_global_value;
125
SELECT @@global.myisam_data_pointer_size;
126
@@global.myisam_data_pointer_size