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

Bug 1279473

Summary: Informix translator - <> ALL is translated as NOT IN - this statement seem to not work in Infromix
Product: [JBoss] JBoss Data Virtualization 6 Reporter: Juraj Duráni <jdurani>
Component: TeiidAssignee: David Le Sage <dlesage>
Status: CLOSED CURRENTRELEASE QA Contact: Juraj Duráni <jdurani>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 6.2.0CC: vhalbert
Target Milestone: GA   
Target Release: 6.3.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
There is an issue with the Informix translator whereby neither neither '<> ALL' or 'NOT IN' works in a query. You must avoid using these statements in your commands.
 Story Points: ---
Clone Of: Environment:
Last Closed: 2016-08-24 11:41:52 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 2015-11-09 14:31:52 UTC 
Query:
SELECT INTKEY, BOOLEANVALUE FROM BQT1.SMALLA WHERE BOOLEANVALUE <> ALL (SELECT BOOLEANVALUE FROM BQT1.SMALLA WHERE INTKEY = 40)

Source-specific command:
SELECT g_0.IntKey, g_0.BooleanValue FROM Source.SmallA AS g_0 WHERE g_0.BooleanValue NOT IN (SELECT g_1.BooleanValue FROM Source.SmallA AS g_1 WHERE g_1.IntKey = 40)

*Note: boolean value for row where Intkey = 40 is false.*

Expected result:
|intkey|booleanvalue|
|1|true|
|...|...|

Actual result:
|intkey|booleanvalue|
|1|false|
|...|...|

This seems to be an Informix issue as neither '<> ALL' nor 'NOT IN' works.
Comment 1 JBoss JIRA Server 2016-01-29 14:58:56 UTC 
Steven Hawkins <shawkins> updated the status of jira TEIID-3816 to Resolved
Comment 2 Van Halbert 2016-02-08 14:04:36 UTC 
This will need to be release noted.
Comment 3 JBoss JIRA Server 2016-06-03 22:33:59 UTC 
Steven Hawkins <shawkins> updated the status of jira TEIID-3816 to Closed
Comment 4 David Le Sage 2016-08-09 03:01:27 UTC 
Added to release notes.  

URL:  https://access.qa.redhat.com/documentation/en/red-hat-jboss-data-virtualization/6.3/single/release-notes