search

TylerBrinks / SqlParser-cs

A Friendly SQL Parser for .NET
MIT License
92 stars 17 forks source link

MS SQl Execute statement #18

Open frinehrt opened 3 months ago

frinehrt commented 3 months ago

Getting an error when I submit a simple execute statement, probably doing something wrong. sqlEntry.Sql = "exec dbo.selectloans;"; SqlParser.Parser parser = new SqlParser.Parser(); MsSqlDialect dialect = new MsSqlDialect(); var result = parser.ParseSql(sqlEntry.Sql,dialect);

SqlParser.ParserException: 'Expected a SQL statement, found dbo,

TylerBrinks commented 2 months ago

@frinehrt this library is a port of the Rust SQL parser project. The Rust project has the same issue in that there's an omission on parsing an execute statement for MS SQL. This may be simple enough to address out of phase, but typically the fixes in the Rust library are pulled into this codebase in order.

TylerBrinks commented 2 months ago

@frinehrt Also, the issue has already been submitted to the Rust project's team

https://github.com/sqlparser-rs/sqlparser-rs/issues/1275