diff options
author | Sergey Petrunya <psergey@askmonty.org> | 2012-01-30 17:38:14 +0400 |
---|---|---|
committer | Sergey Petrunya <psergey@askmonty.org> | 2012-01-30 17:38:14 +0400 |
commit | 9fce78a48225e0aa584d590943e460ce98649669 (patch) | |
tree | 68f80ad85349f480898658170fe9eee1fdb252ac /mysql-test/t | |
parent | 5ca1dd8f0b22d6b5aea06c9ad32481498cb99d6e (diff) | |
parent | 53fde5bb6f98896c0ccd9b60a9576e5c5fef8a91 (diff) | |
download | mariadb-git-9fce78a48225e0aa584d590943e460ce98649669.tar.gz |
Merge fix for BUG#922254
Diffstat (limited to 'mysql-test/t')
-rw-r--r-- | mysql-test/t/subselect_sj_mat.test | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/t/subselect_sj_mat.test b/mysql-test/t/subselect_sj_mat.test index 2a5b0f56877..80ba42e7bab 100644 --- a/mysql-test/t/subselect_sj_mat.test +++ b/mysql-test/t/subselect_sj_mat.test @@ -1510,6 +1510,25 @@ SELECT * FROM t1 LEFT JOIN t2 ON ( a = b ) DROP TABLE t1,t2; +--echo # +--echo # BUG#922254: Assertion `0' failed at item_cmpfunc.cc:5899: Item* Item_equal::get_first(JOIN_TAB*, Item*) +--echo # +CREATE TABLE t1 ( a VARCHAR(3) ); +CREATE TABLE t2 ( b VARCHAR(3), c VARCHAR(8), KEY(c) ); +INSERT INTO t2 VALUES ('USA','Abilene'),('USA','Akron'); + +EXPLAIN +SELECT * FROM + ( SELECT * FROM t1 ) AS alias1, + t2 AS alias2 +WHERE b = a AND a IN ( + SELECT alias3.c + FROM t2 AS alias3, t2 AS alias4 + WHERE alias4.c = alias3.b +); + +DROP TABLE t1,t2; + --echo # This must be at the end: set optimizer_switch=@subselect_sj_mat_tmp; set join_cache_level=@save_join_cache_level; |