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

DBT3 query 7 returned an empty result set

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 1.0.1
    • 1.0.2
    • ExeMgr
    • None

    Description

      Build tested: alpha 1.0.1

      mscadmin> getsoft
      getsoftwareinfo Fri Jul 1 18:33:11 2016

      Name : mariadb-columnstore-platform
      Version : 1.0
      Release : 1
      Architecture: x86_64
      Install Date: Fri 24 Jun 2016 07:28:00 PM UTC

      Create a DBT3 (TPCH) database and load 1gb of data

      execute the query #7

      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;

      The same query on InnoDB returned:

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

      supp_nation cust_nation l_year revenue

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

      ETHIOPIA JORDAN 1995 54454793.4142
      ETHIOPIA JORDAN 1996 49143119.7914
      JORDAN ETHIOPIA 1995 49447292.2659
      JORDAN ETHIOPIA 1996 46573682.6700

      -------------------------------------------+
      4 rows in set (15.88 sec)

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              dleeyh Daniel Lee (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.