Skip to content

[BUG] JSQLParser 5.1-SNQPSHOT: ANY_DBMS : fails tu parse "CREATE SCHEMA __IF NOT EXISTS__ sales_kpi" #2061

@hayssams

Description

@hayssams
net.sf.jsqlparser.JSQLParserException: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "IF" "IF"
    at line 2, column 15.
Was expecting one of:

    "AUTHORIZATION"
    "CREATE"
    "FORCE"
    "MATERIALIZED"
    "NO"
    "PATH"
    "SECURE"
    "TEMP"
    "TEMPORARY"
    "VIEW"
    "VOLATILE"
    <EOF>
    <ST_SEMICOLON>
    <S_IDENTIFIER>
    <S_QUOTED_IDENTIFIER>

	at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatement(CCJSqlParserUtil.java:352)
	at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:125)
	at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:91)
	at com.manticore.jsqlformatter.JSQLFormatter.format(JSQLFormatter.java:899)

Failing SQL Feature:

  • IF NOT EXISTS not supported in CREATE SCHEMA parsing
  • Example: CREATE SCHEMA IF NOT EXISTS sales_kpi can't be parsed

Software Information:

  • JSqlParser 5.1-SNAPSHOT
  • Database *

Metadata

Metadata

Labels

DDLDDL statement related

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions