apache / apache/datafusion-sqlparser-rs

MS SQL create table parse error

Open
#1,264 1 comment 1 reaction 0 assignees View on GitHub
Dominant language
Rust
Stars
3.5k
Forks
772
Avg merge
4d 9h
Merged PRs (30d)
17

Description

This is a mirror of[ the C# issue found here](https://github.com/TylerBrinks/SqlParser-cs/issues/16)

MS SQL parsing expects a comma after `primary key` and does not accept the `identity` keyword

```
#[test]
fn parse_ms_sql_create_column_with_identity(){
let sql = "create table T_Users(id bigint primary key identity, username varchar(255) not null);";
ms().verified_only_select(sql);
}
```

Contributor guide

No contributing guide indexed for this repository

Research direction

Read the `parse_ms_sql_create_column_with_identity` reproduction and run it through `ms().verified_only_select(sql)`. Trace the MS SQL parsing path for the supplied CREATE TABLE statement, using the linked C# issue for context; done means the test accepts `primary key identity` without requiring a comma.

Written by the indexing model from the issue text.

Assessment

Tech stack
rust, sql
Domain
databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
38/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.