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

DBT3 query #7 returns incorrect results

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Done
    • 1.5.1
    • N/A
    • ExeMgr
    • 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

              Unassigned Unassigned
              dleeyh Daniel Lee (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.