It might be because you you are comparing user_id to a string, when
the field type is a decimal. Drop the quotes around the user_id search
value and see if that works.
Brent Baisley
On Sep 1, 2008, at 3:59 PM, Krishna Chandra Prajapati wrote:
> Hi,
>
> In the query below explain gives 'Impossible WHERE noticed after'.
> what does
> this mean.
>
> CREATE TABLE `user_cookie` (
> `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`),
> CONSTRAINT `fk_user_cookie` FOREIGN KEY (`user_id`) REFERENCES
> `user_info` (`user_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
> ) ENGINE=InnoDB DEFAULT CHARSET=latin1
>
> SELECT VALUE FROM user_cookie WHERE USER_ID = '10538485' AND
> PARAM =
> 'TIMEOUT' table |type |possible_keys |key | ken_len|ref | rows| 1
> |SIMPLE | | | | | |Impossible WHERE noticed afte
> --
> Krishna Chandra Prajapati
