Debian Codegraph @

mysql-test/suite/storage_engine/handler.result

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1 (a <CHAR_COLUMN>, b <INT_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
3 INSERT INTO t1 (a,b) VALUES ('foobar',1000),('a',1),('bar',200),('foo',100);
4 HANDLER t1 OPEN AS h1;
5 HANDLER t1 READ FIRST;
6 ERROR 42S02: Unknown table 't1' in HANDLER
7 HANDLER h1 READ FIRST;
8 a b
9 foobar 1000
10 HANDLER h1 READ NEXT;
11 a b
12 a 1
13 HANDLER h1 READ FIRST WHERE a < 'foo';
14 a b
15 a 1
16 HANDLER h1 READ NEXT;
17 a b
18 bar 200
19 HANDLER h1 READ NEXT;
20 a b
21 foo 100
22 HANDLER h1 READ NEXT;
23 a b
24 HANDLER h1 READ FIRST LIMIT 2;
25 a b
26 foobar 1000
27 a 1
28 HANDLER h1 READ NEXT;
29 a b
30 bar 200
31 HANDLER h1 READ NEXT WHERE b>500 LIMIT 2;
32 a b
33 HANDLER t1 OPEN;
34 HANDLER h1 READ FIRST WHERE b>500 LIMIT 5;
35 a b
36 foobar 1000
37 HANDLER t1 READ NEXT;
38 a b
39 foobar 1000
40 HANDLER h1 READ NEXT WHERE b<100;
41 a b
42 HANDLER t1 CLOSE;
43 HANDLER h1 READ FIRST;
44 a b
45 foobar 1000
46 HANDLER t1 CLOSE;
47 ERROR 42S02: Unknown table 't1' in HANDLER
48 DROP TABLE t1;
49 HANDLER h1 CLOSE;
50 ERROR 42S02: Unknown table 'h1' in HANDLER
51 CREATE TABLE t1 (a <INT_COLUMN>, b <CHAR_COLUMN>, <CUSTOM_INDEX> (a)) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
52 INSERT INTO t1 (b,a) VALUES ('a',1),('b',200),('f',100),('b',101),('c',2);
53 HANDLER t1 OPEN AS h1;
54 HANDLER h1 READ a = (100);
55 a b
56 100 f
57 HANDLER h1 READ a <= (100) WHERE b < 'f';
58 a b
59 2 c
60 HANDLER h1 READ a > (2) WHERE b IS NOT NULL LIMIT 2;
61 a b
62 100 f
63 101 b
64 HANDLER h1 READ a FIRST;
65 a b
66 1 a
67 HANDLER h1 READ a LAST;
68 a b
69 200 b
70 HANDLER h1 READ a PREV;
71 a b
72 101 b
73 HANDLER h1 READ a NEXT;
74 a b
75 200 b
76 HANDLER h1 CLOSE;
77 DROP TABLE t1;