[jira] [Created] (KYLIN-3297) sql在解析>大值 and <小值的时候，kylin出现内存溢出。

["陈家宇 (JIRA)" <ji...@apache.org>]

陈家宇 created KYLIN-3297:
--------------------------

             Summary: sql在解析>大值 and <小值的时候，kylin出现内存溢出。
                 Key: KYLIN-3297
                 URL: https://issues.apache.org/jira/browse/KYLIN-3297
             Project: Kylin
          Issue Type: Bug
          Components: RDBMS Source
    Affects Versions: v2.2.0
         Environment: oracle linux 6.8  
cup 8C
memory 48G
apache kylin v2.2.0
            Reporter: 陈家宇


select f.plant_code,f.report_business_area,f.orderby,sum(f.a)a,
case when sum(f.a)=0 then 0 else sum(f.qty)/sum(f.a) end zt from (
select h.business_area_desc,h.plant_code,
 case when p.report_business_area like '%切大片%' then '切大片'
 else p.report_business_area end report_business_area,
  case when p.report_business_area like '%切大片%' then '00'
 else p.orderby end orderby,
sum(p.quantity) qty,sum(a)a from pkn_kpi p
inner join hcm_area h on p.plant_id=h.plant_id
where 1=1
 and h.business_area_desc='上海'
 and h.plant_code='S1'
 and p.calendar_day>='2018-03-19'
 and p.calendar_day<='2018-03-18'
and trim(p.report_business_area) is not null
group by h.business_area_desc,h.plant_code,p.report_business_area,p.orderby
) f
group by f.plant_code,f.report_business_area,f.orderby
order by orderby

以上的calendar_day条件，顺序输入反了，变成calendar_day>大值 and calendar_day<小值，出现了kylin内存溢出，并且崩溃。正常这种情况是没有数据输出才对。

 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)