Re: Simple query returns inconsistent results when using "=" operator - update

> Hi Valeriy,
> I've downloaded and installed 5.1.30-community - still get the same bug.
> Before reporting a bug I will try to dump/import the same DB on another
> CentOS 5 machine - don't want to waste anyone's time unless I can
> reproduce it here.
> If you're interested in taking a look yourself I could give you ssh
> access to the server - please contact me off-list.
> 
Update:

Dumped/Loaded the DB to another server (CentOS 5.2, 5.0.45) - same
problem.

Another interesting observation:

Typed the query by, got results. Hit "arrow up" to repeat the same query
- no results:

mysql> select contact_id,system_message from contact_comments where
contact_id=168676 and system_message='no';
+------------+----------------+
| contact_id | system_message |
+------------+----------------+
|     168676 | no             | 
|     168676 | no             | 
+------------+----------------+
2 rows in set (0.00 sec)

mysql> select contact_id,system_message from contact_comments where
contact_id=168676 and system_message='no';
Empty set (0.00 sec)

mysql> select contact_id,system_message from contact_comments where
contact_id=168676 and system_message='no';
Empty set (0.00 sec)

Is there anything that caches queries that might be broken?

Cheers,
Thomas




-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]