js-sql-parser icon indicating copy to clipboard operation
js-sql-parser copied to clipboard

Support CAST clause

Open DragonFly666 opened this issue 7 years ago • 1 comments

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: {…}}

DragonFly666 avatar Mar 06 '18 11:03 DragonFly666

Cast function is not supported currently.

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

albin3 avatar Mar 06 '18 11:03 albin3