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 = 65530.34;
74 ERROR 42000: Incorrect argument type to variable 'myisam_data_pointer_size'
75 SELECT @@global.myisam_data_pointer_size;
76 @@global.myisam_data_pointer_size
77 7
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
82 7
83 '#------------------FN_DYNVARS_093_06-----------------------#'
84 SET @@global.myisam_data_pointer_size = 3;
85 SELECT @@global.myisam_data_pointer_size = VARIABLE_VALUE
86 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
87 WHERE VARIABLE_NAME='myisam_data_pointer_size';
88 @@global.myisam_data_pointer_size = VARIABLE_VALUE
89 1
90 '#------------------FN_DYNVARS_093_07-----------------------#'
91 SELECT count(VARIABLE_VALUE)
92 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
93 WHERE VARIABLE_NAME='myisam_data_pointer_size';
94 count(VARIABLE_VALUE)
95 1
96 '#------------------FN_DYNVARS_093_08-----------------------#'
97 SET @@global.myisam_data_pointer_size = TRUE;
98 Warnings:
99 Warning 1292 Truncated incorrect myisam_data_pointer_size value: '1'
100 SELECT @@global.myisam_data_pointer_size;
101 @@global.myisam_data_pointer_size
102 2
103 SET @@global.myisam_data_pointer_size = FALSE;
104 Warnings:
105 Warning 1292 Truncated incorrect myisam_data_pointer_size value: '0'
106 SELECT @@global.myisam_data_pointer_size;
107 @@global.myisam_data_pointer_size
108 2
109 '#---------------------FN_DYNVARS_001_09----------------------#'
110 SET @@global.myisam_data_pointer_size = 5;
111 SELECT @@myisam_data_pointer_size = @@global.myisam_data_pointer_size;
112 @@myisam_data_pointer_size = @@global.myisam_data_pointer_size
113 1
114 '#---------------------FN_DYNVARS_001_10----------------------#'
115 SET myisam_data_pointer_size = 7;
116 ERROR HY000: Variable 'myisam_data_pointer_size' is a GLOBAL variable and should be set with SET GLOBAL
117 SELECT myisam_data_pointer_size;
118 ERROR 42S22: Unknown column 'myisam_data_pointer_size' in 'SELECT'
119 SELECT @@myisam_data_pointer_size;
120 @@myisam_data_pointer_size
121 5
122 SET global myisam_data_pointer_size = 2;
123 SET @@global.myisam_data_pointer_size = @start_global_value;
124 SELECT @@global.myisam_data_pointer_size;
125 @@global.myisam_data_pointer_size
126 6