[svn.haxx.se] · SVN Dev · SVN Users · SVN Org · TSVN Dev · TSVN Users · Subclipse Dev · Subclipse Users · this month's index

Re: SQLite and callbacks

From: Stefan Sperling <stsp_at_elego.de>
Date: Mon, 7 Feb 2011 21:57:21 +0100

On Mon, Feb 07, 2011 at 09:32:48PM +0100, Branko Čibej wrote:
> On 07.02.2011 17:10, Stefan Sperling wrote:
> > The bug is probabaly in the following query.
> > Maybe the INSERT OR REPLACE doesn't work as intended?
> > And why is COMMIT TRANSACTION commented, BTW? Is this the problem?
> >
> > -- STMT_REPLACE_ACTUAL_PROPS_IN_CACHE
> > INSERT OR REPLACE INTO temp_query_cache.node_props_cache
> > (local_relpath, properties)
> > SELECT N.local_relpath, N.properties
> > FROM actual_node AS N JOIN temp_query_cache.node_props_cache AS C
> > ON N.local_relpath = C.local_relpath
> > AND N.wc_id = C.wc_id;
>
> Yes, this query that handles actual_nodes is bogus. I've been looking at
> fixing it, will update the patch when I find a solution.
>
> Or if you like, I can just commit it -- but that'd be throwing code over
> my shoulder, as there's little chance that I'd have time to maintain
> such a thing.

If you prefer, post the patch and I will make sure to understand
it sufficiently enough to be able to maintain it when it gets committed.
Received on 2011-02-07 21:58:06 CET

This is an archived mail posted to the Subversion Dev mailing list.