List:General Discussion« Previous MessageNext Message »
From:Brent Baisley Date:September 1 2008 8:25pm
Subject:Re: Impossible WHERE in explain
View as plain text  
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

Thread
Impossible WHERE in explainKrishna Chandra Prajapati1 Sep
  • Re: Impossible WHERE in explainBrent Baisley1 Sep
    • Re: Impossible WHERE in explainKrishna Chandra Prajapati1 Sep
      • RE: Impossible WHERE in explainMartin Gainty2 Sep
        • Re: Impossible WHERE in explainKrishna Chandra Prajapati2 Sep
  • Re: Impossible WHERE in explainJim Lyons1 Sep