apache / apache/datafusion-sqlparser-rs
MS SQL create table parse error
- 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