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