Re: [sqlite] Different result set of query in examples of SQLite book

Thank you, Igor. :) 2013/6/13 Igor Tandetnik > On 6/13/2013 12:24 AM, Yongil Jang wrote: > >> SELECT >>name, >>(SELECT COUNT(id) FROM foods_episodes WHERE food_id=f.id) count >> FROM >>foods f >> ORDER BY count DESC LIMIT 10; >> >> >> Result from v3.7.6 and

Re: [sqlite] Different result set of query in examples of SQLite book

On 6/13/2013 12:24 AM, Yongil Jang wrote: SELECT name, (SELECT COUNT(id) FROM foods_episodes WHERE food_id=f.id) count FROM foods f ORDER BY count DESC LIMIT 10; Result from v3.7.6 and v3.7.11. Hot Dog|5 Kasha|4 Ketchup|4 .. Result from v3.7.13 and v3.7.17. Wax Beans (Generic

[sqlite] Different result set of query in examples of SQLite book

Dear all, Following select query returns different result data between v3.7.11 and v3.7.13~. CREATE TABLE foods( id integer primary key, type_id integer, name text ); CREATE TABLE foods_episodes( food_id integer, episode_id integer ); [Insert some data] SELECT name, (SELECT