diff options
| author | Oleksandr Byelkin <sanja@mariadb.com> | 2016-09-21 18:36:34 +0200 |
|---|---|---|
| committer | Oleksandr Byelkin <sanja@mariadb.com> | 2016-12-06 16:14:56 +0100 |
| commit | f988bcecfde819d3d3d2d7227789491fcc0ee430 (patch) | |
| tree | 2465c7a929daa28e1e4c6bb85438238a6b34e05f /mysql-test/r/subselect_no_mat.result | |
| parent | 46dee0d1848e24e39fc236e78a438efa22356f8d (diff) | |
| download | mariadb-git-f988bcecfde819d3d3d2d7227789491fcc0ee430.tar.gz | |
MDEV-10776: Server crash on query
Exclude untouched in prepare phese subqueries from the select/unit tree
because they became unreachable by execution.
Diffstat (limited to 'mysql-test/r/subselect_no_mat.result')
| -rw-r--r-- | mysql-test/r/subselect_no_mat.result | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/subselect_no_mat.result b/mysql-test/r/subselect_no_mat.result index aed4fb39a84..b819b1e4ef9 100644 --- a/mysql-test/r/subselect_no_mat.result +++ b/mysql-test/r/subselect_no_mat.result @@ -7091,6 +7091,17 @@ a 0 DROP TABLE t1; SET SESSION big_tables=0; +# +# MDEV-10776: Server crash on query +# +create table t1 (field1 int); +insert into t1 values (1); +select round((select 1 from t1 limit 1)) +from t1 +group by round((select 1 from t1 limit 1)); +round((select 1 from t1 limit 1)) +1 +drop table t1; set optimizer_switch=default; select @@optimizer_switch like '%materialization=on%'; @@optimizer_switch like '%materialization=on%' |