From: Martin Gainty Date: September 2 2008 12:48am Subject: RE: Impossible WHERE in explain List-Archive: http://lists.mysql.com/mysql/214318 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="_ae744b3f-2fb7-4551-9175-e1fc6abacac9_" --_ae744b3f-2fb7-4551-9175-e1fc6abacac9_ Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable The key_len column indicates the length of the key that MySQL decided to us= e. The length is NULL if the key column says NULL. Note that the value of k= ey_len allows you to determine how many parts of a multiple-part key MySQL = will actually use. i do not know the definition of parameter 'ken_len'Martin _________________= _____________________________ Disclaimer and confidentiality note Everythin= g in this e-mail and any attachments relates to the official business of Se= nder. This transmission is of a confidential nature and Sender does not end= orse distribution to any party other than intended recipient. Sender does n= ot necessarily endorse content contained within this transmission. > Date: = Tue=2C 2 Sep 2008 02:05:00 +0530> From: prajapatikc@stripped> To: brenttec= h@stripped> Subject: Re: Impossible WHERE in explain> CC: mysql@stripped= l.com> > I have already tried. It's not working.> > On Tue=2C Sep 2=2C 2008= at 1:55 AM=2C Brent Baisley wrote:> > > It might be = because you you are comparing user_id to a string=2C when the> > field type= is a decimal. Drop the quotes around the user_id search value and> > see i= f that works.> >> > Brent Baisley> >> >> > On Sep 1=2C 2008=2C at 3:59 PM= =2C Krishna Chandra Prajapati wrote:> >> > Hi=2C> >>> >> In the query below= explain gives 'Impossible WHERE noticed after'. what> >> does> >> this mea= n.> >>> >> CREATE TABLE `user_cookie` (> >> `user_id` decimal(22=2C0) NOT N= ULL default '0'=2C> >> `param` varchar(128) NOT NULL default ''=2C> >> `val= ue` varchar(128) default NULL=2C> >> PRIMARY KEY (`user_id`=2C`param`)=2C> = >> CONSTRAINT `fk_user_cookie` FOREIGN KEY (`user_id`) REFERENCES> >> `user= _info` (`user_id`) ON DELETE NO ACTION ON UPDATE NO ACTION> >> ) ENGINE=3DI= nnoDB DEFAULT CHARSET=3Dlatin1> >>> >> SELECT VALUE FROM user_cookie WHERE = USER_ID =3D '10538485' AND PARAM =3D> >> 'TIMEOUT' table |type |possible_ke= ys |key | ken_len|ref | rows| 1> >> |SIMPLE | | | | | |Impossible WHERE not= iced afte> >> --> >> Krishna Chandra Prajapati> >>> >> >> > > -- > Krishna = Chandra Prajapati _________________________________________________________________ Be the filmmaker you always wanted to be=97learn how to burn a DVD with Win= dows=AE. http://clk.atdmt.com/MRT/go/108588797/direct/01/= --_ae744b3f-2fb7-4551-9175-e1fc6abacac9_--