执行
select sys_connect_by_path(CODE ,'/') AS comcodePath from T_USER
where CODE = ? start with CODE = '00000' connect by prior CODE = UPPERCODE
报错,可能是druid的版本不支持 start with 语法
com.alibaba.druid.sql.parser.ParserException: syntax error, expect RPAREN, actual WITH with
at com.alibaba.druid.sql.parser.SQLExprParser.accept(SQLExprParser.java:1626) ~[druid-1.0.21.jar:1.0.21]
at com.alibaba.druid.sql.parser.SQLExprParser.inRest(SQLExprParser.java:1213) ~[druid-1.0.21.jar:1.0.21]
at com.alibaba.druid.sql.parser.SQLExprParser.exprRest(SQLExprParser.java:140) ~[druid-1.0.21.jar:1.0.21]
at com.alibaba.druid.sql.parser.SQLExprParser.expr(SQLExprParser.java:130) ~[druid-1.0.21.jar:1.0.21]
at com.alibaba.druid.sql.parser.SQLExprParser.primary(SQLExprParser.java:231) ~[druid-1.0.21.jar:1.0.21]
at com.alibaba.druid.sql.dialect.mysql.parser.MySqlExprParser.primary(MySqlExprParser.java:167) ~[druid-1.0.21.jar:1.0.21]
at com.alibaba.druid.sql.parser.SQLExprParser.expr(SQLExprParser.java:124) ~[druid-1.0.21.jar:1.0.21]
at com.alibaba.druid.sql.parser.SQLExprParser.primary(SQLExprParser.java:231) ~[druid-1.0.21.jar:1.0.21]
at com.alibaba.druid.sql.dialect.mysql.parser.MySqlExprParser.primary(MySqlExprParser.java:167) ~[druid-1.0.21.jar:1.0.21]
at com.alibaba.druid.sql.parser.SQLExprParser.bitXor(SQLExprParser.java:150) ~[druid-1.0.21.jar:1.0.21]
at com.alibaba.druid.sql.parser.SQLExprParser.multiplicative(SQLExprParser.java:187) ~[druid-1.0.21.jar:1.0.21]
at com.alibaba.druid.sql.parser.SQLExprParser.additive(SQLExprParser.java:1238) ~[druid-1.0.21.jar:1.0.21]
at com.alibaba.druid.sql.parser.SQLExprParser.shift(SQLExprParser.java:1266) ~[druid-1.0.21.jar:1.0.21]
at com.alibaba.druid.sql.parser.SQLExprParser.bitAnd(SQLExprParser.java:1144) ~[druid-1.0.21.jar:1.0.21]
at com.alibaba.druid.sql.parser.SQLExprParser.bitOr(SQLExprParser.java:1158) ~[druid-1.0.21.jar:1.0.21]
at com.alibaba.druid.sql.parser.SQLExprParser.equality(SQLExprParser.java:1173) ~[druid-1.0.21.jar:1.0.21]