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

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

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

                Dates

                Created:
                Updated:
                Resolved: