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

ArrayIndexOutOfBoundsException when using double quotes in plain SQL as string delimiters #7706

Closed
lukaseder opened this issue Jul 30, 2018 · 1 comment

Comments

@lukaseder
Copy link
Member

lukaseder commented Jul 30, 2018

As shown on the mailing list, the following plain SQL usage throws an ArrayIndexOutOfBoundsException:

Field c = DSL.field("\"abc\"\"\"");
System.out.println(c);

In MySQL, it seems to be OK to delimit strings with double quotes (?). While jOOQ currently doesn't support parsing this in its plain SQL template mechanism, an AIOOBE is still not very nice. A better exception should be thrown.


See also:
https://groups.google.com/forum/#!topic/jooq-user/AP8EIqmBqgk

@lukaseder lukaseder added this to the Version 3.12.0 milestone Jul 30, 2018
@lukaseder lukaseder changed the title ArrayIndexOutOfBoundsException ArrayIndexOutOfBoundsException when using double quotes in plain SQL as string delimiters Jul 31, 2018
lukaseder added a commit that referenced this issue Aug 8, 2018
@lukaseder
Copy link
Member Author

Fixed for jOOQ 3.12. Backports scheduled for 3.11.4 (#7738) and 3.10.9 (#7739)

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