You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
原始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
The text was updated successfully, but these errors were encountered:
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
The text was updated successfully, but these errors were encountered: