text: {% macro mariadb__get_test_sql(main_sql, fail_calc, warn_if, error_if, limit) -%}
      select
        {{ fail_calc }} as failures,
        case
          when {{ fail_calc }} {{ warn_if | replace("!=","<>") }} then 'true'
          else 'false'
        end as should_warn,
        case
          when {{ fail_calc }} {{ error_if | replace("!=","<>") }} then 'true'
          else 'false'
        end as should_error
      from (
        {{ main_sql }}
        {{ "limit " ~ limit if limit != none }}
      ) dbt_internal_test
  {%- endmacro %}