dvasdekis opened a new issue, #2605:
URL: https://github.com/apache/datafusion-sqlparser-rs/issues/2605
MSSQL: Clarify Synapse final-column trailing-comma support
Should MsSqlDialect have a narrowly scoped capability for a final comma
after a complete CREATE TABLE column definition?
Synthetic reproducer:
```sql
CREATE TABLE #example (
id INT,
label VARCHAR(32),
);
```
The default MSSQL parser rejects this. The proposed scope is Azure Synapse
serverless SQL pool temporary tables, not every SQL Server variant.
I have not independently executed this reproducer against that service. The
documented CREATE TABLE grammar does not clearly establish this allowance, so I
am requesting scope confirmation before proposing a default dialect change.
Reference:
https://learn.microsoft.com/en-us/sql/t-sql/statements/create-table-transact-sql?view=azure-sqldw-latest
If supported, the capability should apply only after a complete final column
definition, without enabling global trailing commas, malformed/doubled commas,
or trailing function arguments. Existing explicit ParserOptions behavior should
remain unchanged.
Related generic trailing-comma support exists in #1212; this question
concerns a narrow default capability and engine scope.
Prepared with GitHub Copilot assistance. All material above is synthetic.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
