MySQL Bugs: #2665: inconsistent mysql.user table queries

Bug #2665	inconsistent mysql.user table queries
Submitted:	6 Feb 2004 8:43	Modified:	6 Feb 2004 10:52
Reporter:	jay mortensen	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQLCC	Severity:	S2 (Serious)
Version:	0.9.4	OS:	Linux (linux)
Assigned to:	Dean Ellis	CPU Architecture:	Any

Description:
this happened on both 0.9.4-beta and 0.9.0-beta on linux
i'm connecting from a remote mysqlcc client as user "root" to a 4.0 server
when i double click User Administration tab, it only shows 1 user, although
there are 4 users defined

if i open an SQL window in mysqlcc and query directly, for example:
use mysql;
select User,Host from user;
it shows 1 user (the same one as the User Admin tab)

here's where it gets weird:
- select * from user; shows 1 user - a different one!!!!
- select count(*) from user; answers 4 (the correct answer)

if i connect using command line client from same client machine, i get correct query results. if i connect with the same mysqlcc to a different (3.2.3) server i get correct results. if i use mysqlcc 0.9.4 from windows XP i get correct results. 

How to repeat:
see above.

Check your server configuration and ensure that you do not have SELECT results limited to 1 row, which can cause precisely this behavior.

ok, fixed. this isn't a bug in 0.9.4. may be a bug/feature in 0.9.0. the server registrations i define using 0.9.0 have the select limit set to 1 by default. but in 0.9.4 it's defaulting to 1000, and i can see my users. thanks, dean!

Ok, thanks for the update!