Skip to content

Request: Posgresql INCLUDE keyword when create index #2227

@hhlong87

Description

@hhlong87

Describe the bug
Syntax error when I use INCLUDE keyword in create index command.

Database Engine
PostgreSQL
https://www.postgresql.org/docs/17/sql-createindex.html

To Reproduce
-the SQL that be parsed: CREATE INDEX ON order (supplier, amount) INCLUDE(id);
-the node-sql-parser: 5.3.3
-the node version: 20.11.1
-error: SyntaxError: Expected [A-Za-z0-9_-$一-龥À-ſ] but " " found.

Expected behavior
Should support INCLUDE

Metadata

Metadata

Assignees

Labels

enhancementNew feature or request

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions