Relate Query throws exception when OR is part of WHERE clause in MetaMatrix
Issue
- I'm running a MetaMatrix relate query with a mixture of AND and OR in the WHERE criteria, but I receive the below error message:
[14:08:03] SQL9: SQL Submitted to Server
[14:08:09] SQL9: Exception running query: Multiple predicates in one conjunct use a mixture of explicit and implicit context criteria with use of relate function
- If I use all AND's the query is successful.
Environment
- MetaMatrix Enterprise Server 5.5.x
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.