File: assert.sql

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 (11 lines) | stat: -rw-r--r-- 260 bytes parent folder | download | duplicates (2) 
1
2
3
4
5
6
7
8
9
10
11
 
ASSERT (
  (SELECT COUNT(*) FROM UNNEST([1, 2, 3, 4, 5, 6])) > 5
) AS 'Table must contain more than 5 rows.';

ASSERT
  EXISTS(
    SELECT X
    FROM UNNEST([7877, 7879, 7883, 7901, 7907]) AS X
    WHERE X = 7919
  )
AS 'Column X must contain the value 7919';