It's not a bug.
http://www.sqlite.org/optoverview.html#minmax


Pavel

On Fri, Apr 2, 2010 at 6:06 AM, Alexey Pechnikov <pechni...@mobigroup.ru> wrote:
> Hello!
>
> sqlite> select max(rowid) from role;
> 10000000
> CPU Time: user 0.000000 sys 0.000000
>
> sqlite> select max(rowid)/1000000. from role;
> 10.0
> CPU Time: user 1.512094 sys 3.732233
>
>
> sqlite> explain query plan select max(rowid) from role;
> 0|0|TABLE role USING PRIMARY KEY ORDER BY
> CPU Time: user 0.000000 sys 0.000000
>
> sqlite> explain query plan select max(rowid)/1000000. from role;
> 0|0|TABLE role
> CPU Time: user 0.000000 sys 0.000000
>
>
> Best regards, Alexey Pechnikov.
> http://pechnikov.tel/
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to