Parsing errors in Azure Synapse Analytics examples

Open

#126 opened on Mar 26, 2025 0 comments 1 reaction 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty: 5/5
Estimated time: Over a week
Newbie friendliness: 35/100

Issue type: Bug
Clarity: Mostly clear
Activity status: Stale
Tech stack: csharp, sql
Domain: compilers, devtools

Research direction

Start with the C# reproduction using TSql160Parser and run the listed Azure Synapse examples against the parser to confirm each reported error. Use the linked Microsoft documentation to compare the supported syntax, then verify that the affected DDL, query, security, transaction, and diagnostics examples parse without errors.

Written by the indexing model from the issue text.

Description

We have listed out the examples in Azure Synapse Dedicated SQL Pool that are currently not supported in Microsoft SQL Parser ( TSql160Parser ) Version - 170.28.0

Microsoft documentation references :

Data Definition Language (DDL) statements

Sr no.	Keyword	Reference links	Error Message
1	ALTER TABLE	Link	`Option 'RESUMABLE' is not a valid index option in 'ALTER TABLE' statement.`
2	CREATE DATABASE	Link	`Incorrect syntax near 'MAXSIZE'.`
3	CREATE MATERIALIZED VIEW AS SELECT	Link	`Incorrect syntax near 'materialized'.`
4	CREATE STATISTICS	Link	`Incorrect syntax near 'ON'.`
5	CREATE TABLE AS SELECT	Link	`Incorrect syntax near 'FORMAT_OPTIONS'.`
6	DROP TABLE	Link	`Expected but did not find a closing quotation mark after the character string 't NULL`
7	RENAME	Link , Link	`Incorrect syntax near 'DATABASE'.`

Query statements

Sr no.	Keyword	Reference links	Error Message
1	WITH common_table_expression (Transact-SQL)	Link	`Incorrect syntax near 'FORMAT_OPTIONS'.`
2	FROM clause plus JOIN, APPLY, PIVOT (Transact-SQL)	Link , Link ,Link	`Incorrect syntax near 'REDUCE'.`
3	OPTION clause (Transact-SQL)	Link , Link	`Expected BYPASS but encountered FORCE instead.`

Security statements

Sr no.	Keyword	Reference links	Error Message
1	BACKUP CERTIFICATE	Link	`Incorrect syntax near '='.`
2	CREATE CERTIFICATE	Link	`Incorrect syntax near '='.`
3	CREATE USER	Link	`Incorrect syntax near 'ON'.`

T-SQL language elements for dedicated SQL pool in Azure Synapse Analytics

Sr no.	Keyword	Reference links	Error Message
1	Transactions	Link	`Incorrect syntax near 'AUTOCOMMIT'.`
2	CREATE DIAGNOSTICS SESSION	Link	`Incorrect syntax near 'DIAGNOSTICS'.`

Steps to reproduce

        static void Main(string[] args)
        {
            var script = @"<EXAMPLE_SCRIPT>";

            var parser = new TSql160Parser(true, 0);
            var fragment = parser.Parse(new StringReader(script), out var parseErrors);

            if (parseErrors.Count > 0)
            {
                Console.WriteLine(parseErrors[0].Message);
            }
        }

Dominant language: GAP
Stars: 277
Forks: 43
Avg merge: 6d 17h
Merged PRs (30d): 3

Contributor guide

Open the contributing guide

First steps

Read the whole issue, then the project's contributing guide.
Comment on the issue to say you are picking it up — it saves two people doing the same work.
Fork the repository and make your change on a branch.
Open a pull request that references the issue number.

Similar issues

isolated-declarations: TS9025 on an optional parameter property typed `readonly T[]`, which tsc 7 accepts Open

Difficulty 2/5 1-3 hours Newbie friendliness 88/100

oxc-project/oxc#26944 · Opened Sep 22, 2026
perf: a definite-value return type (`--> Nil`, `--> True`) sends every call down the full path (~12 µs vs ~1 µs) Open

todo:perf

Difficulty 2/5 1-3 hours Newbie friendliness 84/100

tokuhirom/mutsu#9074 · Opened Sep 22, 2026
A function-call exponent (`A^sqrt(n)`) emits `pow(A, sqrt)(n)` — valid BNGL that codegen cannot compile Open

bug

Difficulty 2/5 Half a day Newbie friendliness 82/100

lanl/bngsim#657 · Opened Sep 22, 2026
tt_metal/hw/inc/internal/tt-2xx/quasar/overlay/xcustom_test.hpp needs reimplementing Open

Difficulty 2/5 1-3 hours Newbie friendliness 68/100

tenstorrent/tt-metal#57393 · 1 comment · Opened Sep 22, 2026
StUnhex.number() misformats Long.MIN_VALUE as scientific notation instead of a plain integer Open

Difficulty 2/5 1-3 hours Newbie friendliness 86/100

objectionary/eo#8894 · Opened Sep 22, 2026

More Compilers issues