File: std_CV02_test.py

package info (click to toggle)
sqlfluff 3.5.0-2
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 34,000 kB
  • sloc: python: 106,131; sql: 34,188; makefile: 52; sh: 8
file content (13 lines) | stat: -rw-r--r-- 454 bytes parent folder | download | duplicates (2) 
1
2
3
4
5
6
7
8
9
10
11
12
13
 
"""Tests the python routines within CV02."""

import sqlfluff


def test__rules__std_CV02_raised() -> None:
    """CV02 is raised for use of ``IFNULL`` or ``NVL``."""
    sql = "SELECT\n\tIFNULL(NULL, 100),\n\tNVL(NULL,100);"
    result = sqlfluff.lint(sql, rules=["CV02"])

    assert len(result) == 2
    assert result[0]["description"] == "Use 'COALESCE' instead of 'IFNULL'."
    assert result[1]["description"] == "Use 'COALESCE' instead of 'NVL'."