sqlfluff/test/fixtures/rules/std_rule_cases/RF04.yml at main · AidanHarveyNelson/sqlfluff · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
rule: RF04

test_pass_valid_identifier:
  pass_str: CREATE TABLE artist(artist_name TEXT)

test_fail_keyword_as_identifier_column:
  fail_str: CREATE TABLE artist(create TEXT)

test_fail_keyword_as_identifier_column_alias:
  fail_str: SELECT 1 as parameter

test_fail_keyword_as_identifier_table_alias:
  fail_str: SELECT x FROM tbl AS parameter

test_pass_valid_identifier_not_alias:
  # should pass on default config as not alias
  pass_str: SELECT parameter

test_fail_keyword_as_identifier_not_alias_all:
  fail_str: SELECT parameter
  configs:
    rules:
      references.keywords:
        unquoted_identifiers_policy: all

test_pass_valid_identifier_table_alias_column_alias_config:
  pass_str: SELECT x FROM tbl AS parameter
  configs:
    rules:
      references.keywords:
        unquoted_identifiers_policy: column_aliases

test_fail_keyword_as_identifier_column_alias_config:
  fail_str: SELECT x AS date FROM tbl AS parameter
  configs:
    rules:
      references.keywords:
        unquoted_identifiers_policy: column_aliases

test_pass_valid_quoted_identifier:
  pass_str: CREATE TABLE [artist]([artist_name] TEXT)
  configs:
    rules:
      references.keywords:
        quoted_identifiers_policy: aliases
    core:
      dialect: tsql

test_fail_keyword_as_quoted_identifier_column:
  fail_str: CREATE TABLE "artist"("create" TEXT)
  configs:
    rules:
      references.keywords:
        quoted_identifiers_policy: aliases

test_pass_keyword_as_quoted_identifier_column_none_policy:
  pass_str: CREATE TABLE "artist"("create" TEXT)
  configs:
    rules:
      references.keywords:
        quoted_identifiers_policy: none

test_fail_keyword_as_quoted_identifier_column_alias:
  fail_str: SELECT 1 as [parameter]
  configs:
    rules:
      references.keywords:
        quoted_identifiers_policy: aliases
    core:
      dialect: tsql

test_fail_keyword_as_quoted_identifier_table_alias:
  fail_str: SELECT [x] FROM [tbl] AS [parameter]
  configs:
    rules:
      references.keywords:
        quoted_identifiers_policy: aliases
    core:
      dialect: tsql

test_pass_valid_quoted_identifier_not_alias:
  # should pass on default config as not alias
  pass_str: SELECT [parameter]
  configs:
    rules:
      references.keywords:
        quoted_identifiers_policy: aliases
    core:
      dialect: tsql

test_fail_keyword_as_quoted_identifier_not_alias_all:
  fail_str: SELECT [parameter]
  configs:
    rules:
      references.keywords:
        quoted_identifiers_policy: all
    core:
      dialect: tsql

test_pass_valid_quoted_identifier_table_alias_column_alias_config:
  pass_str: SELECT [x] FROM [tbl] AS [parameter]
  configs:
    rules:
      references.keywords:
        quoted_identifiers_policy: column_aliases
    core:
      dialect: tsql

test_fail_keyword_as_quoted_identifier_column_alias_config:
  fail_str: SELECT [x] AS [date] FROM [tbl] AS [parameter]
  configs:
    rules:
      references.keywords:
        quoted_identifiers_policy: column_aliases
    core:
      dialect: tsql

test_pass_ignore_word1:
  pass_str: CREATE TABLE artist(create TEXT)
  configs:
    rules:
      references.keywords:
        ignore_words: create


test_pass_ignore_word2:
  pass_str: SELECT col1 AS date FROM table1
  configs:
    rules:
      references.keywords:
        ignore_words: date

test_pass_ignore_words_regex1:
  pass_str: CREATE TABLE artist(create TEXT)
  configs:
    rules:
      references.keywords:
        ignore_words_regex: ^cr


test_pass_ignore_words_regex2:
  pass_str: SELECT col1 AS date FROM table1
  configs:
    rules:
      references.keywords:
        ignore_words_regex: ^da

test_pass_one_character_identifier:
  pass_str: SELECT d.col1 FROM table1 d
  configs:
    core:
      dialect: snowflake