summaryrefslogtreecommitdiff
path: root/mysql-test/t/handler_myisam.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/t/handler_myisam.test')
-rw-r--r--mysql-test/t/handler_myisam.test100
1 files changed, 0 insertions, 100 deletions
diff --git a/mysql-test/t/handler_myisam.test b/mysql-test/t/handler_myisam.test
deleted file mode 100644
index e78072ef8a0..00000000000
--- a/mysql-test/t/handler_myisam.test
+++ /dev/null
@@ -1,100 +0,0 @@
-# t/handler_myisam.test
-#
-# test of HANDLER ...
-#
-# Last update:
-# 2006-07-31 ML test refactored (MySQL 5.1)
-# code of t/handler.test and t/innodb_handler.test united
-# main testing code put into include/handler.inc
-# rename t/handler.test to t/handler_myisam.test
-#
-
-# should work in embedded server after mysqltest is fixed
---source include/not_embedded.inc
-
-let $engine_type= MyISAM;
-let $other_engine_type= MEMORY;
-# There is unfortunately no other all time available storage engine
-# which supports the handler interface
-let $other_handler_engine_type= MyISAM;
-
---source include/handler.inc
-
---echo #
---echo # BUG #46456: HANDLER OPEN + TRUNCATE + DROP (temporary) TABLE, crash
---echo #
-CREATE TABLE t1 AS SELECT 1 AS f1;
-HANDLER t1 OPEN;
-TRUNCATE t1;
---error ER_UNKNOWN_TABLE
-HANDLER t1 READ FIRST;
-DROP TABLE t1;
-
-CREATE TEMPORARY TABLE t1 AS SELECT 1 AS f1;
-HANDLER t1 OPEN;
-TRUNCATE t1;
---error ER_UNKNOWN_TABLE
-HANDLER t1 READ FIRST;
-DROP TABLE t1;
-
---echo #
---echo # BUG#51877 - HANDLER interface causes invalid memory read
---echo #
-CREATE TABLE t1(a INT, KEY(a));
-HANDLER t1 OPEN;
-HANDLER t1 READ a FIRST;
-INSERT INTO t1 VALUES(1);
-HANDLER t1 READ a NEXT;
-HANDLER t1 CLOSE;
-DROP TABLE t1;
-
-
---echo #
---echo # Bug #54007: assert in ha_myisam::index_next , HANDLER
---echo #
-CREATE TABLE t1(a INT, b INT, PRIMARY KEY(a), KEY b(b), KEY ab(a, b));
-
-HANDLER t1 OPEN;
-HANDLER t1 READ FIRST;
-HANDLER t1 READ `PRIMARY` NEXT;
-HANDLER t1 READ ab NEXT;
-HANDLER t1 READ b NEXT;
-HANDLER t1 READ NEXT;
-HANDLER t1 CLOSE;
-
-INSERT INTO t1 VALUES (2, 20), (1, 10), (4, 40), (3, 30);
-HANDLER t1 OPEN;
-HANDLER t1 READ FIRST;
-HANDLER t1 READ NEXT;
-HANDLER t1 READ `PRIMARY` NEXT;
-HANDLER t1 READ `PRIMARY` NEXT;
-HANDLER t1 READ ab NEXT;
-HANDLER t1 READ ab NEXT;
-HANDLER t1 READ b NEXT;
-HANDLER t1 READ b NEXT;
-HANDLER t1 READ b NEXT;
-HANDLER t1 READ b NEXT;
-HANDLER t1 READ b NEXT;
-HANDLER t1 READ NEXT;
-HANDLER t1 READ NEXT;
-HANDLER t1 READ NEXT;
-HANDLER t1 CLOSE;
-
-HANDLER t1 OPEN;
-HANDLER t1 READ FIRST;
-HANDLER t1 READ `PRIMARY` PREV;
-HANDLER t1 READ `PRIMARY` PREV;
-HANDLER t1 READ b PREV;
-HANDLER t1 READ b PREV;
-HANDLER t1 CLOSE;
-
-HANDLER t1 OPEN;
-HANDLER t1 READ FIRST;
-HANDLER t1 READ `PRIMARY` PREV LIMIT 3;
-HANDLER t1 READ b NEXT LIMIT 5;
-HANDLER t1 CLOSE;
-
-DROP TABLE t1;
-
-
---echo End of 5.1 tests