Re: [sqlite] A Potential Bug

In this case, sqlite3VdbeAllocUnpackedRecord is called with pSpace = 0 and szSpace = 0. The calculated value of nOff will also be 0, since pSpace is 0. nByte must be greater than zero, as it is the sum of two positive terms. Therefore the test "if( nByte>szSpace+nOff )" will be true, and the

[sqlite] A Potential Bug

Hi, all, I am using our automatic bug finding tool to scan the source code of sqlite. The tool is designed to find potential null dereference bug. It issues warning for the function sqlite3VdbeAllocUnpackedRecord. SQLITE_PRIVATE UnpackedRecord *sqlite3VdbeAllocUnpackedRecord( KeyInfo

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

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

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

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