Parser does not properly recognize some multiline string literals

[bjhartin]

Axel,

We are encountering SQL parsing errors when single quotes are adjacent to characters not explicitly specified as token delimiters in SqlStatementBuilder.endsWithOpenMultilineStringLiteral.

To reproduce, add these assertions to a test:

assertFalse(new SQLServerSqlStatementBuilder().endsWithOpenMultilineStringLiteral("print 'baz'+"));
assertFalse(new SQLServerSqlStatementBuilder().endsWithOpenMultilineStringLiteral("print 'baz'-- Oops"));

I think your approach of splitting on SQL special characters may be the issue. I think there are many other special characters (see http://savage.net.au/SQL/sql-2003-2.bnf.html) and also multiple-character sequences ('--') which may need to be included.

Please see related issue #544, in which I suggest two options to reduce or eliminate these parsing errors.

Thanks,

Brian

[axelfontaine]

Hi Brian,

sorry for the late reply. I fixed the first case.

The second one is the same as #63

Cheers
Axel