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
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
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
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
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
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
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
7 matches
Mail list logo