AL08.yml

rule: AL08

test_fail_references:
  fail_str: |
    select
      foo,
      foo

test_fail_aliases:
  fail_str: |
    select
      a as foo,
      b as foo

test_fail_alias_refs:
  fail_str: |
    select
      foo,
      b as foo

test_fail_locs:
  fail_str: |
    select
      foo,
      b as foo,
      c as bar,
      bar,
      d foo,
  violations:
    - code: AL08
      description: Reuse of column alias 'foo' from line 2.
      name: aliasing.unique.column
      warning: false
      fixes: []
      start_line_no: 3
      start_line_pos: 8
      start_file_pos: 21
      end_line_no: 3
      end_line_pos: 11
      end_file_pos: 24
    - code: AL08
      description: Reuse of column alias 'bar' from line 4.
      name: aliasing.unique.column
      warning: false
      fixes: []
      start_line_no: 5
      start_line_pos: 3
      start_file_pos: 40
      end_line_no: 5
      end_line_pos: 6
      end_file_pos: 43
    - code: AL08
      description: Reuse of column alias 'foo' from line 2.
      name: aliasing.unique.column
      warning: false
      fixes: []
      start_line_no: 6
      start_line_pos: 5
      start_file_pos: 49
      end_line_no: 6
      end_line_pos: 8
      end_file_pos: 52

test_fail_alias_quoted:
  fail_str: |
    select
      foo,
      b as "foo"
  configs:
    core:
      dialect: snowflake

test_fail_alias_case:
  fail_str: |
    select
      foo,
      b as FOO

test_fail_qualified:
  fail_str: |
    select
      a.foo
      , b as foo
    from a

test_pass_table_names:
  pass_str: |
    select
      a.b,
      b.c,
      c.d
    from a, b, c