sqlfluff/test/fixtures/rules/std_rule_cases/LT01-brackets.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
rule: LT01

test_pass_parenthesis_block_isolated:
  pass_str: |
    SELECT * FROM (SELECT 1 AS C1) AS T1;

test_pass_parenthesis_block_isolated_template:
  pass_str: |
    {{ 'SELECT * FROM (SELECT 1 AS C1) AS T1;' }}
  configs:
    core:
      ignore_templated_areas: false

test_fail_parenthesis_block_not_isolated:
  fail_str: |
    SELECT * FROM(SELECT 1 AS C1)AS T1;
  fix_str: |
    SELECT * FROM (SELECT 1 AS C1) AS T1;

test_fail_parenthesis_block_not_isolated_templated:
  fail_str: |
    {{ 'SELECT * FROM(SELECT 1 AS C1)AS T1;' }}
  configs:
    core:
      ignore_templated_areas: false

test_pass_parenthesis_function:
  pass_str: |
    SELECT foo(5) FROM T1;

test_pass_snowflake_match_condition:
  pass_str: |
    select *
    from table1
    asof join table2 match_condition(t1 > t2) on pk1 = pk2;
  configs:
    core:
      dialect: snowflake

test_fail_snowflake_match_condition:
  fail_str: |
    select
        table1.pk1,
        table1.t1
    from table1
        asof join
        table2
        match_condition
        (t1 > t2)
        on table1.pk1 = table2.pk2;
  fix_str: |
    select
        table1.pk1,
        table1.t1
    from table1
        asof join
        table2
        match_condition(t1 > t2)
        on table1.pk1 = table2.pk2;
  configs:
    core:
      dialect: snowflake