1 # t/handler_myisam.test
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 include/handler.inc
9 # rename t/handler.test to t/handler_myisam.test
12 # should work in embedded server after mysqltest is fixed
13 --source include/not_embedded.inc
15 let $engine_type= MyISAM;
16 let $other_engine_type= MEMORY;
17 # There is unfortunately no other all time available storage engine
18 # which supports the handler interface
19 let $other_handler_engine_type= MyISAM;
21 --source include/handler.inc
24 --echo # BUG #46456: HANDLER OPEN + TRUNCATE + DROP (temporary) TABLE, crash
26 CREATE TABLE t1 AS SELECT 1 AS f1;
29 --error ER_UNKNOWN_TABLE
30 HANDLER t1 READ FIRST;
33 CREATE TEMPORARY TABLE t1 AS SELECT 1 AS f1;
36 --error ER_UNKNOWN_TABLE
37 HANDLER t1 READ FIRST;
41 --echo # BUG#51877 - HANDLER interface causes invalid memory read
43 CREATE TABLE t1(a INT, KEY(a));
45 HANDLER t1 READ a FIRST;
46 INSERT INTO t1 VALUES(1);
47 HANDLER t1 READ a NEXT;
53 --echo # Bug #54007: assert in ha_myisam::index_next , HANDLER
55 CREATE TABLE t1(a INT, b INT, PRIMARY KEY(a), KEY b(b), KEY ab(a, b));
58 HANDLER t1 READ FIRST;
59 HANDLER t1 READ `PRIMARY` NEXT;
60 HANDLER t1 READ ab NEXT;
61 HANDLER t1 READ b NEXT;
65 INSERT INTO t1 VALUES (2, 20), (1, 10), (4, 40), (3, 30);
67 HANDLER t1 READ FIRST;
69 HANDLER t1 READ `PRIMARY` NEXT;
70 HANDLER t1 READ `PRIMARY` NEXT;
71 HANDLER t1 READ ab NEXT;
72 HANDLER t1 READ ab NEXT;
73 HANDLER t1 READ b NEXT;
74 HANDLER t1 READ b NEXT;
75 HANDLER t1 READ b NEXT;
76 HANDLER t1 READ b NEXT;
77 HANDLER t1 READ b NEXT;
84 HANDLER t1 READ FIRST;
85 HANDLER t1 READ `PRIMARY` PREV;
86 HANDLER t1 READ `PRIMARY` PREV;
87 HANDLER t1 READ b PREV;
88 HANDLER t1 READ b PREV;
92 HANDLER t1 READ FIRST;
93 HANDLER t1 READ `PRIMARY` PREV LIMIT 3;
94 HANDLER t1 READ b NEXT LIMIT 5;
100 --echo End of 5.1 tests