I still get the error:
mysql> create table test (a int, b int); Query OK, 0 rows affected (0.12 sec) mysql> insert into test (a,b) values (1,1); Query OK, 1 row affected (0.00 sec) mysql> insert into test (a,b) values (1,2); Query OK, 1 row affected (0.00 sec) mysql> insert into test (a,b) values (1,3); Query OK, 1 row affected (0.00 sec) mysql> set sql_mode='ONLY_FULL_GROUP_BY'; Query OK, 0 rows affected (0.00 sec) mysql> select @@sql_mode; +--------------------+ | @@sql_mode | +--------------------+ | ONLY_FULL_GROUP_BY | +--------------------+ 1 row in set (0.00 sec) mysql> select count(*) from test; +----------+ | count(*) | +----------+ | 3 | +----------+ 1 row in set (0.00 sec) mysql> select count(*) from test where a=1; ERROR 1140 (42000): Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause mysql> select version(); +-----------+ | version() | +-----------+ | 5.0.67-2 | +-----------+ 1 row in set (0.00 sec) mysql> -- Kim Hansen Vadgårdsvej 3, 2.tv 2860 Søborg Fastnet: 3956 2437 -- Mobil: 3091 2437 -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
