On Tue, Jun 4, 2013 at 2:42 PM, Chen, Mi <[email protected]> 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
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
