[rql2sql] closes #1832859: fake HAVING terms w/ EXISTS terms
there are cases where we want to use the HAVING trick on terms that should
belong to an EXISTS subquery. Currently , this causes bad sql. We should fix
that until we've a proper rql grammar avoiding the need for this trick.
Notice at some point, we may want **actuall** HAVING clauses and GROUPBY used
in EXISTS subquery, but that's another story.
sync_schema_props_perms('CWSourceHostConfig', syncperms=False)
sql('INSERT INTO cw_source_relation(eid_from, eid_to) '
'SELECT e.eid,s.cw_eid FROM entities as e, cw_CWSource as s '
'WHERE s.cw_name=e.source AND NOT EXISTS(SELECT 1 FROM cw_source_relation WHERE eid_from=e.eid AND eid_to=s.cw_eid)')
commit()