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

DBT3 query 8 returned an empty result set

    XMLWordPrintable

Details

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

    Description

      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 #8

      select
      o_year,
      sum(case
      when nation = 'UNITED STATES' then volume
      else 0
      end) / sum(volume) as mkt_share
      from
      (
      select
      year(o_orderdate) as o_year,
      l_extendedprice * (1 - l_discount) as volume,
      n2.n_name as nation
      from
      part,
      supplier,
      lineitem,
      orders,
      customer,
      nation n1,
      nation n2,
      region
      where
      p_partkey = l_partkey
      and s_suppkey = l_suppkey
      and l_orderkey = o_orderkey
      and o_custkey = c_custkey
      and c_nationkey = n1.n_nationkey
      and n1.n_regionkey = r_regionkey
      and r_name = 'AMERICA'
      and s_nationkey = n2.n_nationkey
      and o_orderdate between date('1995-01-01') and date ('1996-12-31')
      and p_type = 'LARGE PLATED COPPER'
      ) as all_nations
      group by
      o_year
      order by
      o_year;

      The same query on InnoDB returned:

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

      o_year mkt_share

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

      1995 0.04715849
      1996 0.05004456

      ------------------+
      2 rows in set (54.77 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.