Build tested: 1.5.0-1 (drone build #120)

database: dbt3 1mb
query:

select
nation,
o_year,
sum(amount) as sum_profit
from
(
select
n_name as nation,
year(o_orderdate) as o_year,
l_extendedprice * (1 - l_discount) - ps_supplycost * l_quantity as amount
from
part,
supplier,
lineitem,
partsupp,
orders,
nation
where
s_suppkey = l_suppkey
and ps_suppkey = l_suppkey
and ps_partkey = l_partkey
and p_partkey = l_partkey
and o_orderkey = l_orderkey
and s_nationkey = n_nationkey
and p_name like '%gainsboro%'
) as profit
group by
nation,
o_year
order by
nation,
o_year desc;

ColumnStore returned:

51 rows
sum_profile column values in returned rows are also incorrect

---------------------------------

---------------------------------

.
.

InnoDB returned:

62 rows

---------------------------------

---------------------------------

.
.