# YML test files are auto-generated from SQL files and should not be edited by
# hand. To help enforce this, the "hash" field in the file must match a hash
# 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: af3ada717521748d1f9bdb2c5c54c3c60b343b95d5777e2535f653800f369f27
file:
  statement:
    create_trigger:
    - keyword: CREATE
    - keyword: TRIGGER
    - trigger_reference:
        naked_identifier: x
    - keyword: BEFORE
    - keyword: UPDATE
    - keyword: OF
    - column_reference:
        naked_identifier: z
    - keyword: 'ON'
    - table_reference:
        naked_identifier: y
    - keyword: BEGIN
    - select_statement:
        select_clause:
          keyword: SELECT
          select_clause_element:
            function:
              function_name:
                function_name_identifier: RAISE
              function_contents:
                bracketed:
                  start_bracket: (
                  keyword: ROLLBACK
                  comma: ','
                  quoted_literal: "'updating z not allowed'"
                  end_bracket: )
    - statement_terminator: ;
    - keyword: END
  statement_terminator: ;
