Skip to content

JSON extraction with DuckDbDialect throws an exception #70

@alexeyzimarev

Description

@alexeyzimarev

This query is running fine with DuckDB, but it doesn't pass through the parser:

	    var parser = new SqlQueryParser();
        const string sss = """
                           select
                           category_seq as seq,
                           data.name as name,
                           meta->>'description' as description
                           from category
                           order by seq;
                           """;

        var x = parser.Parse(sss, new DuckDbDialect());
        Console.WriteLine(x);

The exception says that the string literal isn't terminated:

Unhandled exception. SqlParser.TokenizeException: Unterminated string literal. Expected ' after Line: 4, Col: 20
   at SqlParser.Tokenizer.TokenizeQuotedString(TokenizeQuotedStringSettings settings)
   at SqlParser.Tokenizer.TokenizeSingleQuotedString(Char quoteStyle, Boolean backslashEscape)
   at SqlParser.Tokenizer.TokenizeSingle()
   at SqlParser.Tokenizer.NextToken()
   at SqlParser.Tokenizer.TokenizeWithLocation(ReadOnlySpan`1 sql)
   at SqlParser.Tokenizer.Tokenize(ReadOnlySpan`1 sql, Dialect dialect)
   at SqlParser.Parser.ParseSql(ReadOnlySpan`1 sql, Dialect dialect, ParserOptions options)
   at SqlParser.SqlQueryParser.Parse(ReadOnlySpan`1 sql, Dialect dialect, ParserOptions options)

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