diff options
| author | unknown <sanja@askmonty.org> | 2014-04-15 13:20:26 +0300 |
|---|---|---|
| committer | unknown <sanja@askmonty.org> | 2014-04-15 13:20:26 +0300 |
| commit | 05722f06b212f0229dbc541b3d370319712d156a (patch) | |
| tree | 6b6544a111dc070e55479e72d31171d5ff5aa838 /mysql-test/r/subselect_no_semijoin.result | |
| parent | d1d64015cf4025fe5e95fc54df88d10e1ad99881 (diff) | |
| download | mariadb-git-05722f06b212f0229dbc541b3d370319712d156a.tar.gz | |
MDEV-5991: crash in Item_field::used_tablesmariadb-5.5.37
Units of subqueroes from excluded expressions should be excluded from select_lex/select_unit tree.
Diffstat (limited to 'mysql-test/r/subselect_no_semijoin.result')
| -rw-r--r-- | mysql-test/r/subselect_no_semijoin.result | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/subselect_no_semijoin.result b/mysql-test/r/subselect_no_semijoin.result index d0e9ae225d9..d51d211e71d 100644 --- a/mysql-test/r/subselect_no_semijoin.result +++ b/mysql-test/r/subselect_no_semijoin.result @@ -7002,5 +7002,13 @@ id select_type table type possible_keys key key_len ref rows Extra 2 SUBQUERY t1 index a a 5 NULL 2 Using where; Using index 2 SUBQUERY t2 ref b b 5 test.t1.a 2 Using index DROP TABLE t1,t2; +# +# MDEV-5991: crash in Item_field::used_tables +# +create table t1 (c int); +select exists(select 1 from t1 group by `c` in (select `c` from t1)); +exists(select 1 from t1 group by `c` in (select `c` from t1)) +0 +drop table t1; set @optimizer_switch_for_subselect_test=null; set @join_cache_level_for_subselect_test=NULL; |