Debian Codegraph @

mysql-test/suite/storage_engine/handler.test

raw
1 #
2 # Basic HANDLER syntax
3 #
4 # HANDLER .. READ <index_name> is covered in handler_index test
5 #
6
7 --source have_engine.inc
8
9 --disable_warnings
10 DROP TABLE IF EXISTS t1;
11 --enable_warnings
12
13 --let $create_definition = a $char_col, b $int_col
14 --source create_table.inc
15 INSERT INTO t1 (a,b) VALUES ('foobar',1000),('a',1),('bar',200),('foo',100);
16
17 HANDLER t1 OPEN AS h1;
18 if ($mysql_errname)
19 {
20 --source unexpected_result.inc
21 }
22 if (!$mysql_errname)
23 {
24 --let $error_codes = ER_UNKNOWN_TABLE
25 HANDLER t1 READ FIRST;
26 --source check_errors.inc
27 HANDLER h1 READ FIRST;
28 HANDLER h1 READ NEXT;
29 HANDLER h1 READ FIRST WHERE a < 'foo';
30 HANDLER h1 READ NEXT;
31 HANDLER h1 READ NEXT;
32 HANDLER h1 READ NEXT;
33 HANDLER h1 READ FIRST LIMIT 2;
34 HANDLER h1 READ NEXT;
35 HANDLER h1 READ NEXT WHERE b>500 LIMIT 2;
36 HANDLER t1 OPEN;
37 HANDLER h1 READ FIRST WHERE b>500 LIMIT 5;
38 HANDLER t1 READ NEXT;
39 HANDLER h1 READ NEXT WHERE b<100;
40 HANDLER t1 CLOSE;
41 HANDLER h1 READ FIRST;
42 --let $error_codes = ER_UNKNOWN_TABLE
43 HANDLER t1 CLOSE;
44 --source check_errors.inc
45 }
46
47 DROP TABLE t1;
48
49 --let $error_codes = ER_UNKNOWN_TABLE
50 HANDLER h1 CLOSE;
51 --source check_errors.inc
52
53 --let $continue = 1
54 --source have_default_index.inc
55
56 if ($have_default_index)
57 {
58 --let $create_definition = a $int_indexed_col, b $char_col, $default_index (a)
59 --source create_table.inc
60 INSERT INTO t1 (b,a) VALUES ('a',1),('b',200),('f',100),('b',101),('c',2);
61 if ($mysql_errname)
62 {
63 --source unexpected_result.inc
64 }
65 HANDLER t1 OPEN AS h1;
66 if (!$mysql_errname)
67 {
68 HANDLER h1 READ a = (100);
69 HANDLER h1 READ a <= (100) WHERE b < 'f';
70 HANDLER h1 READ a > (2) WHERE b IS NOT NULL LIMIT 2;
71 HANDLER h1 READ a FIRST;
72 HANDLER h1 READ a LAST;
73 HANDLER h1 READ a PREV;
74 HANDLER h1 READ a NEXT;
75 HANDLER h1 CLOSE;
76 }
77 DROP TABLE t1;
78 }
79
80 --source cleanup_engine.inc
81