----------------------------------------------------------------
''
----------------------------------------------------------------
'sql goes here'
    <S_IDENTIFIER>                  : 'sql'
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'goes'
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'here'
----------------------------------------------------------------
'  odd    spacing  stuff  '
    <WHITESPACE>                    : '  '
    <S_IDENTIFIER>                  : 'odd'
    <WHITESPACE>                    : '    '
    <S_IDENTIFIER>                  : 'spacing'
    <WHITESPACE>                    : '  '
    <S_IDENTIFIER>                  : 'stuff'
    <WHITESPACE>                    : '  '
----------------------------------------------------------------
'create table test'
    <S_IDENTIFIER>                  : 'create'
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'table'
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'test'
----------------------------------------------------------------
'create table catalog.schema.test'
    <S_IDENTIFIER>                  : 'create'
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'table'
    <WHITESPACE>                    : ' '
    <COMPLEX_IDENTIFIER>            : 'catalog.schema.test'
----------------------------------------------------------------
'create table [test]'
    <S_IDENTIFIER>                  : 'create'
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'table'
    <WHITESPACE>                    : ' '
    <S_QUOTED_IDENTIFIER>           : '[test]'
----------------------------------------------------------------
'create table "test"'
    <S_IDENTIFIER>                  : 'create'
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'table'
    <WHITESPACE>                    : ' '
    <S_CHAR_LITERAL>                : '"test"'
----------------------------------------------------------------
'create table /* comment here */ test'
    <S_IDENTIFIER>                  : 'create'
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'table'
    <WHITESPACE>                    : ' '
    <MULTI_LINE_COMMENT>            : '/* comment here */'
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'test'
----------------------------------------------------------------
'insert 'a string''
    <S_IDENTIFIER>                  : 'insert'
    <WHITESPACE>                    : ' '
    <S_CHAR_LITERAL>                : ''a string''
----------------------------------------------------------------
'escaped quotes ' '' ''
    <S_IDENTIFIER>                  : 'escaped'
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'quotes'
    <WHITESPACE>                    : ' '
    <S_CHAR_LITERAL>                : '' '' ''
----------------------------------------------------------------
'escaped quotes '''''
    <S_IDENTIFIER>                  : 'escaped'
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'quotes'
    <WHITESPACE>                    : ' '
    <S_CHAR_LITERAL>                : ''''''
----------------------------------------------------------------
'mysql escaped quotes ' \' ''
    <S_IDENTIFIER>                  : 'mysql'
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'escaped'
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'quotes'
    <WHITESPACE>                    : ' '
    <S_CHAR_LITERAL>                : '' \' ''
----------------------------------------------------------------
'mysql escaped quotes '\'''
    <S_IDENTIFIER>                  : 'mysql'
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'escaped'
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'quotes'
    <WHITESPACE>                    : ' '
    <S_CHAR_LITERAL>                : ''\'''
----------------------------------------------------------------
'invalid ' sql'
    <S_IDENTIFIER>                  : 'invalid'
    <WHITESPACE>                    : ' '
    <SYMBOL>                        : '''
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'sql'
----------------------------------------------------------------
''invalid' ' sql'
    <S_CHAR_LITERAL>                : ''invalid''
    <WHITESPACE>                    : ' '
    <SYMBOL>                        : '''
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'sql'
----------------------------------------------------------------
'utf8-〠＠chars works'
    <S_IDENTIFIER>                  : 'utf8'
    <SYMBOL>                        : '-'
    <S_IDENTIFIER>                  : '〠＠chars'
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'works'
----------------------------------------------------------------
'single '\' works'
    <S_IDENTIFIER>                  : 'single'
    <WHITESPACE>                    : ' '
    <S_CHAR_LITERAL>                : ''\''
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'works'
----------------------------------------------------------------
'double '\\' works'
    <S_IDENTIFIER>                  : 'double'
    <WHITESPACE>                    : ' '
    <S_CHAR_LITERAL>                : ''\\''
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'works'
----------------------------------------------------------------
'unquoted \\ works'
    <S_IDENTIFIER>                  : 'unquoted'
    <WHITESPACE>                    : ' '
    <SYMBOL>                        : '\'
    <SYMBOL>                        : '\'
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'works'
----------------------------------------------------------------
''one quote' then 'two quote' then 'three quote' more'
    <S_CHAR_LITERAL>                : ''one quote''
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'then'
    <WHITESPACE>                    : ' '
    <S_CHAR_LITERAL>                : ''two quote''
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'then'
    <WHITESPACE>                    : ' '
    <S_CHAR_LITERAL>                : ''three quote''
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'more'
----------------------------------------------------------------
''\\' then quotes '')'
    <S_CHAR_LITERAL>                : ''\\''
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'then'
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'quotes'
    <WHITESPACE>                    : ' '
    <S_CHAR_LITERAL>                : ''''
    <SYMBOL>                        : ')'
