Re: SQL equality predicate escaping single quotes

2019-08-09 Thread Joel Bernstein
It does appear that single quotes are being removed. If you want to provide a patch that allows single quotes to get passed through, I can help with testing and committing. On Thu, Aug 8, 2019 at 11:28 AM Kyle Lilly wrote: > Hi, > > When using the SQL handler is there any way to escape single

SQL equality predicate escaping single quotes

2019-08-08 Thread Kyle Lilly
Hi, When using the SQL handler is there any way to escape single quotes in boolean predicates? A query like: SELECT title FROM books WHERE author_lastname = 'O''Reilly' Will return no results for authors with the last name "O'Reilly" but will return hits for books with a last name of "OReilly".