Skip to content

[BUG] JSQLParser Version 5.4-SNAPSHOT : MS SQL Server: CREATE INDEX ... INCLUDE ... not support #2459

Description

@Chu-wee

Failing SQL Feature:

SQL Example:

  • SQL
    CREATE INDEX idx_a ON t1 (a) INCLUDE (b)

Software Information:

  • JSqlParser version: 5.4-SNAPSHOT
  • Database : MS SQL Server

Parsing Error:

Caused by: net.sf.jsqlparser.JSQLParserException: net.sf.jsqlparser.parser.ParseException: Encountered: <K_INCLUDE> / "INCLUDE", at line 1, column 30, in lexical state DEFAULT.
Was expecting one of these terminals within expansion starting at 1814:19:
    <EOF> (inside 1814:19) 
    <ST_SEMICOLON> (inside 1814:19) ...

	at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatement(CCJSqlParserUtil.java:351)
	at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:128)
	at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:90)
	... 6 more 

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