Pointblank Validation
The intendo revenue table.

DuckDB 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-09-30 23:08:19 EDT245.8 s2020-09-30 23:12:25 EDT