[teiid-issues] [JBoss JIRA] (TEIID-3816) Informix translator - <> ALL is translated as NOT IN - this statement seem to not work in Infromix

[Juraj Duráni (JIRA)]

Juraj Duráni created TEIID-3816:
-----------------------------------

             Summary: Informix translator - <> ALL is translated as NOT IN - this statement seem to not work in Infromix
                 Key: TEIID-3816
                 URL: https://issues.jboss.org/browse/TEIID-3816
             Project: Teiid
          Issue Type: Bug
    Affects Versions: 8.7.2.6_2
            Reporter: Juraj Duráni
            Assignee: Steven Hawkins


Query:
{code:sql}
SELECT INTKEY, BOOLEANVALUE FROM BQT1.SMALLA WHERE BOOLEANVALUE <> ALL (SELECT BOOLEANVALUE FROM BQT1.SMALLA WHERE INTKEY = 40)
{code}
Source-specific command:
{code:sql}
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)
{code}

*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. 



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)