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

Getting Assertion when running Inner Merge Join query with SELECT COUNT(*) on top

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 7.7, 8.0
    • 7.4.1
    • Query Engine
    • None

    Description

      When running the following query, it causing an ASSERTION (see attached log):

      SELECT COUNT AS CNT FROM (SELECT ORDERS.O_ORDERKEY, ORDERS.O_ORDERDATE, ORDERS.O_CLERK, CUSTOMER.C_CUSTKEY, CUSTOMER.C_NAME, CUSTOMER.C_ACCTBAL
      FROM TPCR01_PostgreSQLVirt.ORDERS, TPCR01_OracleVirt.CUSTOMER WHERE (CUSTOMER.C_CUSTKEY = ORDERS.O_CUSTKEY) AND
      (ORDERS.O_ORDERDATE < '1992-01-05 00:00:00') AND (CUSTOMER.C_ACCTBAL < 9514.5)) AS T

      Note: this doesn't fail when SELECT COUNT isn't used

      Attachments

        1. oracle11-ds.xml
          1 kB
        2. postgres-8.4-tpcr01-ds.xml
          2 kB
        3. server_with_error.log
          264 kB
        4. TPC.vdb
          50 kB

        Issue Links

          Activity

            People

              rhn-engineering-shawkins Steven Hawkins
              van.halbert Van Halbert (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: