Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1334306

Summary: Redshift - some comparison conditions are not supported with ANY, SOME and ALL
Product: [JBoss] JBoss Data Virtualization 6 Reporter: Juraj Duráni <jdurani>
Component: TeiidAssignee: Van Halbert <vhalbert>
Status: CLOSED CURRENTRELEASE QA Contact: Juraj Duráni <jdurani>
Severity: medium Docs Contact:
Priority: medium    
Version: 6.3.0CC: aszczucz, blafond, jolee, mbaluch, thauser, vhalbert
Target Milestone: ER4   
Target Release: 6.3.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2016-08-24 11:36:34 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Juraj Duráni 2016-05-09 11:16:44 UTC 
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
Comment 1 JBoss JIRA Server 2016-05-10 18:36:18 UTC 
Steven Hawkins <shawkins> updated the status of jira TEIID-4197 to Resolved
Comment 2 JBoss JIRA Server 2016-06-15 12:14:15 UTC 
Steven Hawkins <shawkins> updated the status of jira TEIID-4197 to Closed