[ https://issues.jboss.org/browse/TEIID-3816?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3816: ---------------------------------- Description: 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| |0|false| |...|...| This seems to be an Informix issue as neither '<> ALL' nor 'NOT IN' works. was: 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)