Re: SQLite and callbacks

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
Received on 2011-02-07 21:33:31 CET