Debian Codegraph @

mysql-test/suite/handler/aria.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_maria.inc
13 let $engine_type= Aria;
14
15 --source init.inc
16 --source handler.inc
17
18 --echo #
19 --echo # BUG #46456: HANDLER OPEN + TRUNCATE + DROP (temporary) TABLE, crash
20 --echo #
21 CREATE TABLE t1 AS SELECT 1 AS f1;
22 HANDLER t1 OPEN;
23 TRUNCATE t1;
24 --error ER_UNKNOWN_TABLE
25 HANDLER t1 READ FIRST;
26 DROP TABLE t1;
27
28 CREATE TEMPORARY TABLE t1 AS SELECT 1 AS f1;
29 HANDLER t1 OPEN;
30 TRUNCATE t1;
31 --error ER_UNKNOWN_TABLE
32 HANDLER t1 READ FIRST;
33 DROP TABLE t1;
34
35 --echo #
36 --echo # Bug #54007: assert in ha_myisam::index_next , HANDLER
37 --echo #
38 CREATE TABLE t1(a INT, b INT, PRIMARY KEY(a), KEY b(b), KEY ab(a, b));
39
40 HANDLER t1 OPEN;
41 HANDLER t1 READ FIRST;
42 HANDLER t1 READ `PRIMARY` NEXT;
43 HANDLER t1 READ ab NEXT;
44 HANDLER t1 READ b NEXT;
45 HANDLER t1 READ NEXT;
46 HANDLER t1 CLOSE;
47
48 INSERT INTO t1 VALUES (2, 20), (1, 10), (4, 40), (3, 30);
49 HANDLER t1 OPEN;
50 HANDLER t1 READ FIRST;
51 HANDLER t1 READ NEXT;
52 HANDLER t1 READ `PRIMARY` NEXT;
53 HANDLER t1 READ `PRIMARY` NEXT;
54 HANDLER t1 READ ab NEXT;
55 HANDLER t1 READ ab 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 b NEXT;
61 HANDLER t1 READ NEXT;
62 HANDLER t1 READ NEXT;
63 HANDLER t1 READ NEXT;
64 HANDLER t1 CLOSE;
65
66 HANDLER t1 OPEN;
67 HANDLER t1 READ FIRST;
68 HANDLER t1 READ `PRIMARY` PREV;
69 HANDLER t1 READ `PRIMARY` PREV;
70 HANDLER t1 READ b PREV;
71 HANDLER t1 READ b PREV;
72 HANDLER t1 CLOSE;
73
74 HANDLER t1 OPEN;
75 HANDLER t1 READ FIRST;
76 HANDLER t1 READ `PRIMARY` PREV LIMIT 3;
77 HANDLER t1 READ b NEXT LIMIT 5;
78 HANDLER t1 CLOSE;
79
80 DROP TABLE t1;
81
82 --echo End of 5.1 tests
83
84 --echo #
85 --echo # 10.2 Test
86 --echo #
87 --echo # MDEV-20207: Assertion `! is_set()' failed in
88 --echo # Diagnostics_area::set_eof_status upon HANDLER READ
89 --echo #
90
91 DROP TABLE IF EXISTS t1;
92
93 CREATE TABLE t1 (a POINT, KEY(a));
94 HANDLER t1 OPEN h;
95
96 --error ER_CANT_CREATE_GEOMETRY_OBJECT
97 HANDLER h READ a = (0);
98
99 HANDLER h CLOSE;
100 DROP TABLE t1;
101
102 --echo # End of 10.2 Test