Hi developers!
I'm working on 2.x-staging commit
id:8fd28370a01f570f501927164f3dae2d0ca729e7
I change some cube desc : add some measures
When I running IT test. got a strange error:
Failed tests:
ITIIQueryTest>ITKylinQueryTest.testCommonQuery:127->KylinTestBase.execAndCompQuery:400
Incompatible data types: (table=query result of query10,
col=TOTAL_ITEMS) expected:<[DECIMAL]> but was:<[BIGINT]>
ITIIQueryTest>ITKylinQueryTest.testCommonQuery:127->KylinTestBase.execAndCompQuery:400
Incompatible data types: (table=query result of query10,
col=TOTAL_ITEMS) expected:<[DECIMAL]> but was:<[BIGINT]>
the query10 sql is:
select test_cal_dt.week_beg_dt,sum(test_kylin_fact.price) as GMV
, count(*) as TRANS_CNT , *sum(test_kylin_fact.item_count) as total_items*
from test_kylin_fact
inner JOIN edw.test_cal_dt as test_cal_dt
ON test_kylin_fact.cal_dt = test_cal_dt.cal_dt
inner JOIN test_category_groupings
ON test_kylin_fact.leaf_categ_id =
test_category_groupings.leaf_categ_id AND test_kylin_fact.lstg_site_id =
test_category_groupings.site_id
inner JOIN edw.test_sites as test_sites
ON test_kylin_fact.lstg_site_id = test_sites.site_id
where test_kylin_fact.lstg_format_name='FP-GTC'
and test_cal_dt.week_beg_dt between '2013-05-01' and DATE '2013-08-01'
group by test_cal_dt.week_beg_dt
Why the column bigint sum in H2 database return decimal type? Any one
meet the same problem?
