Skip to content

Getting a SyntaxException while parsing a SQL statment #30

@TcavemanT

Description

@TcavemanT

The SQL statement SELECT [\nName] FROM [Table] fails to enumerate through the tokens in the SqlTokenizer class. A SyntaxException is thrown in RegexTokenizer.ReadNextToken().

Here is the test I had created in TestTokenizer.cs in Lann.Sql.Parser.Test:

[Test]
[TestCase( "SELECT [\nName] FROM [Table]", new[] { "SELECT", "[\nName]", "FROM", "[Table]" } )]
public void Can_Tokenize_Columns_Containing_Whitespace( string input, string[] tokens )
{
	Verify( input, tokens );
}

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions