I'm using MySQL 4.1.11 with sql-mode=ONLY_FULL_GROUP_BY set in my.cnf.
This disallows things like
SELECT col1, col2, sum(col1)
FROM tbl
GROUP BY col1
as it should, and it allows
SELECT col1, sum(col1)
FROM tbl
GROUP BY col1
but it also disallows
SELECT col1, sum(col1) + 1
FROM
-Original Message-
From: news [mailto:[EMAIL PROTECTED] On Behalf Of Harald Fuchs
Sent: samedi 30 avril 2005 00:00
To: mysql@lists.mysql.com
Subject: ONLY_FULL_GROUP_BY too strict on MySQL 4.1.11
I'm using MySQL 4.1.11 with sql-mode=ONLY_FULL_GROUP_BY set in my.cnf.
This disallows