feature: Added support for simple CAST by mlilius · Pull Request #39 · JavaScriptor/js-sql-parser

albin3

This will not handle all versions of CAST but will handle a simple case like CAST(pct*100 AS int)

select
    concat(dsw_cluster_name,',',logic_pod_name) as event_obj,
    concat(dsw_cluster_name,',',logic_pod_name, ' PFC STORM. 详情: ',
    '流量突跃 ',
    cast(FLOW_RX_BPS_RATE100 as int),
    '%(RX)',
    '; ',
    cast(FLOW_TX_BPS_RATE100 as int),
    '%(TX)',
    '; PFC 突增 ',
    cast(PFC_RX_PPS_RATE*100 as int),
    '%(RECV)') as brief
from SOURCE_BASIC_EVENT_POD_FLOW_AND_PFC_TREND
where win_end >= '2020-05-19 21:14:12'
    and win_end < '2020-05-20 21:14:12'
    and PFC_RX_PPS_RATE >= 100
    and (FLOW_RX_BPS_RATE <= -0.2 and FLOW_TX_BPS_RATE <= -0.2)