search

alibaba / druid

阿里云计算平台DataWorks(https://help.aliyun.com/document_detail/137663.html) 团队出品，为监控而生的数据库连接池
https://github.com/alibaba/druid/wiki
Apache License 2.0
27.78k stars 8.55k forks source link

使用Oracle的LISTAGG(memo, ',' ON OVERFLOW TRUNCATE)时报错 #5189

Open NRMrYang opened 1 year ago

NRMrYang commented 1 year ago

报错信息：java.sql.SQLException: sql injection violation, dbType oracle, , druid-version 1.2.12, syntax error: syntax error, expect ), actual ON pos 547, line 17, column 48, token ON

是不支持这个语法吗？

NRMrYang commented 1 year ago

应该是不支持了，换了最新版1.2.16的也不行

NRMrYang commented 1 year ago

为什么要使用这个语法，请见Oracle的文档 https://docs.oracle.com/en/database/oracle/oracle-database/19/tutorial-avoid-errors-listagg-function/index.html