On Thursday, 16. May 2002 21:44, Benjamin Pflugmann wrote: > Hi. > > What you observe is the fact that "-1" will be converted to the format > of the index, else the index could not be used. > > Converting -1 to an unsigned number give the biggest possible number > for the type in question (here BIGINT UNSIGNED). None of your numbers > is bigger than this, so you get an empty set, i.e. the result you > observe is to be expected.
Hmm... not really When you specify "... where id >= -1" it works fur int unsigned (not for bigint) > > IIRC, the behaviour without indexes has been fixed in the 4.x version > (to be also an unsigned comparison). No, its still the same in 4.x Regards Georg mysql,query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php