The sqllexer normalizer incorrectly rejects identifiers that combine an unquoted schema/table name with a quoted table
name, such as: example_schema."some-table"
During tokenization, after encountering the . the normalizer treats the following " as the start of a quoted identifier, but the hyphen - is being interpreted as the end of the quoted identifier, which is incorrect. The lexer should continue until it finds the matching closing ", regardless of the characters inside.
Reproduction steps:
The sqllexer normalizer incorrectly rejects identifiers that combine an unquoted schema/table name with a quoted table
name, such as:
example_schema."some-table"During tokenization, after encountering the . the normalizer treats the following
"as the start of a quoted identifier, but the hyphen-is being interpreted as the end of the quoted identifier, which is incorrect. The lexer should continue until it finds the matching closing", regardless of the characters inside.Reproduction steps:
Try to lex
example_schema."some-table";. (see tests in Fix: Handle mixed quote qualified identifiers #116)The resulting token is incorrectly
example_schema."orders.Try to lex
"example_schema".orders_underscore(see tests in Fix: Handle mixed quote qualified identifiers #116)The resulting token is incorrectly
example_schema.