Debian Codegraph @

mysql-test/suite/handler/heap.test

raw
1 # test of HANDLER with HEAP tables
2 #
3
4 let $engine_type= MEMORY;
5
6 --source init.inc
7 --source handler.inc
8
9 #
10 # Test what happens if table is changed (Unique test for HEAP)
11 #
12
13 connect (con1,localhost,root,,);
14 connection default;
15
16 CREATE TABLE t1(a INT, b INT, KEY(a), KEY b using btree (b), KEY ab using btree(a, b)) engine=memory;
17
18 INSERT INTO t1 VALUES (2, 20), (2,20), (1, 10), (4, 40), (3, 30), (5,50), (6,50);
19
20 HANDLER t1 OPEN;
21 HANDLER t1 READ a=(2) limit 3;
22 HANDLER t1 READ a PREV;
23 HANDLER t1 READ a PREV;
24 HANDLER t1 READ a PREV;
25 HANDLER t1 READ b>=(20) limit 3;
26 HANDLER t1 READ b PREV;
27 HANDLER t1 READ b PREV LIMIT 2;
28 HANDLER t1 READ ab=(3,30) limit 3;
29 HANDLER t1 READ ab>=(3,30) limit 3;
30
31 # Test FIRST/LAST on hash and btree keys
32 --error ER_ILLEGAL_HA
33 HANDLER t1 READ a FIRST;
34 --error ER_ILLEGAL_HA
35 HANDLER t1 READ a LAST;
36 HANDLER t1 READ b FIRST LIMIT 2;
37 HANDLER t1 READ ab LAST LIMIT 2;
38
39 # Table scan
40 HANDLER t1 READ FIRST LIMIT 10;
41 # Index scan
42 HANDLER t1 READ b FIRST;
43 insert into t1 values (7,50);
44 --error ER_CHECKREAD
45 HANDLER t1 READ b NEXT;
46
47 HANDLER t1 READ b FIRST;
48 connection con1;
49 insert into t1 values (7,50);
50 connection default;
51 --error ER_CHECKREAD
52 HANDLER t1 READ b NEXT;
53
54 HANDLER t1 READ FIRST;
55 connection con1;
56 insert into t1 values (8,50);
57 connection default;
58 HANDLER t1 READ NEXT;
59 connection con1;
60 delete from t1 where a=3;
61 connection default;
62 HANDLER t1 READ NEXT LIMIT 2;
63 connection con1;
64 delete from t1;
65 connection default;
66 --error ER_CHECKREAD
67 HANDLER t1 READ NEXT LIMIT 2;
68 HANDLER t1 CLOSE;
69 DROP TABLE t1;
70 disconnect con1;
71
72 #
73 # LP#702786 Two handler read f1 next gives different errors
74 #
75 create table t1 (f1 integer not null, key (f1)) engine=Memory;
76 insert into t1 values (1);
77 HANDLER t1 OPEN;
78 --error 1031
79 HANDLER t1 READ f1 NEXT;
80 --error 1031
81 HANDLER t1 READ f1 NEXT;
82 --error 1031
83 HANDLER t1 READ f1 NEXT;
84 HANDLER t1 CLOSE;
85 DROP TABLE t1;
86
87 --echo End of 5.3 tests
88
89 --echo #
90 --echo # MDEV-15813 ASAN use-after-poison in hp_hashnr upon
91 --echo # HANDLER READ on a versioned HEAP table
92 --echo #
93
94 CREATE TABLE t1 (a INT NOT NULL, b INT NOT NULL, CONSTRAINT PRIMARY KEY (a, b), UNIQUE ba(b, a) USING HASH) ENGINE=HEAP;
95 INSERT INTO t1 VALUES (1, 10), (2, 20), (3,30), (4,40);
96 HANDLER t1 OPEN AS m;
97 HANDLER m READ `PRIMARY`= (3,30);
98 --error ER_KEY_DOESNT_SUPPORT
99 HANDLER m READ `PRIMARY`> (3,30);
100 HANDLER m READ `ba`= (30,3);
101 --error ER_KEY_DOESNT_SUPPORT
102 HANDLER m READ `ba`= (30);
103 HANDLER m CLOSE;
104 DROP TABLE t1;
105