Debian Codegraph @

mysql-test/suite/handler/innodb.test

raw
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
14 let $engine_type= InnoDB;
15
16 --source init.inc
17 --source handler.inc
18 --source savepoint.inc
19
20 #
21 # LP#697610 ha_index_prev(uchar*): Assertion `inited==INDEX'
22 #
23
24 CREATE TABLE t1 (f1 integer, f2 integer, primary key (f1), key (f2)) engine=innodb;
25 INSERT INTO t1 VALUES (1,1),(2,2),(3,3);
26 HANDLER t1 OPEN;
27 HANDLER t1 READ FIRST WHERE f2 <= 1;
28 HANDLER t1 READ `PRIMARY` PREV;
29 DROP TABLE t1;
30
31 --echo #
32 --echo # 10.2 Test
33 --echo #
34 --echo # MDEV-20207: Assertion `! is_set()' failed in
35 --echo # Diagnostics_area::set_eof_status upon HANDLER READ
36 --echo #
37
38 DROP TABLE IF EXISTS t1;
39
40 CREATE TABLE t1 (a POINT, KEY(a));
41 HANDLER t1 OPEN h;
42
43 --error ER_CANT_CREATE_GEOMETRY_OBJECT
44 HANDLER h READ a = (0);
45
46 HANDLER h CLOSE;
47 DROP TABLE t1;
48
49 --echo # End of 10.2 Test