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. -- Brane