[debian-mysql] Bug#505181: Still failing for me

[Kim Hansen]

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