Repository navigation
Redshift MATERIALIZED VIEW with AUTO REFRESH is not supported #1684
Description
Using the "AUTO REFRESH" clause for a materialized view in Redshift is not supported by JSqlParser.
Trying to parse a statement like this:
CREATE MATERIALIZED VIEW AUTO REFRESH YES foo AS SELECT * FROM bar
results in:
net.sf.jsqlparser.JSQLParserException: Encountered unexpected token: "CREATE" "CREATE"
at line 1, column 1.
Was expecting one of:
"("
"ALTER"
"CALL"
"COMMENT"
"COMMIT"
"DECLARE"
"DELETE"
"DESCRIBE"
"DROP"
"EXEC"
"EXECUTE"
"EXPLAIN"
"GRANT"
"INSERT"
"MERGE"
"PURGE"
"RENAME"
"RESET"
"ROLLBACK"
"SAVEPOINT"
"SET"
"SHOW"
"TRUNCATE"
"UPDATE"
"UPSERT"
"USE"
"VALUES"
"WITH"
<K_SELECT>
at app//net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatement(CCJSqlParserUtil.java:190)
at app//net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:63)
at app//net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:38)
... 86 more
Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "CREATE" "CREATE"
at line 1, column 1.
With the AUTO REFRESH YES clause removed the statement is parsed just fine.
Activity
wumpz commentedon Dec 10, 2022
That's right? Any chance you provide a PR or sponsor this feature?
Fixes JSQLParser#1684: Support MATERIALIZED VIEW with AUTO REFRESH
1684: Redshift MATERIALIZED VIEW with AUTO REFRESH is not supported
Fixes JSQLParser#1684: Support CREATE MATERIALIZED VIEW with AUTO REF…
zaza commentedon Dec 11, 2022
This is the PR with an attempt to fix this, see #1691
Let me know if there are any other changes you would like to see included.
feat: CREATE VIEW ... REFRESH AUTO...
Assorted Fixes #6 (#1740)
Assorted Fixes #7 (#1745)
Refactor Parenthesed SelectBody and FromItem (#1754)
JSQLParser 5.0 (#1778)
Assorted Fixes #8 (#1807)
Backslash Quotation of Single-Quote `'\\''` (#1813)