diff options
| author | Oleksandr Byelkin <sanja@mariadb.com> | 2023-05-05 10:50:02 +0200 |
|---|---|---|
| committer | Oleksandr Byelkin <sanja@mariadb.com> | 2023-05-05 10:50:02 +0200 |
| commit | b735ca47738a1d2e995a429f40afd620eb7d8843 (patch) | |
| tree | e14dcdd3a8b7597477aed7a6b541396d84683d00 /mysql-test/main/derived_split_innodb.test | |
| parent | ba0433dc1ccbbf2a92ac40fc3e34339a822938f2 (diff) | |
| parent | 2594da7a33580bf03590502a011679c878487d0c (diff) | |
| download | mariadb-git-mariadb-10.5.20.tar.gz | |
Merge branch '10.4' into 10.5mariadb-10.5.20bb-10.5-release
Diffstat (limited to 'mysql-test/main/derived_split_innodb.test')
| -rw-r--r-- | mysql-test/main/derived_split_innodb.test | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/mysql-test/main/derived_split_innodb.test b/mysql-test/main/derived_split_innodb.test index 0e847e47131..a0ed51d1dd4 100644 --- a/mysql-test/main/derived_split_innodb.test +++ b/mysql-test/main/derived_split_innodb.test @@ -441,4 +441,27 @@ eval $q; drop table t1,t2,t3; drop table t10, t11; + +--echo # +--echo # MDEV-31194: Server crash or assertion failure with join_cache_level=4 +--echo # (a followup to the above bug, MDEV-26301) +--echo # +CREATE TABLE t1 (a INT); +INSERT INTO t1 VALUES (3),(4); + +CREATE TABLE t2 (id INT PRIMARY KEY) ENGINE=Aria; +INSERT INTO t2 VALUES (1),(2); + +set @tmp1= @@optimizer_switch, @tmp2= @@join_cache_level; +set + optimizer_switch= 'derived_with_keys=off', + join_cache_level= 4; + +SELECT t1.* FROM t1 JOIN (SELECT id, COUNT(*) FROM t2 GROUP BY id) sq ON sq.id= t1.a; + +set optimizer_switch= @tmp1, join_cache_level= @tmp2; + +# Cleanup +DROP TABLE t1, t2; + --echo # End of 10.4 tests |