Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
2.3.0
-
None
Description
We receive SQL syntax errors for valid INSERT statements that mix escape characters, quote characters, and placeholders (?). For example, given a table:
create table tmail(txt mediumtext);
|
The following will produce a syntax error, when executed as a PreparedStatement:
insert into tmail(txt) values('some text \\''s more text ?');
|
Example code is attached.
We know there is client-side code to parse PreparedStatement SQL for purposes such as rolling multiple INSERTs together with UNION; our guess is that that code does not correctly parse this, and sends invalid SQL to the server.
Attachments
Issue Links
- is caused by
-
CONJ-664 SQLException when backslash (\), which doesn't escape any character, is used together with setParameter()
- Closed