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

test_pass_bare_function:
  pass_str: COMMENT ON FUNCTION x IS 'y';
  configs:
    core:
      dialect: postgres

test_fail_spaced_function:
  fail_str: COMMENT ON FUNCTION x (foo) IS 'y';
  fix_str: COMMENT ON FUNCTION x(foo) IS 'y';
  configs:
    core:
      dialect: postgres

test_pass_rebalance_hint:
  pass_str: SELECT /*+ REBALANCE */ 1 AS a FROM xxx.yyy;
  configs:
    core:
      dialect: sparksql

test_pass_drop_function_go:
  pass_str: |
    DROP FUNCTION IF EXISTS INTERNAL_ETL.DIL_md_ScdTest
    GO
  configs:
    core:
      dialect: tsql

test_pass_select_hint:
  pass_str: |
    select /*+ repartition(200) */
        one,
        two
    from
        mytable
  configs:
    core:
      dialect: sparksql