MySQL v3.23.49 linux
Hi,
We came across something strange here.
select count(*), user from mysql.user;
is illegal (ERROR 1140: Mixing of GROUP columns ... if there is no GROUP BY clause).
But,
select if( count(*) and user, 1, 0 ) from mysql.user;
actually works.
Is this a bug or a feature ?
==
Martin
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
