end;
request=\
- SELECT edmn.COLLECTIVITE, edmn.BUDGET, edmn.DOC_ID \
- FROM EDMN_ETAT edmn \
- LEFT OUTER JOIN EDMN_ETAT_LIASSES liasse ON edmn.COLLECTIVITE=liasse.COLLECTIVITE AND edmn.BUDGET=liasse.BUDGET AND edmn.DOC_ID=liasse.DOC_ID \
- GROUP BY edmn.COLLECTIVITE, edmn.BUDGET, edmn.DOC_ID HAVING count(liasse.DOC_ID) = 0
-
+ SELECT edmn.COLLECTIVITE, edmn.BUDGET, edmn.DOC_ID \
+ FROM EDMN_ETAT edmn \
+ WHERE NOT EXISTS( \
+ SELECT 1 \
+ FROM EDMN_ETAT_LIASSES liasse \
+ WHERE edmn.COLLECTIVITE=liasse.COLLECTIVITE \
+ AND edmn.BUDGET=liasse.BUDGET \
+ AND edmn.DOC_ID=liasse.DOC_ID \
+ )
+
requestCount=\
- SELECT COUNT(*) from ( \
- SELECT edmn.COLLECTIVITE, edmn.BUDGET, edmn.DOC_ID \
- FROM EDMN_ETAT edmn \
- LEFT OUTER JOIN EDMN_ETAT_LIASSES liasse ON edmn.COLLECTIVITE=liasse.COLLECTIVITE AND edmn.BUDGET=liasse.BUDGET AND edmn.DOC_ID=liasse.DOC_ID \
- GROUP BY edmn.COLLECTIVITE, edmn.BUDGET, edmn.DOC_ID \
- HAVING count(liasse.DOC_ID) = 0 \
- )
+ SELECT COUNT(*) FROM ( \
+ SELECT edmn.COLLECTIVITE, edmn.BUDGET, edmn.DOC_ID \
+ FROM EDMN_ETAT edmn \
+ WHERE NOT EXISTS( \
+ SELECT 1 \
+ FROM EDMN_ETAT_LIASSES liasse \
+ WHERE edmn.COLLECTIVITE=liasse.COLLECTIVITE \
+ AND edmn.BUDGET=liasse.BUDGET \
+ AND edmn.DOC_ID=liasse.DOC_ID \
+ ) \
+ )
truncateTableIndexPatch=TRUNCATE TABLE INDEX_PATCH