Debian Codegraph @

mysql-test/suite/maria/maria_partition.result

raw
1 set global default_storage_engine=aria;
2 set session default_storage_engine=aria;
3 set global aria_page_checksum=0;
4 drop table if exists t1,t2;
5 drop view if exists v1;
6 SET SQL_WARNINGS=1;
7 create table t1 (s1 int);
8 insert into t1 values (1);
9 alter table t1 partition by list (s1) (partition p1 values in (2));
10 ERROR HY000: Table has no partition for value 1
11 drop table t1;
12 create table t2(a blob) engine=aria;
13 create table t1(a int primary key) engine=aria;
14 insert into t2 values ('foo'),('bar');
15 select * from t2 left join t1 on (t2.a=t1.a) where t2.a='bbb';
16 a a
17 insert into t1 values (1);
18 select * from t2 left join t1 on (t2.a=t1.a) where t2.a='bbb';
19 a a
20 insert into t1 values (2);
21 select * from t2 left join t1 on (t2.a=t1.a) where t2.a='bbb';
22 a a
23 drop table t1,t2;
24 create table t2(a blob);
25 create table t1(a int primary key) PARTITION BY HASH (a) PARTITIONS 2;
26 insert into t2 values ('foo'),('bar');
27 select * from t2 left join t1 on (t2.a=t1.a) where t2.a='bbb';
28 a a
29 insert into t1 values (1);
30 select * from t2 left join t1 on (t2.a=t1.a) where t2.a='bbb';
31 a a
32 insert into t1 values (2);
33 select * from t2 left join t1 on (t2.a=t1.a) where t2.a='bbb';
34 a a
35 drop table t1,t2;
36 CREATE TABLE t1 (pk INT PRIMARY KEY) ENGINE=Aria PARTITION BY KEY() PARTITIONS 2;
37 CREATE VIEW v1 AS SELECT * FROM t1;
38 LOCK TABLE v1 WRITE;
39 CREATE TABLE v1 (i INT);
40 ERROR HY000: Table 'v1' was not locked with LOCK TABLES
41 INSERT INTO v1 VALUES (1);
42 UNLOCK TABLES;
43 check table t1;
44 Table Op Msg_type Msg_text
45 test.t1 check status OK
46 SELECT * FROM t1;
47 pk
48 1
49 drop table t1;
50 drop view v1;