Parenthesised column name in index filter expressions

Open Stefan-Puskarica opened this issue 8 months ago • 0 comments

The following SQL is accepted as valid and works as intended by SQL Server.

CREATE TABLE DummyTable (
  col int,
  INDEX INDEX_ON_COL (col) WHERE (col) IS NOT NULL
)

However, ScriptDom cannot parse it due to the parenthesis around the column name, not 100% sure if this is an issue with SQL Server or with ScriptDom.

Version: Microsoft SQL Server 2019 (RTM-CU32) (KB5054833) - 15.0.4430.1 (X64) Feb 21 2025 17:28:26 Copyright (C) 2019 Microsoft Corporation Developer Edition (64-bit) on Windows 10 Enterprise 10.0 <X64> (Build 22631: ) (Hypervisor)

May 21 '25 03:05 Stefan-Puskarica