Bug 1334306 - Redshift - some comparison conditions are not supported with ANY, SOME and ALL
Summary: Redshift - some comparison conditions are not supported with ANY, SOME and ALL
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: JBoss Data Virtualization 6
Classification: JBoss
Component: Teiid
Version: 6.3.0
Hardware: Unspecified
OS: Unspecified
medium
medium
Target Milestone: ER4
: 6.3.0
Assignee: Van Halbert
QA Contact: Juraj Duráni
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2016-05-09 11:16 UTC by Juraj Duráni
Modified: 2016-08-24 11:36 UTC (History)
6 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2016-08-24 11:36:34 UTC
Type: Bug
Embargoed:

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker TEIID-4197 0 Major Closed Redshift - some comparison conditions are not supported with ANY, SOME and ALL 2016-06-15 12:14:14 UTC

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
Note You need to log in before you can comment on or make changes to this bug.