Re: Disorder result using ORDER BY with ENUM, INT

Alexander Keremidarski wrote:

> All values of column `type` in your example has numeric representayion of 0 so
> (type AND id) will be always false.

I am wrong here. ENUM t5ype internally is represented as integer so in this case
result will be always 1 not 0 as I wrote.

Sorry for this confusion.

Best regards

-- 
 Are you MySQL certified? -> http://www.mysql.com/certification
 For technical support contracts, visit https://order.mysql.com/?ref=msal
    __  ___     ___ ____  __
   /  |/  /_ __/ __/ __ \/ /    Mr. Alexander Keremidarski <[email protected]>
  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Full-Time Developer
 /_/  /_/\_, /___/\___\_\___/   Sofia, Bulgaria
         <___/  www.mysql.com




-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]