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

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

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