Re: [sqlite] possible bug handling group by and where clauses

2011-03-03 Thread alexis bialot
On 02/03/2011 17:30, Jay A. Kreibich wrote: > On Wed, Mar 02, 2011 at 09:53:51AM +0100, alexis bialot scratched on the wall: >> hello, >> >> this looks to me like a bug but maybe this is just my misunderstanding. > You might run an integrity check on the database file and verify > any indexes

Re: [sqlite] possible bug handling group by and where clauses

2011-03-02 Thread Jay A. Kreibich
On Wed, Mar 02, 2011 at 09:53:51AM +0100, alexis bialot scratched on the wall: > hello, > > this looks to me like a bug but maybe this is just my misunderstanding. You might run an integrity check on the database file and verify any indexes you have are correct and include all rows. If

Re: [sqlite] possible bug handling group by and where clauses

2011-03-02 Thread Richard Hipp
Can you send me the database that demonstrates this problem, via private email, please? On Wed, Mar 2, 2011 at 3:53 AM, alexis bialot wrote: > hello, > > this looks to me like a bug but maybe this is just my misunderstanding. > > the databases shema is the trac database

Re: [sqlite] possible bug handling group by and where clauses

2011-03-02 Thread Simon Slavin
On 2 Mar 2011, at 3:26pm, alexis bialot wrote: > as expected, the lines for iter63 and up disapear : there are no > corresponding lines on the right hand side Okay, what you write appears to be correct, but requires more intimate knowledge of the inner workings of SQLite than I have. I'll

Re: [sqlite] possible bug handling group by and where clauses

2011-03-02 Thread alexis bialot
hello thanks for your quick reply > On 2 Mar 2011, at 8:53am, alexis bialot wrote: > >> i do not believe it should be possible that a query with a left join >> yields less results >> than the exact same query with an inner join. > Do you have any null fields anywhere in either TABLE ? Nulls make

Re: [sqlite] possible bug handling group by and where clauses

2011-03-02 Thread Simon Slavin
On 2 Mar 2011, at 8:53am, alexis bialot wrote: > i do not believe it should be possible that a query with a left join > yields less results > than the exact same query with an inner join. Do you have any null fields anywhere in either TABLE ? Nulls make analysis of what's happening very

[sqlite] possible bug handling group by and where clauses

2011-03-02 Thread alexis bialot
hello, this looks to me like a bug but maybe this is just my misunderstanding. the databases shema is the trac database schema visible here http://trac.edgewall.org/wiki/TracDev/DatabaseSchema but i do not believe the schema is really relevant to the point the problematic clause is "and