search

AnantLabs / diffkit

Automatically exported from code.google.com/p/diffkit
0 stars 0 forks source link

SqlPatchSink not generating proper DML statements when String value contains single quote #61

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
end up with invalid SQL:

INSERT INTO FCCHOST.TEST_STTM_CUSTOMER (CUSTOMER_NO, CUSTOMER_TYPE, 
CUSTOMER_NAME1) 
VALUES ('000203', 'C', 'N'JALA UNIVERSITY COLLEGE');

Original issue reported on code.google.com by trur...@gmail.com on 30 Dec 2010 at 3:08

GoogleCodeExporter commented 9 years ago 
A double single ('') quote will act like a single single quote when inside a 
string literal.

http://stackoverflow.com/questions/1062083/sql-escape

Original comment by trur...@gmail.com on 30 Dec 2010 at 11:05

GoogleCodeExporter commented 9 years ago

Original comment by trur...@gmail.com on 5 Jan 2011 at 7:56

GoogleCodeExporter commented 9 years ago 
covered by test26.

Original comment by trur...@gmail.com on 5 Jan 2011 at 8:04

GoogleCodeExporter commented 9 years ago 
This issue was closed by revision r312.

Original comment by trur...@gmail.com on 5 Jan 2011 at 8:56

GoogleCodeExporter commented 9 years ago

Original comment by trur...@gmail.com on 8 Jan 2011 at 1:51