diff options
author | Sergei Golubchik <serg@mariadb.org> | 2022-04-29 14:50:47 +0200 |
---|---|---|
committer | Sergei Golubchik <serg@mariadb.org> | 2022-04-29 17:05:19 +0200 |
commit | 0beed9b5e933f0ff79b3bb346524f7a451d14e38 (patch) | |
tree | dc3839b657c7f9113ef315a04096480af52a4ae8 /mysql-test/main/having.result | |
parent | 8c34eab9688b4face54f15f89f5d62bdfd93b8a7 (diff) | |
download | mariadb-git-0beed9b5e933f0ff79b3bb346524f7a451d14e38.tar.gz |
MDEV-28097 use-after-free when WHERE has subquery with an outer reference in HAVING
when resolving WHERE and ON clauses, do not look in
SELECT list/aliases.
Diffstat (limited to 'mysql-test/main/having.result')
-rw-r--r-- | mysql-test/main/having.result | 6 |
1 files changed, 1 insertions, 5 deletions
diff --git a/mysql-test/main/having.result b/mysql-test/main/having.result index 8800402dc35..b4ca607ec84 100644 --- a/mysql-test/main/having.result +++ b/mysql-test/main/having.result @@ -279,11 +279,7 @@ select t1.col1 as tmp_col from t1 where t1.col2 in (select t2.col2 from t2 group by t2.col1, t2.col2 having tmp_col <= 10); -tmp_col -10 -10 -10 -10 +ERROR 42S22: Unknown column 'tmp_col' in 'having clause' select t1.col1 from t1 where t1.col2 in (select t2.col2 from t2 |