Re: Weird result on max compared to order by

[Sebastian Mendel]

jmacaranas@stripped schrieb:
> Hi,
> 
>   I did a select on a primary key.. 
>     Select max(account_id) from mytable;
>            -- it gave me a value X
> 
>   I did a select with order by
>     Select account_id from mytable order by account_id desc limit 3
>            -- it gave me a value of Y ( Y is the right value )
> 
> 
>   I was wondering why it didn't gave me the same value and after some
> time doing a select max gave me the right value "Y"

seems your index was corrupted

-- 
Sebastian Mendel