druid SQLUtils.parseStatements解析ADS sql异常

0pizxfdo  于 4个月前  发布在  Druid
关注(0)|答案(2)|浏览(69)

下面sql在ADB中执行没问题,通过SQLUtils.parseStatements解析异常,dbType 选择ALIYUN_ADS、MYSQL 都不行

sql如下:

SELECT t1.col2, t1.col3, t2.col FROM ( SELECT split ( col1, '\\|' ) AS x, col2, col3 FROM table1 ) t1 CROSS JOIN unnest ( t1.x ) AS t2 ( col ) ORDER BY t1.col2;

异常:

com.alibaba.druid.sql.parser.ParserException: TODO pos 159, line 14, column 37, token IDENTIFIER col at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:413) at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:72) at com.alibaba.druid.sql.SQLUtils.parseStatements(SQLUtils.java:464)

7rtdyuoh

7rtdyuoh1#

收到,我来处理一下;
PS:ALIYUN_ADS已经不推荐使用,建议是用MySQL;

3duebb1j

3duebb1j2#

收到,我来处理一下;
PS:ALIYUN_ADS已经不推荐使用,建议是用MySQL;

感谢, 请问预计会在什么时候有新的版本?

相关问题