|
If a query with GROUP BY contains an aggregate function with an alias and this alias
is used in the HAVING clause of the query the server reports an error:
MariaDB [test]> SELECT a, COUNT(a) as ct FROM t1 GROUP BY a HAVING ct>0;
|
ERROR 1463 (42000): Non-grouping field 'ct' is used in HAVING clause
|
The following test case demonstrates the problem:
SET sql_mode = 'ONLY_FULL_GROUP_BY';
|
|
create table t1(a int);
|
insert t1 values (4),(1),(2),(1), (3),(4);
|
|
SELECT a, COUNT(a) as ct FROM t1 GROUP BY a HAVING ct>0;
|
|