diff options
| author | Oleksandr Byelkin <sanja@mariadb.com> | 2016-12-05 17:37:54 +0100 |
|---|---|---|
| committer | Oleksandr Byelkin <sanja@mariadb.com> | 2016-12-06 19:34:25 +0100 |
| commit | d67ef7a2fb3b52b3f61ce71dfe23cf4d610afc3c (patch) | |
| tree | f961dcee68f01bb7232f135321602cd1d7222a09 /mysql-test/r/group_by.result | |
| parent | 035a5ac62a0215c2f6e3e363331e3e984d780138 (diff) | |
| download | mariadb-git-d67ef7a2fb3b52b3f61ce71dfe23cf4d610afc3c.tar.gz | |
MDEV-10663: Use of Inline table columns in HAVING clause throws 1463 Error
check for VIEW/DERIVED fields
Diffstat (limited to 'mysql-test/r/group_by.result')
| -rw-r--r-- | mysql-test/r/group_by.result | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/r/group_by.result b/mysql-test/r/group_by.result index 0b4973cc35b..262bb2ebd84 100644 --- a/mysql-test/r/group_by.result +++ b/mysql-test/r/group_by.result @@ -2517,3 +2517,17 @@ MAX(i) c 0 bar 7 foo drop table t1,t2; +# +# ONLY_FULL_GROUP_BY references +# +set @save_sql_mode = @@sql_mode; +set sql_mode='ONLY_FULL_GROUP_BY'; +create table t1 (a int, b int); +select a+b as x from t1 group by x having x > 1; +x +select a as x from t1 group by x having x > 1; +x +select a from t1 group by a having a > 1; +a +drop table t1; +set sql_mode= @save_sql_mode; |