[Csync2] recursive selects with sqlite

[Christian Wiese]

Hi Art & Lars,

I don't know if someone tested 'csync2 -fr' while using this patch, but
at least it produces a regression on test machines running Ubuntu
hardy and Debian etch.

-------------------------snip------------------------------------------
# csync2 -rf /etc/opt/csync2
Database Error: Mark file as to be forced [1]: UPDATE dirty SET force =
1 WHERE filename = '/etc/opt/csync2' UNION ALL SELECT filename from
file where filename > '/etc/opt/csync2/' and filename <
'/etc/opt/csync20'
-------------------------snip------------------------------------------

If I revert the change made by r403 it seems to be fine though!

Any ideas?

Cheers,
Christian

Am Tue, 21 Oct 2008 18:20:38 +0200
schrieb Art -kwaak- van Breemen <ard+csync2 at telegraafnet.nl>:

> I've said it earlier that the recursive selects are a pain for
> mysql.
> The patch I've mentioned earlier seems to work ok, so I now
> submit it for inclusion
>