diff options
| author | Varun Gupta <varunraiko1803@gmail.com> | 2017-01-24 01:21:43 +0530 |
|---|---|---|
| committer | Varun Gupta <varunraiko1803@gmail.com> | 2017-01-24 01:21:43 +0530 |
| commit | 1f3ad6a4ba63074c51c84dff449c35a8314a7f36 (patch) | |
| tree | 8a4fc74e65c003105eeae626887b2bb9ce63caaf /mysql-test/t/subselect_sj2.test | |
| parent | 45e40892c5bcd541cd93aebe8ba15b7a27289621 (diff) | |
| download | mariadb-git-1f3ad6a4ba63074c51c84dff449c35a8314a7f36.tar.gz | |
MDEV-11108: Assertion `uniq_tuple_length_arg <= table->file->max_key_length()' failed in SJ_TMP_TABLE::create_sj_weedout_tmp_table
Removed the assert from the if clause to the else clause.
Diffstat (limited to 'mysql-test/t/subselect_sj2.test')
| -rw-r--r-- | mysql-test/t/subselect_sj2.test | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/t/subselect_sj2.test b/mysql-test/t/subselect_sj2.test index 5d6639a6d5a..a948b086a85 100644 --- a/mysql-test/t/subselect_sj2.test +++ b/mysql-test/t/subselect_sj2.test @@ -1449,5 +1449,20 @@ SELECT * FROM t1 WHERE t1.id IN ( drop table t1,t2,t3; +--echo # +--echo # MDEV-11108: Assertion `uniq_tuple_length_arg <= table->file->max_key_length()' failed in SJ_TMP_TABLE::create_sj_weedout_tmp_table +--echo # + +CREATE TABLE t1 (a INT) ENGINE=InnoDB; +CREATE TABLE t2 (pk BLOB, b INT, PRIMARY KEY(pk(1000))) ENGINE=InnoDB; +CREATE TABLE t3 (c INT) ENGINE=InnoDB; +CREATE OR REPLACE ALGORITHM=MERGE VIEW v3 AS SELECT * FROM t3; + +INSERT INTO t3 VALUES (1),(2),(3),(4),(5),(6),(7),(8); +SELECT * FROM t1, t2 +WHERE a IN ( SELECT b FROM t2 LEFT JOIN v3 ON ( c = b ) ) ; +DROP TABLE t1,t2,t3; +DROP VIEW v3; + --echo # This must be the last in the file: set optimizer_switch=@subselect_sj2_tmp; |