----------------------------------------------------------------
'stringwith escquote delim newline 'a\'b;c
d''
    <S_IDENTIFIER>                  : 'stringwith'
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'escquote'
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'delim'
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'newline'
    <WHITESPACE>                    : ' '
    <S_CHAR_LITERAL>                : ''a\'b;c
d''
----------------------------------------------------------------
'"a\"b;c
d"'
    <S_CHAR_LITERAL>                : '"a\"b;c
d"'
----------------------------------------------------------------
''''' sometimesEquals '\'''
    <S_CHAR_LITERAL>                : ''''''
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'sometimesEquals'
    <WHITESPACE>                    : ' '
    <S_CHAR_LITERAL>                : ''\'''
----------------------------------------------------------------
''\'' sometimesEquals "'"'
    <S_CHAR_LITERAL>                : ''\'''
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'sometimesEquals'
    <WHITESPACE>                    : ' '
    <S_CHAR_LITERAL>                : '"'"'
----------------------------------------------------------------
'"'" sometimesEquals "\'"'
    <S_CHAR_LITERAL>                : '"'"'
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'sometimesEquals'
    <WHITESPACE>                    : ' '
    <S_CHAR_LITERAL>                : '"\'"'
----------------------------------------------------------------
'This has a symbol ≤ (u2264) but no backslash'
    <S_IDENTIFIER>                  : 'This'
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'has'
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'a'
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'symbol'
    <WHITESPACE>                    : ' '
    <SYMBOL>                        : '≤'
    <WHITESPACE>                    : ' '
    <SYMBOL>                        : '('
    <S_IDENTIFIER>                  : 'u2264'
    <SYMBOL>                        : ')'
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'but'
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'no'
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'backslash'
----------------------------------------------------------------
'This has a \ and symbol ≤ (u2264)'
    <S_IDENTIFIER>                  : 'This'
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'has'
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'a'
    <WHITESPACE>                    : ' '
    <SYMBOL>                        : '\'
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'and'
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'symbol'
    <WHITESPACE>                    : ' '
    <SYMBOL>                        : '≤'
    <WHITESPACE>                    : ' '
    <SYMBOL>                        : '('
    <S_IDENTIFIER>                  : 'u2264'
    <SYMBOL>                        : ')'
----------------------------------------------------------------
'This ≤ (u2264) is before the \'
    <S_IDENTIFIER>                  : 'This'
    <WHITESPACE>                    : ' '
    <SYMBOL>                        : '≤'
    <WHITESPACE>                    : ' '
    <SYMBOL>                        : '('
    <S_IDENTIFIER>                  : 'u2264'
    <SYMBOL>                        : ')'
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'is'
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'before'
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'the'
    <WHITESPACE>                    : ' '
    <SYMBOL>                        : '\'
----------------------------------------------------------------
'This has an unicode char ÀÀÀÀÀÀ+++ãããioú≤₢'
    <S_IDENTIFIER>                  : 'This'
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'has'
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'an'
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'unicode'
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'char'
    <WHITESPACE>                    : ' '
    <S_IDENTIFIER>                  : 'ÀÀÀÀÀÀ'
    <SYMBOL>                        : '+'
    <SYMBOL>                        : '+'
    <SYMBOL>                        : '+'
    <S_IDENTIFIER>                  : 'ãããioú'
    <SYMBOL>                        : '≤'
    <SYMBOL>                        : '₢'

Process finished with exit code 0