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.