Description
Always check against the Latest SNAPSHOT of JSQLParser and the Syntax Diagram
Failing SQL Feature:
- net.sf.jsqlparser.JSQLParserException: Time out occurred.
SQL Example:
select
SUM(ge_deal_standard_deal_ord_amt) as SUM_4ff219f1b0ffdffcab3b46688ac2ad0e,
saler_bu_id as saler_bu_id_WIQxWjwV,
if(platform_cate_1 = 'app',
'app',
'非app') as 是否app_NNUiKnkP,
(case
when (((case
when ((platform_cate_1 in ('app', 'pc')
and platform_cate_1 is not null
and platform_cate_1 != '')) then 'app_pc渠道'
when ((platform_cate_1 not in ('app', 'pc')
and platform_cate_1 is not null
and platform_cate_1 != '')) then '非app_pc渠道'
else '未知渠道'
end) like '%app%')) then '正规渠道'
when (((case
when ((platform_cate_1 in ('app', 'pc')
and platform_cate_1 is not null
and platform_cate_1 != '')) then 'app_pc渠道'
when ((platform_cate_1 not in ('app', 'pc')
and platform_cate_1 is not null
and platform_cate_1 != '')) then '非app_pc渠道'
else '未知渠道'
end) like '%pc%')) then '正规渠道'
else '非正规渠道'
end) as 是否正规渠道_eeZy3xqg
from
base_detail8909
group by
saler_bu_id,
if(platform_cate_1 = 'app',
'app',
'非app'),
(case
when (((case
when ((platform_cate_1 in ('app', 'pc')
and platform_cate_1 is not null
and platform_cate_1 != '')) then 'app_pc渠道'
when ((platform_cate_1 not in ('app', 'pc')
and platform_cate_1 is not null
and platform_cate_1 != '')) then '非app_pc渠道'
else '未知渠道'
end) like '%app%')) then '正规渠道'
when (((case
when ((platform_cate_1 in ('app', 'pc')
and platform_cate_1 is not null
and platform_cate_1 != '')) then 'app_pc渠道'
when ((platform_cate_1 not in ('app', 'pc')
and platform_cate_1 is not null
and platform_cate_1 != '')) then '非app_pc渠道'
else '未知渠道'
end) like '%pc%')) then '正规渠道'
else '非正规渠道'
end)
Software Information:
- JSqlParser version v4.9
I use findTables method for this sql but timeout
like this :
TablesNamesFinder.findTables(sql)