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

DBT3 query #13 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
      c_count,
      count as custdist
      from
      (
      select
      c_custkey,
      count(o_orderkey) as c_count
      from
      customer left outer join orders on
      c_custkey = o_custkey
      and o_comment not like '%special%requests%'
      group by
      c_custkey
      ) as c_orders
      group by
      c_count
      order by
      custdist desc,
      c_count desc;

      ColumnStore returned:

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

      c_count custdist

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

      0 109
      7 6
      6 5
      5 5
      12 4
      9 4
      4 3
      3 3
      14 2
      10 2
      8 2
      17 1
      15 1
      11 1
      2 1
      1 1

      -----------------+
      16 rows in set (0.051 sec)

      InnoDB returned:

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

      c_count custdist

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

      0 50
      16 8
      17 7
      20 6
      13 6
      12 6
      9 6
      23 5
      14 5
      10 5
      21 4
      18 4
      11 4
      8 4
      7 4
      26 3
      22 3
      6 3
      5 3
      4 3
      29 2
      24 2
      19 2
      15 2
      28 1
      25 1
      3 1

      -----------------+
      27 rows in set (0.115 sec)

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                Created:
                Updated:
                Resolved: