diff options
| author | Oleksandr Byelkin <sanja@mariadb.com> | 2015-04-23 19:04:11 +0200 |
|---|---|---|
| committer | Oleksandr Byelkin <sanja@mariadb.com> | 2015-10-06 13:12:58 +0200 |
| commit | 7ccde2cbd55814d6f8525552d27674a5d1f577bf (patch) | |
| tree | 41aa84798439acf4b9a2d87c087a0fddcc4a70f1 /mysql-test/r/subselect_no_scache.result | |
| parent | 006acf7454730ca6b6a603b2cd74b9bde3b6c020 (diff) | |
| download | mariadb-git-7ccde2cbd55814d6f8525552d27674a5d1f577bf.tar.gz | |
MDEV-7565: Server crash with Signal 6 (part 2)
Preparation of subselect moved earlier (before checks which needs it prepared).
Diffstat (limited to 'mysql-test/r/subselect_no_scache.result')
| -rw-r--r-- | mysql-test/r/subselect_no_scache.result | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/r/subselect_no_scache.result b/mysql-test/r/subselect_no_scache.result index b6d3a89ea7a..9a49fedb093 100644 --- a/mysql-test/r/subselect_no_scache.result +++ b/mysql-test/r/subselect_no_scache.result @@ -7021,6 +7021,18 @@ 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; +# +# MDEV-7565: Server crash with Signal 6 (part 2) +# +Select +(Select Sum(`TestCase`.Revenue) From mysql.slow_log E +Where TestCase.TemplateID not in (Select 1 from mysql.slow_log where 2=2) +) As `ControlRev` +From +(Select 3 as Revenue, 4 as TemplateID) As `TestCase` +Group By TestCase.Revenue, TestCase.TemplateID; +ControlRev +NULL set optimizer_switch=default; select @@optimizer_switch like '%subquery_cache=on%'; @@optimizer_switch like '%subquery_cache=on%' |