Re: [sqlite] SQLite - potential bug with multiple leftjoin/groupby/count

2013-09-04 Thread Clemens Ladisch
Harry Beezhold wrote: > Sqlite - What a cool product! Do you really think buggy products are cool? ;-) > The following is a description of an apparent bug in > the calculation of a row count of a left joined table. > The leftjoin/count technique seems to work for each join/count, separately.

Re: [sqlite] SQLite - potential bug with multiple leftjoin/groupby/count

2013-09-04 Thread Richard Hipp
On Tue, Sep 3, 2013 at 10:41 AM, Harry Beezhold wrote: > > > The attached database (view.db) has 3 tables > The sqlite-users@sqlite.org mailing list strips off attachments. Can you send a link instead? -- D. Richard Hipp d...@sqlite.org

[sqlite] SQLite - potential bug with multiple leftjoin/groupby/count

2013-09-04 Thread Harry Beezhold
Hi, Sqlite - What a cool product! The following is a description of an apparent bug in the calculation of a row count of a left joined table. In the intended application I plan to use this type of query to feed and filter the list on the "choose a person" popup in a genealogy