Debian Codegraph @

mysql-test/suite/handler/myisam.test

raw
1 # t/handler_myisam.test
2 #
3 # test of HANDLER ...
4 #
5 # Last update:
6 # 2006-07-31 ML test refactored (MySQL 5.1)
7 # code of t/handler.test and t/innodb_handler.test united
8 # main testing code put into handler.inc
9 # rename t/handler.test to t/handler_myisam.test
10 #
11
12 let $engine_type= MyISAM;
13
14 --source init.inc
15 --source handler.inc
16
17 --echo #
18 --echo # BUG #46456: HANDLER OPEN + TRUNCATE + DROP (temporary) TABLE, crash
19 --echo #
20 CREATE TABLE t1 AS SELECT 1 AS f1;
21 HANDLER t1 OPEN;
22 TRUNCATE t1;
23 --error ER_UNKNOWN_TABLE
24 HANDLER t1 READ FIRST;
25 DROP TABLE t1;
26
27 CREATE TEMPORARY TABLE t1 AS SELECT 1 AS f1;
28 HANDLER t1 OPEN;
29 TRUNCATE t1;
30 --error ER_UNKNOWN_TABLE
31 HANDLER t1 READ FIRST;
32 DROP TABLE t1;
33
34 --echo #
35 --echo # Bug #54007: assert in ha_myisam::index_next , HANDLER
36 --echo #
37 CREATE TABLE t1(a INT, b INT, PRIMARY KEY(a), KEY b(b), KEY ab(a, b));
38
39 HANDLER t1 OPEN;
40 HANDLER t1 READ FIRST;
41 HANDLER t1 READ `PRIMARY` NEXT;
42 HANDLER t1 READ ab NEXT;
43 HANDLER t1 READ b NEXT;
44 HANDLER t1 READ NEXT;
45 HANDLER t1 CLOSE;
46
47 INSERT INTO t1 VALUES (2, 20), (1, 10), (4, 40), (3, 30);
48 HANDLER t1 OPEN;
49 HANDLER t1 READ FIRST;
50 HANDLER t1 READ NEXT;
51 HANDLER t1 READ `PRIMARY` NEXT;
52 HANDLER t1 READ `PRIMARY` NEXT;
53 HANDLER t1 READ ab NEXT;
54 HANDLER t1 READ ab NEXT;
55 HANDLER t1 READ b NEXT;
56 HANDLER t1 READ b NEXT;
57 HANDLER t1 READ b NEXT;
58 HANDLER t1 READ b NEXT;
59 HANDLER t1 READ b NEXT;
60 HANDLER t1 READ NEXT;
61 HANDLER t1 READ NEXT;
62 HANDLER t1 READ NEXT;
63 HANDLER t1 CLOSE;
64
65 HANDLER t1 OPEN;
66 HANDLER t1 READ FIRST;
67 HANDLER t1 READ `PRIMARY` PREV;
68 HANDLER t1 READ `PRIMARY` PREV;
69 HANDLER t1 READ b PREV;
70 HANDLER t1 READ b PREV;
71 HANDLER t1 CLOSE;
72
73 HANDLER t1 OPEN;
74 HANDLER t1 READ FIRST;
75 HANDLER t1 READ `PRIMARY` PREV LIMIT 3;
76 HANDLER t1 READ b NEXT LIMIT 5;
77 HANDLER t1 CLOSE;
78
79 DROP TABLE t1;
80
81
82 --echo #
83 --echo # Additional coverage for refactoring which is made as part
84 --echo # of fix for bug #27480 "Extend CREATE TEMPORARY TABLES privilege
85 --echo # to allow temp table operations".
86 --echo #
87 --echo # Check that DDL on temporary table properly closes HANDLER cursors
88 --echo # for this table belonging to the same connection.
89
90 CREATE TEMPORARY TABLE t1 AS SELECT 1 AS f1;
91
92 --echo # -- CREATE TABLE
93 HANDLER t1 OPEN;
94 CREATE TEMPORARY TABLE IF NOT EXISTS t1 SELECT 1 AS f1;
95 --error ER_UNKNOWN_TABLE
96 HANDLER t1 READ FIRST;
97
98 --echo # -- REPAIR TABLE
99 HANDLER t1 OPEN;
100 REPAIR TABLE t1;
101 --error ER_UNKNOWN_TABLE
102 HANDLER t1 READ FIRST;
103
104 --echo # -- ANALYZE TABLE
105 HANDLER t1 OPEN;
106 ANALYZE TABLE t1;
107 --error ER_UNKNOWN_TABLE
108 HANDLER t1 READ FIRST;
109
110 --echo # -- OPTIMIZE TABLE
111 HANDLER t1 OPEN;
112 OPTIMIZE TABLE t1;
113 --error ER_UNKNOWN_TABLE
114 HANDLER t1 READ FIRST;
115
116 --echo # -- CHECK TABLE
117 HANDLER t1 OPEN;
118 CHECK TABLE t1;
119 --error ER_UNKNOWN_TABLE
120 HANDLER t1 READ FIRST;
121
122 --echo # -- ALTER TABLE
123 HANDLER t1 OPEN;
124 ALTER TABLE t1 ADD COLUMN b INT;
125 --error ER_UNKNOWN_TABLE
126 HANDLER t1 READ FIRST;
127
128 --echo # -- CREATE INDEX
129 HANDLER t1 OPEN;
130 CREATE INDEX b ON t1 (b);
131 --error ER_UNKNOWN_TABLE
132 HANDLER t1 READ FIRST;
133
134 --echo # -- DROP INDEX
135 HANDLER t1 OPEN;
136 DROP INDEX b ON t1;
137 --error ER_UNKNOWN_TABLE
138 HANDLER t1 READ FIRST;
139
140 --echo # -- TRUNCATE TABLE
141 HANDLER t1 OPEN;
142 TRUNCATE TABLE t1;
143 --error ER_UNKNOWN_TABLE
144 HANDLER t1 READ FIRST;
145
146 --echo # -- DROP TABLE
147 HANDLER t1 OPEN;
148 DROP TABLE t1;
149 --error ER_UNKNOWN_TABLE
150 HANDLER t1 READ FIRST;
151
152 CREATE TEMPORARY TABLE t1(a INT, b INT, INDEX i(a));
153
154 set global keycache1.key_cache_block_size=2048;
155 set global keycache1.key_buffer_size=1*1024*1024;
156 set global keycache1.key_buffer_size=1024*1024;
157
158 --echo # -- CACHE INDEX
159 HANDLER t1 OPEN;
160 CACHE INDEX t1 IN keycache1;
161 --error ER_UNKNOWN_TABLE
162 HANDLER t1 READ FIRST;
163
164 --echo # -- LOAD INDEX
165 HANDLER t1 OPEN;
166 LOAD INDEX INTO CACHE t1;
167 --error ER_UNKNOWN_TABLE
168 HANDLER t1 READ FIRST;
169
170
171 --echo End of 5.1 tests
172
173 --echo #
174 --echo # 10.2 Test
175 --echo #
176 --echo # MDEV-20207: Assertion `! is_set()' failed in
177 --echo # Diagnostics_area::set_eof_status upon HANDLER READ
178 --echo #
179
180 DROP TABLE IF EXISTS t1;
181
182 CREATE TABLE t1 (a POINT, KEY(a));
183 HANDLER t1 OPEN h;
184
185 --error ER_CANT_CREATE_GEOMETRY_OBJECT
186 HANDLER h READ a = (0);
187
188 HANDLER h CLOSE;
189 DROP TABLE t1;
190
191 --echo # End of 10.2 Test