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] sql injection violation, dbType oracle, , druid-version 1.2.5, syntax error: syntax error, expect ), actual IDENTIFIER pos 2133, line 19, column 132, token IDENTIFIER COLUMNS #6106

Open
len531 opened this issue Aug 21, 2024 · 1 comment

Comments

@len531
Copy link

len531 commented Aug 21, 2024

Database Type

oracle

Database Version

oracle 14c

Druid Version

1.2.6

JDK Version

jdk11

Error SQL

(select TRANS_CODE_DESC
from JSON_TABLE((select param_value from VSS_SYS_PARAMS where param_name = 'VSS_SPECIAL_SHOW_TRANS_CODE'), '$[*]' COLUMNS (TRANS_CODE VARCHAR2(100 CHAR) PATH '$.transCode', TRANS_CODE_DESC VARCHAR2(100 CHAR) PATH '$.transCodeDesc'))
WHERE TRANS_CODE = own.TRANS_CODE)

Testcase Code

No response

Stacktrace Info

No response

Error Info

No response

@len531
Copy link
Author

len531 commented Aug 21, 2024

是因为druid不支持oracle的JSON_TABLE函数吗

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

1 participant