Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[BUG] oracle sql: max(())方法经过Druid处理后变成了max(),导致sql执行失败。 #6387

Open
zlj0123 opened this issue Mar 26, 2025 · 1 comment

Comments

@zlj0123
Copy link

zlj0123 commented Mar 26, 2025

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

@changluya
Copy link

补个单测贴出来看下

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants