Support CAST clause

[DragonFly666]

code

---

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 >= '${yyyy-MM-dd HH:mm:ss - 2m}'
and win_end < '${yyyy-MM-dd HH:mm:ss}'
and PFC_RX_PPS_RATE >= 100
and (FLOW_RX_BPS_RATE <= -0.2 and FLOW_TX_BPS_RATE <= -0.2)

error like this
{message: "Parse error on line 4:↵...LOW_RX_BPS_RATE*100 as i…,', ')', 'AND', '&&', '||', 'OR', 'XOR', got 'AS'", hash: {…}}

[albin3]

Cast function is not supported currently.

to support: https://dev.mysql.com/doc/refman/5.7/en/cast-functions.html