TSQL: Fix bare functions in default constraints

MarkPaulin · MarkPaulin · commit bb9f7e890aef · 2024-04-13T14:38:15.000+01:00
diff --git a/src/sqlfluff/dialects/dialect_tsql.py b/src/sqlfluff/dialects/dialect_tsql.py
@@ -2435,6 +2435,7 @@ class ColumnConstraintSegment(BaseSegment):
                 OptionallyBracketed(
                     OneOf(
                         OptionallyBracketed(Ref("LiteralGrammar")),  # ((-1))
+                        Ref("BareFunctionSegment"),
                         Ref("FunctionSegment"),
                         Ref("NextValueSequenceSegment"),
                     ),
diff --git a/test/fixtures/dialects/tsql/create_table_constraints.sql b/test/fixtures/dialects/tsql/create_table_constraints.sql
@@ -3,6 +3,7 @@ CREATE TABLE [dbo].[example](
     [Column B] [int] IDENTITY(1, 1) NOT NULL,
     [ColumnC] varchar(100) DEFAULT 'mydefault',
     [ColumnDecimal] DATE DEFAULT GETDATE(),
+    [ColumnUser] char(30) DEFAULT CURRENT_USER,
     [col1] int default ((-1)) not null,
     [col1] int default (-1) not null,
     [col1] int default -1 not null,
diff --git a/test/fixtures/dialects/tsql/create_table_constraints.yml b/test/fixtures/dialects/tsql/create_table_constraints.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: 64ba76dd590a430fec124b6c9c189c2d5c2961c3406a0b510accba6391210307
+_hash: c75e9d7b8dd1b4bafaa40bb49ba25f4732ecef4cc1c4adc176a43dc05b9dabbe
 file:
 - batch:
     statement:
@@ -68,6 +68,20 @@ file:
                   start_bracket: (
                   end_bracket: )
         - comma: ','
+        - column_definition:
+            quoted_identifier: '[ColumnUser]'
+            data_type:
+              data_type_identifier: char
+              bracketed_arguments:
+                bracketed:
+                  start_bracket: (
+                  expression:
+                    numeric_literal: '30'
+                  end_bracket: )
+            column_constraint_segment:
+              keyword: DEFAULT
+              bare_function: CURRENT_USER
+        - comma: ','
         - column_definition:
           - quoted_identifier: '[col1]'
           - data_type:
