973
973
DROP TABLE derived1;
977
# Bug #39656: Behaviour different for agg functions with & without where -
981
CREATE TABLE t1 (a INT, b INT);
982
INSERT INTO t1 VALUES (1,1), (1,2), (1,3);
984
SET SQL_MODE='ONLY_FULL_GROUP_BY';
986
SELECT COUNT(*) FROM t1;
987
SELECT COUNT(*) FROM t1 where a=1;
989
--error ER_MIX_OF_GROUP_FUNC_AND_FIELDS
990
SELECT COUNT(*),a FROM t1;
992
SELECT COUNT(*) FROM t1 a JOIN t1 b ON a.a= b.a;
994
--error ER_MIX_OF_GROUP_FUNC_AND_FIELDS
995
SELECT COUNT(*), (SELECT count(*) FROM t1 inr WHERE inr.a = outr.a)
998
SELECT COUNT(*) FROM t1 a JOIN t1 outr
999
ON a.a= (SELECT count(*) FROM t1 inr WHERE inr.a = outr.a);
1001
SET SQL_MODE=default;
977
1006
--echo End of 5.0 tests