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

DBT3 query #10 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_custkey,
      c_name,
      sum(l_extendedprice * (1 - l_discount)) as revenue,
      c_acctbal,
      n_name,
      c_address,
      c_phone,
      c_comment
      from
      customer,
      orders,
      lineitem,
      nation
      where
      c_custkey = o_custkey
      and l_orderkey = o_orderkey
      and o_orderdate >= '1994-12-01'
      and o_orderdate < date_add( '1994-12-01' , interval 3 month)
      and l_returnflag = 'R'
      and c_nationkey = n_nationkey
      group by
      c_custkey,
      c_name,
      c_acctbal,
      c_phone,
      n_name,
      c_address,
      c_comment
      order by
      revenue desc
      LIMIT 20;

      ColumnStore returned:

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

      c_custkey c_name revenue c_acctbal n_name c_address c_phone c_comment

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

      95 Customer#000000095 138209.6028 5327.38 MOROCCO EU0xvmWvOmUUn5J,2z85DQyG7QCJ9Xq7 25-923-255-2929 ithely. ruthlessly final requests wake slyly alongside of the furiously silent pinto beans. even the
      113 Customer#000000113 117107.1886 2912.00 JAPAN eaOl5UBXIvdY57rglaIzqvfPD,MYfK 22-302-930-4756 usly regular theodolites boost furiously doggedly pending instructio
      52 Customer#000000052 94407.0535 5630.28 IRAQ 7 QOqGqqSy9jfV51BC71jcHJSD0 21-186-284-5998 ic platelets use evenly even accounts. stealthy theodolites cajole furiou
      124 Customer#000000124 80480.2608 1842.49 CHINA aTbyVAW5tCd,v09O 28-183-750-7809 le fluffily even dependencies. quietly s
      122 Customer#000000122 53607.8100 7865.46 CANADA yp5slqoNd26lAENZW3a67wSfXA6hTF 13-702-694-4520 the special packages hinder blithely around the permanent requests. bold depos
      133 Customer#000000133 50900.7590 2314.67 PERU IMCuXdpIvdkYO92kgDGuyHgojcUs88p 27-408-997-8430 t packages. express pinto beans are blithely along the unusual, even theodolites. silent packages use fu
      139 Customer#000000139 48305.0910 7897.78 INDONESIA 3ElvBwudHKL02732YexGVFVt 19-140-352-1403 nstructions. quickly ironic ideas are carefully. bold,
      100 Customer#000000100 46388.7744 9889.89 SAUDI ARABIA fptUABXcmkC5Wx 30-749-445-4907 was furiously fluffily quiet deposits. silent, pending requests boost against
      97 Customer#000000097 34023.7184 2164.48 PERU OApyejbhJG,0Iw3j rd1M 27-588-919-5638 haggle slyly. bold, special ideas are blithely above the thinly bold theo
      88 Customer#000000088 29371.8645 8031.44 MOZAMBIQUE wtkjBN9eyrFuENSMmMFlJ3e7jE5KXcg 26-516-273-2566 s are quickly above the quickly ironic instructions; even requests about the carefully final deposi
      61 Customer#000000061 21924.4050 1536.24 PERU 9kndve4EAJxhg3veF BfXr7AqOsT39o gtqjaYE 27-626-559-8599 egular packages shall have to impress along the
      35 Customer#000000035 13721.6970 1228.24 PERU TEjWGE4nBzJL2 27-566-888-7431 requests. special, express requests nag slyly furiousl
      148 Customer#000000148 8841.7920 2135.60 IRAQ BhSPlEWGvIJyT9swk vCWE 21-562-498-6636 ing to the carefully ironic requests. carefully regular dependencies about the theodolites wake furious
      91 Customer#000000091 6407.4458 4643.14 INDIA S8OMYFrpHwoNHaGBeuS6E 6zhHGZiprw1b7 q 18-239-400-3677 onic accounts. fluffily silent pinto beans boost blithely according to the fluffily exp

      ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
      14 rows in set (0.056 sec)

      InnoDB returned:

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

      c_custkey c_name revenue c_acctbal n_name c_address c_phone c_comment

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

      95 Customer#000000095 159993.5628 5327.38 MOROCCO EU0xvmWvOmUUn5J,2z85DQyG7QCJ9Xq7 25-923-255-2929 ithely. ruthlessly final requests wake slyly alongside of the furiously silent pinto beans. even the
      133 Customer#000000133 130454.2784 2314.67 PERU IMCuXdpIvdkYO92kgDGuyHgojcUs88p 27-408-997-8430 t packages. express pinto beans are blithely along the unusual, even theodolites. silent packages use fu
      49 Customer#000000049 122242.8362 4573.94 IRAN cNgAeX7Fqrdf7HQN9EwjUa4nxT,68L FKAxzl 20-908-631-4424 nusual foxes! fluffily pending packages maintain to the regular
      113 Customer#000000113 117107.1886 2912.00 JAPAN eaOl5UBXIvdY57rglaIzqvfPD,MYfK 22-302-930-4756 usly regular theodolites boost furiously doggedly pending instructio
      115 Customer#000000115 115503.9282 7508.92 INDIA 0WFt1IXENmUT2BgbsB0ShVKJZt0HCBCbFl0aHc 18-971-699-1843 sits haggle above the carefully ironic theodolite
      62 Customer#000000062 111701.0967 595.61 GERMANY upJK2Dnw13, 17-361-978-7059 kly special dolphins. pinto beans are slyly. quickly regular accounts are furiously a
      148 Customer#000000148 105971.4034 2135.60 IRAQ BhSPlEWGvIJyT9swk vCWE 21-562-498-6636 ing to the carefully ironic requests. carefully regular dependencies about the theodolites wake furious
      121 Customer#000000121 98942.3170 6428.32 PERU tv nCR2YKupGN73mQudO 27-411-990-2959 uriously stealthy ideas. carefully final courts use carefully
      52 Customer#000000052 94407.0535 5630.28 IRAQ 7 QOqGqqSy9jfV51BC71jcHJSD0 21-186-284-5998 ic platelets use evenly even accounts. stealthy theodolites cajole furiou
      134 Customer#000000134 91440.2266 4608.90 IRAQ sUiZ78QCkTQPICKpA9OBzkUp2FM 21-200-159-5932 yly fluffy foxes boost final ideas. b
      124 Customer#000000124 80480.2608 1842.49 CHINA aTbyVAW5tCd,v09O 28-183-750-7809 le fluffily even dependencies. quietly s
      89 Customer#000000089 74578.7108 1530.76 KENYA dtR, y9JQWUO6FoJExyp8whOU 24-394-451-5404 counts are slyly beyond the slyly final accounts. quickly final ideas wake. r
      142 Customer#000000142 73704.2692 2209.81 INDONESIA AnJ5lxtLjioClr2khl9pb8NLxG2, 19-407-425-2584 . even, express theodolites upo
      73 Customer#000000073 68108.4300 4288.50 ALGERIA 8IhIxreu4Ug6tt5mog4 10-473-439-3214 usual, unusual packages sleep busily along the furiou
      79 Customer#000000079 64295.2946 5121.28 MOROCCO n5hH2ftkVRwW8idtD,BmM2 25-147-850-4166 es. packages haggle furiously. regular, special requests poach after the quickly express ideas. blithely pending re
      118 Customer#000000118 60621.8265 3582.37 CHINA OVnFuHygK9wx3xpg8 28-639-943-7051 uick packages alongside of the furiously final deposits haggle above the fluffily even foxes. blithely dogged dep
      131 Customer#000000131 60393.0600 8595.53 IRAQ jyN6lAjb1FtH10rMC,XzlWyCBrg75 21-840-210-3572 jole special packages. furiously final dependencies about the furiously speci
      137 Customer#000000137 59509.9566 7838.30 MOZAMBIQUE cdW91p92rlAEHgJafqYyxf1Q 26-777-409-5654 carefully regular theodolites use. silent dolphins cajo
      122 Customer#000000122 53607.8100 7865.46 CANADA yp5slqoNd26lAENZW3a67wSfXA6hTF 13-702-694-4520 the special packages hinder blithely around the permanent requests. bold depos
      139 Customer#000000139 48305.0910 7897.78 INDONESIA 3ElvBwudHKL02732YexGVFVt 19-140-352-1403 nstructions. quickly ironic ideas are carefully. bold,

      -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
      20 rows in set (0.051 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: