List:General Discussion« Previous MessageNext Message »
From:Krishna Chandra Prajapati Date:September 1 2008 7:59pm
Subject:Impossible WHERE in explain
View as plain text  
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