CMIS Query of unset multi-valued property

If dc:subjects is not set, am I correct that “quantified in predicate” (ANY dc:subjects NOT IN ('foo')) is FALSE? This is because at least one dc:subjects would need to exist that is not 'foo', right?

0 votes

1 answers

1809 views

ANSWER



Yes. CMISQL ANY generates a SQL EXISTS with a subquery on the given predicate (= for NOT IN here).

0 votes