From a175314c3e5827eb193872241446f2f8f5c9d33c Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 20:07:14 +0200 Subject: Adding upstream version 1:10.5.12. Signed-off-by: Daniel Baumann --- mysql-test/suite/maria/maria_partition.result | 50 +++++++++++++++++++++++++++ 1 file changed, 50 insertions(+) create mode 100644 mysql-test/suite/maria/maria_partition.result (limited to 'mysql-test/suite/maria/maria_partition.result') diff --git a/mysql-test/suite/maria/maria_partition.result b/mysql-test/suite/maria/maria_partition.result new file mode 100644 index 00000000..f544ddd4 --- /dev/null +++ b/mysql-test/suite/maria/maria_partition.result @@ -0,0 +1,50 @@ +set global default_storage_engine=aria; +set session default_storage_engine=aria; +set global aria_page_checksum=0; +drop table if exists t1,t2; +drop view if exists v1; +SET SQL_WARNINGS=1; +create table t1 (s1 int); +insert into t1 values (1); +alter table t1 partition by list (s1) (partition p1 values in (2)); +ERROR HY000: Table has no partition for value 1 +drop table t1; +create table t2(a blob) engine=aria; +create table t1(a int primary key) engine=aria; +insert into t2 values ('foo'),('bar'); +select * from t2 left join t1 on (t2.a=t1.a) where t2.a='bbb'; +a a +insert into t1 values (1); +select * from t2 left join t1 on (t2.a=t1.a) where t2.a='bbb'; +a a +insert into t1 values (2); +select * from t2 left join t1 on (t2.a=t1.a) where t2.a='bbb'; +a a +drop table t1,t2; +create table t2(a blob); +create table t1(a int primary key) PARTITION BY HASH (a) PARTITIONS 2; +insert into t2 values ('foo'),('bar'); +select * from t2 left join t1 on (t2.a=t1.a) where t2.a='bbb'; +a a +insert into t1 values (1); +select * from t2 left join t1 on (t2.a=t1.a) where t2.a='bbb'; +a a +insert into t1 values (2); +select * from t2 left join t1 on (t2.a=t1.a) where t2.a='bbb'; +a a +drop table t1,t2; +CREATE TABLE t1 (pk INT PRIMARY KEY) ENGINE=Aria PARTITION BY KEY() PARTITIONS 2; +CREATE VIEW v1 AS SELECT * FROM t1; +LOCK TABLE v1 WRITE; +CREATE TABLE v1 (i INT); +ERROR HY000: Table 'v1' was not locked with LOCK TABLES +INSERT INTO v1 VALUES (1); +UNLOCK TABLES; +check table t1; +Table Op Msg_type Msg_text +test.t1 check status OK +SELECT * FROM t1; +pk +1 +drop table t1; +drop view v1; -- cgit v1.2.3