From: Roman D. Sinyuk Date: March 24 1999 2:58pm Subject: strage behavior ... List-Archive: http://lists.mysql.com/mysql/895 Message-Id: <199903241458.QAA03179@titanic.uninet.kiev.ua> MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Hi All! I have a strange behavior of mysql server: mysql> select * from access_all where url_host_id=5455; Empty set (0.00 sec) mysql> select count(*) from access_all where url_host_id=5455; +----------+ | count(*) | +----------+ | 101 | +----------+ 1 row in set (0.01 sec) mysql> What does it mean ? This happens after 3.22.13-beta to 3.22.19b upgrade, files on /usr/local/mysql/var was untouched. my OS is FreeBSD-stable.