Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-4076

DBT3 query #7 returns incorrect results

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: 1.5.0
    • Fix Version/s: N/A
    • Component/s: ExeMgr
    • Labels:
      None

      Description

      Build tested: 1.5.0-1 (drone build #120)

      database: dbt3 1 mb
      query:

      select
      supp_nation,
      cust_nation,
      l_year,
      sum(volume) as revenue
      from
      (
      select
      n1.n_name as supp_nation,
      n2.n_name as cust_nation,
      year(l_shipdate) as l_year,
      l_extendedprice * (1 - l_discount) as volume
      from
      supplier,
      lineitem,
      orders,
      customer,
      nation n1,
      nation n2
      where
      s_suppkey = l_suppkey
      and o_orderkey = l_orderkey
      and c_custkey = o_custkey
      and s_nationkey = n1.n_nationkey
      and c_nationkey = n2.n_nationkey
      and (
      (n1.n_name = 'ETHIOPIA' and n2.n_name = 'JORDAN')
      or (n1.n_name = 'JORDAN' and n2.n_name = 'ETHIOPIA')
      )
      and l_shipdate between date('1995-01-01') and date('1996-12-31')
      ) as shipping
      group by
      supp_nation,
      cust_nation,
      l_year
      order by
      supp_nation,
      cust_nation,
      l_year;

      ColumnStore returned:

      Empty set (0.154 sec)

      InnoDB returned:

      -----------------------------------------+

      supp_nation cust_nation l_year revenue

      -----------------------------------------+

      ETHIOPIA JORDAN 1995 166340.5850
      ETHIOPIA JORDAN 1996 23071.9992

      -----------------------------------------+
      2 rows in set (0.052 sec)

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              dleeyh Daniel Lee
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: