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

Add a Settings.parserJDBCEscapeSyntax #16682

Open
lukaseder opened this issue May 17, 2024 · 0 comments
Open

Add a Settings.parserJDBCEscapeSyntax #16682

lukaseder opened this issue May 17, 2024 · 0 comments

Comments

@lukaseder
Copy link
Member

Our parser supports parsing JDBC escape syntax by default, which is a reasonable default for usage as a JDBC proxy (the ParsingConnection), but it might be undesired in other situations, e.g. when working with the ParserCLI from non-Java environments.

jOOQ 3.20 now supports the PostgreSQL ? operator that maps to jsonb_exists:

Within JDBC, that operator has to be escaped as ??, see:

As such, we'll parse both ? and ?? as valid operators when working with the JDBC escape syntax. ? is supported in static statements, and ?? only in prepared statements.

Other JDBC escape syntax will also be affected. The default flag value is true for backwards compatibility reasons.

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

No branches or pull requests

1 participant