sqlInterpolate misses consecutive comments

[rnorberg]

Example of the error:

sqlInterpolate(ANSI(), "
SELECT *
-- comment
-- consecutive comment with string literal character '
FROM mytable")

Error in sqlParseVariablesImpl(sql, list(sqlQuoteSpec("\"", "\""), sqlQuoteSpec("'",  :  Unterminated literal

Other examples that also result in sqlInterpolate mis-parsing consecutive comments:

sqlInterpolate(ANSI(), "
SELECT *
-- comment
-- consecutive comment with string literal character \"
FROM mytable")

sqlInterpolate(ANSI(), "
SELECT *
/* comment *//* consecutive comment with string literal character '*/
FROM mytable")

[krlmlr]

Closed by PR.

[github-actions]

This old thread has been automatically locked. If you think you have found something related to this, please open a new issue and link to this old issue if necessary.