js-sql-parser
js-sql-parser copied to clipboard
Support CAST clause
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: {…}}
Cast function is not supported currently.
to support: https://dev.mysql.com/doc/refman/5.7/en/cast-functions.html