Database Type
Oracle
Database Version
Oracle
Druid Version
1.2.23
JDK Version
JDK 8
Error SQL
原始sql里有个max((SELECT a.vc_currency_name FROM tcurrencyinfo a WHERE a.vc_currency_no = d.VC_TRADE_CURRENCY_NO)) vc_currency_name,原始的sql是能在oracle客户端执行的。
经过Druid框架处理后,变成了max(SELECT a.vc_currency_name FROM tcurrencyinfo a WHERE a.vc_currency_no = d.VC_TRADE_CURRENCY_NO) AS vc_currency_name,导致执行失败,java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
Testcase Code
No response
Stacktrace Info
No response
Error Info
No response