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

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

XMLWordPrintable

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

      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

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

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

              Created:
              Updated:
              Resolved: