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:<24> SQL Submitted to Server
[14:08:09] SQL9:<24> 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 of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
