Skip to content

Parsing DROP MATERIALIZED VIEW is not supported #1685

Closed
@zaza

Description

@zaza

Parsing statement for dropping a materialized view e.g. "DROP MATERIALIZED VIEW foo" results in an error:

net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "MATERIALIZED" "MATERIALIZED"
    at line 1, column 6.

Was expecting one of:

    "INDEX"
    "SCHEMA"
    "SEQUENCE"
    "TABLE"
    "VIEW"
    <S_IDENTIFIER>

	at app//net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:31468)
	at app//net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:31301)
	at app//net.sf.jsqlparser.parser.CCJSqlParser.Drop(CCJSqlParser.java:16562)
	at app//net.sf.jsqlparser.parser.CCJSqlParser.SingleStatement(CCJSqlParser.java:291)
	at app//net.sf.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:153)
	at app//net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatement(CCJSqlParserUtil.java:188)
	... 88 more

Parsing "DROP VIEW foo" with "MATERIALIZED" removed, works fine.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions