[sqlite] Endless loop in update recursive query with UNION ALL

[Slava G]

I have query that enters into endless loop in update recursive query with
UNION ALL, but when I remove ALL from the UNION it's works fine :
WITH recursive parentitems(itemid) AS (
VALUES("58f6fb3e-40a0-4b32-90a1-37945c44a649_c476ed54-217a-432a-9857-4fbb1eb5bc7a")

*UNION ALL *
SELECT snapshotdata.itemid
FROM   snapshotdata,
       parentitems
WHERE  folder = parentitems.itemid
AND    ifnull(deleteddate ,99999999999999) = 99999999999999 )
UPDATE snapshotdata
SET    deleteddate = 20190903142833
WHERE  itemid IN parentitems
AND    backupdate < 20190903142833
AND    ifnull(deleteddate,99999999999999) = 99999999999999

As far as I understand ALL in UNION should provide better performance, but
somehow it enters into endless loop and eat all computer resources.

Thanks
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users