From: Michael Widenius
Date: March 24 1999 10:39pm
Subject: strage behavior ...
List-Archive: http://lists.mysql.com/mysql/931
Message-Id: <14073.26978.659336.692276@monty.pp.sci.fi>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

>>>>> "Roman" == Roman D Sinyuk <roman@stripped> writes:

Roman> Hi All!
Roman> I have a strange behavior of mysql server:

mysql> select * from access_all where url_host_id=5455;
Roman> Empty set (0.00 sec)

mysql> select count(*) from access_all where url_host_id=5455;
Roman> +----------+
Roman> | count(*) |
Roman> +----------+
Roman> |      101 |
Roman> +----------+
Roman> 1 row in set (0.01 sec)

mysql> 

Roman> What does it mean ?
Roman> This happens after 3.22.13-beta to 3.22.19b upgrade, files on
Roman> /usr/local/mysql/var was untouched.

Roman> my OS is FreeBSD-stable.  

Hi!

Please check your table with 'isamchk -e access_all' to verify that
this is ok !

If not, run isamchk -r 'access_all' to repair it !

Regards,
Monty