diff options
| author | Vicențiu Ciorbaru <vicentiu@mariadb.org> | 2016-02-08 22:53:40 +0200 |
|---|---|---|
| committer | Vicențiu Ciorbaru <vicentiu@mariadb.org> | 2016-02-09 19:02:25 +0200 |
| commit | 775cccca9f1502ae2f4cf1417d0f94d4872d4630 (patch) | |
| tree | 8611a9f868e11c3ff9d702da9bb545cbf72d72ef /mysql-test/r/subselect_no_semijoin.result | |
| parent | 01628ce35a241c2bd1a3c2954ee09b6dda961a74 (diff) | |
| download | mariadb-git-775cccca9f1502ae2f4cf1417d0f94d4872d4630.tar.gz | |
MDEV-7122: Assertion `0' failed in subselect_hash_sj_engine::init
The select mentioned in the bug attempted to create a temporary table
using the maria storage engine. The table needs to have primary keys such that
duplicates can be removed. Unfortunately this use case has a longer
than allowed key and the tmp table got created without a temporary key.
We must not allow materialization for the subquery if the total key
length and key parts is greater than what the storage engine supports.
Diffstat (limited to 'mysql-test/r/subselect_no_semijoin.result')
| -rw-r--r-- | mysql-test/r/subselect_no_semijoin.result | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/r/subselect_no_semijoin.result b/mysql-test/r/subselect_no_semijoin.result index 524a5ddc1a6..b815559433c 100644 --- a/mysql-test/r/subselect_no_semijoin.result +++ b/mysql-test/r/subselect_no_semijoin.result @@ -7076,5 +7076,18 @@ sq NULL deallocate prepare stmt; drop table t1,t2,t3,t4; +# MDEV-7122 +# Assertion `0' failed in subselect_hash_sj_engine::init +# +SET SESSION big_tables=1; +CREATE TABLE t1(a char(255) DEFAULT '', KEY(a(10))) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; +INSERT INTO t1 VALUES(0),(0),(0); +SELECT * FROM t1 WHERE a IN(SELECT MIN(a) FROM t1); +a +0 +0 +0 +DROP TABLE t1; +SET SESSION big_tables=0; set @optimizer_switch_for_subselect_test=null; set @join_cache_level_for_subselect_test=NULL; |