ONLY_FULL_GROUP_BY too strict on MySQL 4.1.11

[Harald Fuchs]

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 tbl
  GROUP BY col1

which is perfectly legal SQL AFAIK.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]