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