Details
-
Bug
-
Resolution: Done
-
Major
-
8.12.x
-
None
Description
Some comparison conditions are not supported in Redshift with ANY, SOME and ALL.
ALL:
Query: SELECT INTKEY FROM Source.SMALLA WHERE INTKEY > ALL (SELECT INTKEY FROM Source.SMALLA WHERE INTKEY < 45)
Exception message: Caused by: org.postgresql.util.PSQLException: ERROR: ALL with <, >, <=, >=, or = comparison condition is not supported
ANY:
Query: SELECT INTKEY FROM Source.SMALLA WHERE INTKEY > ANY (SELECT INTKEY FROM Source.SMALLA WHERE INTKEY < 45)
Exception message: Caused by: org.postgresql.util.PSQLException: ERROR: ANY or SOME with <, >, <=, >=, <>, or != comparison condition is not supported