Skip to content

Cannot parse CREATE INDEX on a json text value #59

@oomathias

Description

@oomathias
CREATE INDEX CONCURRENTLY IF NOT EXISTS "idx_a_foo_bar" ON "a" ((foo->>'bar'));
Err(
    CheckSQL(
        ParsingSQL(
            JsonParse(
                "invalid type: map, expected a string at line 1 column 225",
            ),
        ),
    ),
)

The double parentheses are required in ((foo->>'bar')) but it looks like it's parsed as a map instead of a string.

Metadata

Metadata

Assignees

No one assigned

    Labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions