TSQL: Move PROPERTY to unreserved (#5759)

WittierDinosaur · alanmcruickshank · web-flow · commit a88478c5d2cf · 2024-04-07T21:14:15.000Z
Co-authored-by: Alan Cruickshank &lt;alan@designingoverload.com&gt;
diff --git a/src/sqlfluff/dialects/dialect_tsql_keywords.py b/src/sqlfluff/dialects/dialect_tsql_keywords.py
@@ -169,7 +169,6 @@
     "PRINT",
     "PROC",
     "PROCEDURE",
-    "PROPERTY",
     "PUBLIC",
     "RAISERROR",
     "READ",
@@ -493,6 +492,7 @@
     "PRECISION",  # listed as reserved but functionally unreserved
     "PRIOR",
     "PROFILE",
+    "PROPERTY",
     "PUSHDOWN",
     "QUERY_GOVERNOR_COST_LIMIT",
     "QUERYTRACEON",
diff --git a/test/fixtures/dialects/tsql/select.sql b/test/fixtures/dialects/tsql/select.sql
@@ -57,6 +57,7 @@ SELECT
 	NUMERIC_ROUNDABORT ,
 	PARSEONLY ,
 	PRECISION ,
+	PROPERTY ,
 	QUERY_GOVERNOR_COST_LIMIT ,
 	QUOTED_IDENTIFIER ,
 	REMOTE_PROC_TRANSACTIONS ,
diff --git a/test/fixtures/dialects/tsql/select.yml b/test/fixtures/dialects/tsql/select.yml
@@ -3,7 +3,7 @@
 # computed by SQLFluff when running the tests. Please run
 # `python test/generate_parse_fixture_yml.py`  to generate them after adding or
 # altering SQL files.
-_hash: 59a35b46fcaf8ea8fc2fb65f68781819778331f671e63b3a8e12bb24096596dd
+_hash: cd5c1e1638d1d92a2646681f46b513cce2da8c732fbc2d9649f3ac74cd3d7064
 file:
   batch:
   - statement:
@@ -337,6 +337,10 @@ file:
             column_reference:
               naked_identifier: PRECISION
         - comma: ','
+        - select_clause_element:
+            column_reference:
+              naked_identifier: PROPERTY
+        - comma: ','
         - select_clause_element:
             column_reference:
               naked_identifier: QUERY_GOVERNOR_COST_LIMIT
