Re: [sqlite] Sqlite bug with aggregate counts query that excludes null values?

2008-07-30 Thread D. Richard Hipp
On Jul 30, 2008, at 7:14 PM, Tim Dao wrote: > I ran into strange behavior in dealing with Sqlite 3.5.9 on a 6 > million > record table I was using in development and wanted to see if I could > duplicate the error in an entirely separate instance so I tried it > from > Firefox 3.0 + SqliteMana

[sqlite] Sqlite bug with aggregate counts query that excludes null values?

2008-07-30 Thread Tim Dao
I ran into strange behavior in dealing with Sqlite 3.5.9 on a 6 million record table I was using in development and wanted to see if I could duplicate the error in an entirely separate instance so I tried it from Firefox 3.0 + SqliteManager Plugin much to the same effect. Basically when running a