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

DBT3 query #9 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 1mb
      query:

      select
      nation,
      o_year,
      sum(amount) as sum_profit
      from
      (
      select
      n_name as nation,
      year(o_orderdate) as o_year,
      l_extendedprice * (1 - l_discount) - ps_supplycost * l_quantity as amount
      from
      part,
      supplier,
      lineitem,
      partsupp,
      orders,
      nation
      where
      s_suppkey = l_suppkey
      and ps_suppkey = l_suppkey
      and ps_partkey = l_partkey
      and p_partkey = l_partkey
      and o_orderkey = l_orderkey
      and s_nationkey = n_nationkey
      and p_name like '%gainsboro%'
      ) as profit
      group by
      nation,
      o_year
      order by
      nation,
      o_year desc;

      ColumnStore returned:

      51 rows
      sum_profile column values in returned rows are also incorrect

      ---------------------------------

      nation o_year sum_profit

      ---------------------------------

      ARGENTINA 1998 13789.3675
      ARGENTINA 1997 39231.2708
      ARGENTINA 1996 26622.2065

      .
      .

      InnoDB returned:

      62 rows

      ---------------------------------

      nation o_year sum_profit

      ---------------------------------

      ARGENTINA 1998 46383.6615
      ARGENTINA 1997 59845.8944
      ARGENTINA 1996 48629.9245

      .
      .

      Attachments

        Issue Links

          Activity

            People

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