Skip to content

SQLite create table statement fails on primary key #2383

@1ilit

Description

@1ilit

Describe the bug
Throws SyntaxError on primary key

Database Engine
SQLite

To Reproduce
-the SQL that be parsed

CREATE TABLE IF NOT EXISTS "__EFMigrationsHistory" (
        "MigrationId" TEXT NOT NULL CONSTRAINT "PK___EFMigrationsHistory" PRIMARY KEY,
        "ProductVersion" TEXT NOT NULL
);

-the node-sql-parser version
v5.8.3
-the node version
v18.20.3

Expected behavior
Parse successfully

Metadata

Metadata

Assignees

Labels

enhancementNew feature or request

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions