one query work, but other don't work - Michael Widenius - com.mysql.lists.bugs

6 messages in com.mysql.lists.bugsone query work, but other don't work

Subject:	one query work, but other don't work
From:	Michael Widenius (mon...@mysql.com)
Date:	01/08/2002 09:50:48 AM
List:	com.mysql.lists.bugs

Hi!

"igor" == igor <koi8-r> writes:

igor> How-To-Repeat: igor> SELECT COUNT(DISTINCT ip), COUNT(*), CONCAT(shref,href) FROM hit igor> GROUP BY 3 igor> It is work!!!

igor> SELECT COUNT(*), CONCAT(shref, href) FROM hit igor> GROUP BY 2 igor> It does not work!!!

<cut>

Sorry, but the above is not enough for us to be able to repeat your problem.

If you want to have a fast solution for this, please post (with the mysqlbug script) a full repeatable example of your problem.

Regards, Monty