Hi All, I have table user_cookie with myisam storage engine. Its structure is below. CREATE TABLE `user_coookie` ( `user_id` decimal(22,0) NOT NULL default '0', `param` varchar(128) NOT NULL default '', `value` varchar(128) default NULL, PRIMARY KEY (`user_id`,`param`), KEY `idx1_user_cookie` (`user_id`), KEY `idx2_user_cookie` (`param`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1
It has some data also in it. Its happening with this specific users as mentioned below. When i am running query select count(*) it gives 0 and select count(*) with like give the result as 1. It has been shown below. mysql> select count(*) from user_cookie where user_id=9383968; +----------+ | count(*) | +----------+ | 0 | +----------+ 1 row in set (0.00 sec) mysql> select count(*) from user_cookie where user_id like '9383968'; +----------+ | count(*) | +----------+ | 1 | +----------+ I have also executed length command to check the length. It has been shown below. mysql> select length(user_id) from user_cookie where user_id like '9383968'; +-----------------+ | length(user_id) | +-----------------+ | 7 | +-----------------+ 1 row in set (0.53 sec) mysql> select length(user_id) from user_cookie where user_id='9383968'; Empty set (0.00 sec) Check table user_cookie gives the result below. mysql> check table user_cookie; +-----------------+-------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-----------------+-------+----------+----------+ | dip.user_cookie | check | status | OK | +-----------------+-------+----------+----------+ 1 row in set (16.49 sec) I didn't get what is the issue with this user. Any suggestions will be greatly appreciated. Thanks, Krishna Chandra Prajapati
