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

DBT3 query #16 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
      p_brand,
      p_type,
      p_size,
      count(distinct ps_suppkey) as supplier_cnt
      from
      partsupp,
      part
      where
      p_partkey = ps_partkey
      and p_brand <> 'Brand#25'
      and p_type not like 'MEDIUM BRUSHED%'
      and p_size in (1, 37, 22, 30, 12, 26, 39, 43)
      and ps_suppkey not in (
      select
      s_suppkey
      from
      supplier
      where
      s_comment like '%Customer%Complaints%'
      )
      group by
      p_brand,
      p_type,
      p_size
      order by
      supplier_cnt desc,
      p_brand,
      p_type,
      p_size;

      ColumnStore returned:

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

      p_brand p_type p_size supplier_cnt

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

      Brand#11 ECONOMY ANODIZED STEEL 26 4
      Brand#14 SMALL ANODIZED TIN 26 4
      Brand#32 PROMO ANODIZED STEEL 1 4
      Brand#35 STANDARD BRUSHED BRASS 39 4
      Brand#41 PROMO BRUSHED NICKEL 43 4
      Brand#43 LARGE POLISHED STEEL 30 4

      --------------------------------------------------+
      6 rows in set (0.053 sec)

      InnoDB returned:

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

      p_brand p_type p_size supplier_cnt

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

      Brand#11 ECONOMY ANODIZED STEEL 26 4
      Brand#11 ECONOMY ANODIZED TIN 1 4
      Brand#13 LARGE BRUSHED BRASS 1 4
      Brand#14 SMALL ANODIZED TIN 26 4
      Brand#21 MEDIUM ANODIZED BRASS 1 4
      Brand#23 SMALL PLATED NICKEL 26 4
      Brand#32 LARGE ANODIZED STEEL 26 4
      Brand#32 PROMO ANODIZED STEEL 1 4
      Brand#33 STANDARD PLATED BRASS 26 4
      Brand#35 SMALL BURNISHED NICKEL 39 4
      Brand#35 STANDARD BRUSHED BRASS 39 4
      Brand#41 PROMO BRUSHED NICKEL 43 4
      Brand#43 LARGE POLISHED STEEL 30 4
      Brand#43 SMALL BURNISHED STEEL 12 4
      Brand#45 PROMO ANODIZED BRASS 22 4
      Brand#53 SMALL BURNISHED TIN 12 4
      Brand#54 MEDIUM POLISHED BRASS 22 4
      Brand#54 STANDARD ANODIZED BRASS 22 4
      Brand#55 MEDIUM BURNISHED NICKEL 1 4
      Brand#52 STANDARD ANODIZED BRASS 43 2
      Brand#53 SMALL POLISHED TIN 43 2
      Brand#15 ECONOMY POLISHED TIN 12 1
      Brand#44 STANDARD PLATED TIN 37 1
      Brand#45 SMALL ANODIZED NICKEL 26 1

      ---------------------------------------------------+
      24 rows in set (0.012 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: