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

DBT3 query #3 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 1m
      query:

      select l_orderkey, sum(l_extendedprice * (1 - l_discount)) as revenue, o_orderdate, o_shippriority from customer, orders, lineitem where c_mktsegment = 'HOUSEHOLD' and c_custkey = o_custkey and l_orderkey = o_orderkey and o_orderdate < '1995-03-08' and l_shipdate > '1995-03-08' group by l_orderkey, o_orderdate, o_shippriority order by revenue desc, o_orderdate LIMIT 10;

      ColumnStore returns:

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

      l_orderkey revenue o_orderdate o_shippriority

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

      4642 113368.5066 1995-02-27 0
      5636 113146.8615 1995-02-16 0
      5765 110724.4206 1994-12-15 0
      3488 87547.7002 1995-01-08 0
      3749 83734.8686 1995-02-24 0
      3399 54194.5041 1995-02-28 0

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

      InnoDB returns:

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

      l_orderkey revenue o_orderdate o_shippriority

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

      4642 113368.5066 1995-02-27 0
      5636 113146.8615 1995-02-16 0
      5765 110724.4206 1994-12-15 0
      930 91306.5124 1994-12-17 0
      3488 87547.7002 1995-01-08 0
      4485 85152.1824 1994-11-13 0
      3749 83734.8686 1995-02-24 0
      3399 54194.5041 1995-02-28 0
      1445 44384.8914 1995-01-10 0
      4290 25150.2663 1995-01-15 0

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

      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.