1# t/handler_innodb.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/innodb_handler.test to t/handler_innodb.test 10# 11 12--source include/have_innodb.inc 13 14let $engine_type= InnoDB; 15 16--source init.inc 17--source handler.inc 18 19# 20# LP#697610 ha_index_prev(uchar*): Assertion `inited==INDEX' 21# 22 23CREATE TABLE t1 (f1 integer, f2 integer, primary key (f1), key (f2)) engine=innodb; 24INSERT INTO t1 VALUES (1,1),(2,2),(3,3); 25HANDLER t1 OPEN; 26HANDLER t1 READ FIRST WHERE f2 <= 1; 27HANDLER t1 READ `PRIMARY` PREV; 28DROP TABLE t1; 29