Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-3816

Informix translator - <> ALL is translated as NOT IN - this statement seem to not work in Infromix

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Won't Do
    • Icon: Major Major
    • None
    • 8.7.2.6_2
    • None
    • None

      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
      0 false
      ... ...

      This seems to be an Informix issue as neither '<> ALL' nor 'NOT IN' works.

            rhn-engineering-shawkins Steven Hawkins
            jdurani Juraj Duráni (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: