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

Netezza translator using INTNNOT when it should use INT4NOT

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Done
    • 7.6
    • 7.7, 8.0
    • Query Engine
    • None

    Description

      This was found during query testing. The query in question is RDBMS_Test_Queries_5700_TestQuery153.

      With Netezza as the source, this query:
      SELECT IntKey, BITNOT(IntKey) as BitPart FROM BQT1.SmallA ORDER BY IntKey

      Produces:
      Caught SQLException:
      Error Code:1100 Message:Remote org.teiid.core.TeiidProcessingException: Error Code:1100 Message:Source: Error Code:1100 Message:'ERROR: Function 'INTNNOT(INT4)' does not exist
      Unable to identify a function that satisfies the given argument types
      You may need to add explicit typecasts
      ' error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."INTKEY" AS c_0, intNnot(g_0."INTKEY") AS c_1 FROM "SMALLA" AS g_0 ORDER BY c_0]

      Dev responded with:
      [It appears] this should be calling INT4NOT. The Netezza users guide is a little unclear.

      More queries failing in a similar fashion:
      SELECT IntKey, BITXOR(IntKey, 1010) as BitPart FROM BQT1.SmallA ORDER BY IntKey
      Caught SQLException:
      Error Code:1100 Message:Remote org.teiid.core.TeiidProcessingException: Error Code:1100 Message:Source: Error Code:1100 Message:'ERROR: Function 'INTNXOR(INT4, INT4)' does not exist
      Unable to identify a function that satisfies the given argument types
      You may need to add explicit typecasts
      ' error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."INTKEY" AS c_0, intNxor(g_0."INTKEY", 1010) AS c_1 FROM "SMALLA" AS g_0 ORDER BY c_0]

      SELECT IntKey, BITOR(IntKey, 1010) as BitPart FROM BQT1.SmallA ORDER BY IntKey
      Caught SQLException:
      Error Code:1100 Message:Remote org.teiid.core.TeiidProcessingException: Error Code:1100 Message:Source: Error Code:1100 Message:'ERROR: Function 'INTNOR(INT4, INT4)' does not exist
      Unable to identify a function that satisfies the given argument types
      You may need to add explicit typecasts
      ' error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."INTKEY" AS c_0, intNor(g_0."INTKEY", 1010) AS c_1 FROM "SMALLA" AS g_0 ORDER BY c_0]

      SELECT IntKey, BITAND(IntKey, 1010) as BitPart FROM BQT1.SmallA ORDER BY IntKey
      Caught SQLException:
      Error Code:1100 Message:Remote org.teiid.core.TeiidProcessingException: Error Code:1100 Message:Source: Error Code:1100 Message:'ERROR: Function 'INTNAND(INT4, INT4)' does not exist
      Unable to identify a function that satisfies the given argument types
      You may need to add explicit typecasts
      ' error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."INTKEY" AS c_0, intNand(g_0."INTKEY", 1010) AS c_1 FROM "SMALLA" AS g_0 ORDER BY c_0]

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            pnittel_jira Paul Nittel (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: