List:General Discussion« Previous MessageNext Message »
From:Krishna Chandra Prajapati Date:September 1 2008 8:35pm
Subject:Re: Impossible WHERE in explain
View as plain text  
I have already tried. It's not working.

On Tue, Sep 2, 2008 at 1:55 AM, Brent Baisley <brenttech@stripped> wrote:

> 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
>>
>
>


-- 
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