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
 
-