Forum OpenACS Q&A: Re: cr_delete_scheduled_files causing errors
select distinct crftd.path, crftd.storage_area_key from cr_files_to_delete crftd where not exists (select 1 from cr_revisions r where r.content = crftd.path)and now it looks like:
SELECT distinct crftd.path as storage_area_key FROM cr_files_to_delete crftd WHERE not exists (SELECT 1 FROM cr_revisions r WHERE r.content = crftd.path)
I'll go ahead and change it back.
In oracle version (acs-content-repository-procs-oracle.xql) it seems to be something in between :
select distinct crftd.path storage_area_key from cr_files_to_delete crftd where not exists (select 1 from cr_revisions r where r.filename = crftd.path)BTW, is your change just in HEAD or also in the 4-6 branch?