Pointblank Validation
The intendo revenue table.

PostgreSQL revenueWARN 0.01 STOP 0.10 NOTIFY
STEP COLUMNS VALUES TBL EVAL ⋅ ⋅ ⋅ PASS FAIL W S N EXT
1

Comparison.

col_vals_lt()

revenue

price

927K 927K
1.00
0
0.00

2

Comparison.

col_vals_lte()

size

5

2M 2M
0.93
139K
0.07

3

Comparison.

col_vals_equal()

time

2015

2M 2M
1.00
0
0.00

4

Comparison.

col_vals_not_equal()

revenue

price

2M 2M
1.00
0
0.00

5

Comparison.

col_vals_not_equal()

name

type

2M 2M
1.00
0
0.00

6

Comparison.

col_vals_gte()

size

1

2M 2M
1.00
0
0.00

7

Comparison.

col_vals_gt()

revenue

0

2M 2M
1.00
0
0.00

8

Comparison.

col_vals_between()

revenue

(0, 150]

2M 2M
1.00
0
0.00

9

Comparison.

col_vals_between()

size

[0, 5]

2M 788K
0.40
1M
0.60

10

Comparison.

col_vals_between()

time

[2015-01-01, 2016-01-01]

2M 2M
1.00
0
0.00

11

Comparison.

col_vals_not_between()

revenue

[0, 0.75]

927K 882K
0.95
45K
0.05

12

Values within sets.

col_vals_in_set()

type

ad, currency, season_pass, offer_agent, NA

2M 2M
1.00
0
0.00

13

Values within sets.

col_vals_in_set()

name

gems1, gems2, gems3, gems4, gems5, gold1, gold2, gold3, gold4, gold5, gold6, gold7, offer1, offer2, offer3, offer4, offer5, ad_5sec, pass

2M 2M
1.00
0
0.00

14

Values within sets.

col_vals_not_in_set()

type

currency, season_pass, offer_agent

1M 1M
1.00
0
0.00

15

Presence of NULLs.

col_vals_null()

size

1M 1M
1.00
0
0.00

16

Presence of NULLs.

col_vals_null()

price

1M 1M
1.00
0
0.00

17

Presence of NULLs.

col_vals_not_null()

user_id

2M 2M
1.00
0
0.00

18

Presence of NULLs.

col_vals_not_null()

session_id

2M 2M
1.00
0
0.00

19

Presence of NULLs.

col_vals_not_null()

time

2M 2M
1.00
0
0.00

20

Presence of NULLs.

col_vals_not_null()

name

2M 2M
1.00
0
0.00

21

Presence of NULLs.

col_vals_not_null()

type

2M 2M
1.00
0
0.00

22

Presence of NULLs.

col_vals_not_null()

revenue

2M 2M
1.00
0
0.00

23

Regular expression.

col_vals_regex()

user_id

[A-Y]{12}

2M 1M
0.54
908K
0.46

24

Regular expression.

col_vals_regex()

session_id

[A-Z]{5}_[a-z]{8}

2M 2M
1.00
0
0.00

25
c

Column type.

col_is_character()

user_id

1 1
1.00
0
0.00

26
c

Column type.

col_is_character()

session_id

1 1
1.00
0
0.00

27

Schema.

col_schema_match()

SCHEMA

R TYPES

1 1
1.00
0
0.00

2020-10-01 11:24:49 EDT201.0 s2020-10-01 11:28:10 EDT