On Tue, Jun 4, 2013 at 2:42 PM, Chen, Mi <mi.c...@echostar.com> wrote:
> All, I encountered a likely bug during development with latest SQL
> versions (3.7.17)... It appears to be affecting the result of queries with
> GROUP BY clause with partial join over two primary keys.
>
Your test case has been added here:
http://www.sqlite.org/src/info/96afe50866
Your test works with the next-generation query planner (NGQP) but (as you
observe) fails in 3.7.17. Probably this is due to one of the existing bug
reports written against the ORDER BY optimizer in 3.7.17. The problem
should be fixed when we cut over to the NGQP.
--
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
