\set ECHO none
remove_provenance

(1 row)
position|scaled_count
Analyst|20 (*)
Director|10 (*)
Double agent|10 (*)
Field agent|10 (*)
HR|10 (*)
Janitor|10 (*)
(6 rows)
remove_provenance

(1 row)
position|half_count
Analyst|1.00000000000000000000 (*)
Director|0.50000000000000000000 (*)
Double agent|0.50000000000000000000 (*)
Field agent|0.50000000000000000000 (*)
HR|0.50000000000000000000 (*)
Janitor|0.50000000000000000000 (*)
(6 rows)
remove_provenance

(1 row)
position|offset_count
Analyst|102 (*)
Director|101 (*)
Double agent|101 (*)
Field agent|101 (*)
HR|101 (*)
Janitor|101 (*)
(6 rows)
remove_provenance

(1 row)
doubled_avg
8.0000000000000000 (*)
(1 row)
remove_provenance

(1 row)
position|sum_plus_one
Analyst|11 (*)
Director|2 (*)
Double agent|6 (*)
Field agent|5 (*)
HR|7 (*)
Janitor|3 (*)
(6 rows)
remove_provenance

(1 row)
city|cnt_numeric
Berlin|2 (*)
New York|2 (*)
Paris|3 (*)
(3 rows)
remove_provenance

(1 row)
city|plus_one
Berlin|3 (*)
New York|3 (*)
Paris|4 (*)
(3 rows)
WARNING:  ProvSQL: window function: provenance not tracked, although the statement tracks personnel
DETAIL:  provsql-reason: window-not-tracked; scope: gap
HINT:  Mark it plain() to say so.
WARNING:  ProvSQL: aggregate result read as a plain value: provenance not tracked, although the statement tracks personnel
DETAIL:  provsql-reason: aggregate-read-as-plain-value; scope: gap; reader: window
HINT:  Mark it plain() to say so.
remove_provenance

(1 row)
city|cnt|total
Berlin|2 (*)|7
New York|2 (*)|7
Paris|3 (*)|7
(3 rows)
remove_provenance

(1 row)
city|cnt
Berlin|2 (*)
New York|2 (*)
Paris|3 (*)
(3 rows)
remove_provenance

(1 row)
city|at_least_3
Berlin|3 (*)
New York|3 (*)
Paris|3 (*)
(3 rows)
remove_provenance

(1 row)
g|lo
9223372036854775807 (*)|3 (*)
(1 row)
add_provenance

(1 row)
remove_provenance

(1 row)
g|e|ga|gm
7 (*)|4.666667|3.5000000000000000 (*)|4 (*)
(1 row)
remove_provenance

(1 row)
remove_provenance

(1 row)
city|doubled
Berlin|11.0000000000000000 (*)
New York|3.0000000000000000 (*)
Paris|9.3333333333333334 (*)
(3 rows)
WARNING:  ProvSQL: aggregate result read as a plain value: provenance not tracked, although the statement tracks personnel
DETAIL:  provsql-reason: aggregate-read-as-plain-value; scope: gap; reader: operator
HINT:  Mark it plain() to say so.
remove_provenance

(1 row)
city|team
Berlin|Ellen, Susan (team)
New York|John, Paul (team)
Paris|Dave, Magdalen, Nancy (team)
(3 rows)
remove_provenance

(1 row)
disp
11.0 (*)
12.0 (*)
6.0 (*)
(3 rows)
remove_provenance

(1 row)
city|s|g|n
Berlin|11 (*)|3 (*)|2 (*)
New York|3 (*)|3 (*)|2 (*)
Paris|14 (*)|3 (*)|3 (*)
(3 rows)
add_provenance

(1 row)
remove_provenance

(1 row)
k|e_span|e_rate
1|57600.000000|0.043011
2|748800.000000|0.043752
(2 rows)
remove_provenance

(1 row)
WARNING:  ProvSQL: aggregate result read as a plain value: provenance not tracked, although the statement tracks personnel
DETAIL:  provsql-reason: aggregate-read-as-plain-value; scope: gap; reader: conditional, comparison, boolean
HINT:  Mark it plain() to say so.
remove_provenance

(1 row)
city|has_dir|eq_true|not_every|simple_case
Berlin|no|f|t|other
Berlin|no|f|t|two
New York|yes|t|t|other
New York|yes|t|t|two
Paris|no|f|t|other
Paris|no|f|t|two
(6 rows)
remove_provenance

(1 row)
city|half|third|half_num|inv|neg
Berlin|1 (*)|3 (*)|1.00000000000000000000 (*)|3 (*)|-1 (*)
New York|1 (*)|1 (*)|1.00000000000000000000 (*)|3 (*)|-1 (*)
Paris|1 (*)|4 (*)|1.5000000000000000 (*)|2 (*)|-1 (*)
(3 rows)
add_provenance

(1 row)
WARNING:  ProvSQL: aggregate result read as a plain value: provenance not tracked, although the statement tracks agg_arith_dates
DETAIL:  provsql-reason: aggregate-read-as-plain-value; scope: gap; reader: cast
HINT:  Mark it plain() to say so.
remove_provenance

(1 row)
label|ts|txt
a|Wed Jan 15 00:00:00 2020 (*)|01-15-2020
b|Sat Feb 01 00:00:00 2020 (*)|02-01-2020
(2 rows)
WARNING:  ProvSQL: aggregate result read as a plain value: provenance not tracked, although the statement tracks agg_arith_dates
DETAIL:  provsql-reason: aggregate-read-as-plain-value; scope: gap; reader: cast
HINT:  Mark it plain() to say so.
remove_provenance

(1 row)
label|month
a|01-15-2020
a|02-15-2020
b|02-01-2020
b|03-01-2020
(4 rows)
label|month
a|01-15-2020
a|02-15-2020
b|02-01-2020
b|03-01-2020
(4 rows)
remove_provenance

(1 row)
n|cities
2 (*)|Berlin,New York (*)
(1 row)
remove_provenance

(1 row)
r|a|f|e
933.33 (*)|28.0 (*)|9.333333 (*)|7
(1 row)
WARNING:  ProvSQL: aggregate result read as a plain value: provenance not tracked, although the statement tracks personnel
DETAIL:  provsql-reason: aggregate-read-as-plain-value; scope: gap; reader: comparison, function
HINT:  Mark it plain() to say so.
remove_provenance

(1 row)
eq|n|f
t|7|2.333333 (*)
(1 row)
WARNING:  ProvSQL: aggregate result read as a plain value: provenance not tracked, although the statement tracks personnel
DETAIL:  provsql-reason: aggregate-read-as-plain-value; scope: gap; reader: function
HINT:  Mark it plain() to say so.
remove_provenance

(1 row)
g
1
4
7
(3 rows)
add_provenance

(1 row)
WARNING:  ProvSQL: aggregate result read as a plain value: provenance not tracked, although the statement tracks agg_arith_ts
DETAIL:  provsql-reason: aggregate-read-as-plain-value; scope: gap; reader: operator
HINT:  Mark it plain() to say so.
remove_provenance

(1 row)
id|d
1|@ 0
2|@ 2 days
(2 rows)
remove_provenance

(1 row)
city|n
Berlin|0 (*)
New York|0 (*)
Paris|3 (*)
(3 rows)
remove_provenance

(1 row)
r
2.333 (*)
(1 row)
WARNING:  ProvSQL: aggregate result read as a plain value: provenance not tracked, although the statement tracks personnel
DETAIL:  provsql-reason: aggregate-read-as-plain-value; scope: gap; reader: conditional
HINT:  Mark it plain() to say so.
remove_provenance

(1 row)
city|v|d
Berlin|0 (*)|no
New York|0 (*)|yes
Paris|6 (*)|no
(3 rows)
remove_provenance

(1 row)
id|d
1|first
2|second
(2 rows)
WARNING:  ProvSQL: window function: provenance not tracked, although the statement tracks personnel
DETAIL:  provsql-reason: window-not-tracked; scope: gap
HINT:  Mark it plain() to say so.
WARNING:  ProvSQL: window partitioned or ordered by an aggregate result: provenance not tracked, although the statement tracks personnel
DETAIL:  provsql-reason: window-over-aggregate-frozen; scope: gap
HINT:  Mark it plain() to say so.
WARNING:  ProvSQL: aggregate result read as a plain value: provenance not tracked, although the statement tracks personnel
DETAIL:  provsql-reason: aggregate-read-as-plain-value; scope: gap; reader: window
HINT:  Mark it plain() to say so.
remove_provenance

(1 row)
city|c|r|s
Berlin|2 (*)|2|4
New York|2 (*)|3|4
Paris|3 (*)|1|3
(3 rows)
add_provenance

(1 row)
remove_provenance

(1 row)
p
0.6250
(1 row)
remove_provenance

(1 row)
t
agg_token
(1 row)
remove_provenance

(1 row)
city|n|q
Berlin|1 (*)|10 (*)
New York|0 (*)|(*)
Paris|1 (*)|10 (*)
(3 rows)
add_provenance

(1 row)
WARNING:  ProvSQL: aggregate result read as a plain value: provenance not tracked, although the statement tracks agg_arith_ts
DETAIL:  provsql-reason: aggregate-read-as-plain-value; scope: gap; reader: operator
HINT:  Mark it plain() to say so.
remove_provenance

(1 row)
g|d
1|@ 2 days
2|@ 0
(2 rows)
remove_provenance

(1 row)
city|r
Berlin|1 (*)
New York|1 (*)
Paris|1 (*)
(3 rows)
remove_provenance

(1 row)
n
7
(1 row)
remove_provenance

(1 row)
city|r
Berlin|2 (*)
New York|3 (*)
Paris|1 (*)
(3 rows)
add_provenance

(1 row)
remove_provenance

(1 row)
WARNING:  ProvSQL: converting agg_token to text: provenance information is lost
DETAIL:  provsql-reason: stored-agg-token-conversion; scope: deliberate
f8_div|f8_div7|f8_times|num_div|int_div|f4_div|num_round|ftn|peeled|f_operand|cast_tok|f8_sqrt
t|t|t|t|t|t|t|t|t|t|t|t
(1 row)
remove_provenance

(1 row)
WARNING:  ProvSQL: converting agg_token to text: provenance information is lost
DETAIL:  provsql-reason: stored-agg-token-conversion; scope: deliberate
f8_sqrt|f8_ln|f8_exp|num_sqrt
t|t|t|t
(1 row)
e_f8_div|provsql
1.142857|d265daa9-f206-561d-845c-2a85fa0fa72c
(1 row)
remove_provenance

(1 row)
p_cast_cmp
0.375000
(1 row)
remove_provenance

(1 row)
add_provenance

(1 row)
WARNING:  ProvSQL: converting agg_token to text: provenance information is lost
DETAIL:  provsql-reason: stored-agg-token-conversion; scope: deliberate
g|ln|sqrt|pow|exp|e_ln|e_sqrt
1|1.386294|2.000000|16.000000|54.598150|0.902683|1.601961
2|2.197225|3.000000|81.000000|8103.083928|2.197225|3.000000
(2 rows)
add_provenance

(1 row)
WARNING:  ProvSQL: converting agg_token to text: provenance information is lost
DETAIL:  provsql-reason: stored-agg-token-conversion; scope: deliberate
g|r
1|25.000000
2|
(2 rows)
remove_provenance

(1 row)
g|p
1|0.375000
2|0.000000
(2 rows)
remove_provenance

(1 row)
g|p
1|0.875000
2|0.500000
(2 rows)
add_provenance

(1 row)
remove_provenance

(1 row)
e_abs|e_absfn|e_signed
2.333333|2.333333|-1.666667
(1 row)
WARNING:  ProvSQL: ORDER BY on an aggregate result sorts on the value shown, not per world
DETAIL:  provsql-reason: order-by-aggregate-value; scope: deliberate
remove_provenance

(1 row)
WARNING:  ProvSQL: converting agg_token to numeric: provenance information is lost
DETAIL:  provsql-reason: stored-agg-token-conversion; scope: deliberate
v|a
1|1
5|3
(2 rows)
add_provenance

(1 row)
remove_provenance

(1 row)
e_sum|e_cast1|e_dec1|e_round1|e_cast0|e_round0
9.084000|9.066667|9.066667|9.066667|9.333333|9.333333
(1 row)
remove_provenance

(1 row)
WARNING:  ProvSQL: converting agg_token to numeric: provenance information is lost
DETAIL:  provsql-reason: stored-agg-token-conversion; scope: deliberate
c1|c0
13.6|14
(1 row)
plain_sum
1242.177
(1 row)
remove_provenance

(1 row)
WARNING:  ProvSQL: converting agg_token to numeric: provenance information is lost
DETAIL:  provsql-reason: stored-agg-token-conversion; scope: deliberate
c
1242.2
(1 row)
remove_provenance

(1 row)
add_provenance

(1 row)
ERROR:  division by zero
remove_provenance

(1 row)
e
-5.000000
(1 row)
remove_provenance

(1 row)
p
0.250000
(1 row)
remove_provenance

(1 row)
add_provenance

(1 row)
remove_provenance

(1 row)
p
0.750000
(1 row)
remove_provenance

(1 row)
p
0.500000
(1 row)
remove_provenance

(1 row)
p
0.500000
(1 row)
remove_provenance

(1 row)
p
0.500000
(1 row)
remove_provenance

(1 row)
p
0.500000
(1 row)
remove_provenance

(1 row)
p
0.500000
(1 row)
remove_provenance

(1 row)
p
0.500000
(1 row)
remove_provenance

(1 row)
e
1.382088
(1 row)
remove_provenance

(1 row)
add_provenance

(1 row)
remove_provenance

(1 row)
p
0.500000
(1 row)
remove_provenance

(1 row)
p
0.750000
(1 row)
remove_provenance

(1 row)
add_provenance

(1 row)
remove_provenance

(1 row)
varpop|sqrt_arm|ln_arm|stddev_samp_arm|stddev_pop_arm
0.062500|1.036566|0.673287|0.176777|0.125000
(1 row)
remove_provenance

(1 row)
WARNING:  ProvSQL: converting agg_token to numeric: provenance information is lost
DETAIL:  provsql-reason: stored-agg-token-conversion; scope: deliberate
v
1.732051
(1 row)
plain_v
1.732051
(1 row)
remove_provenance

(1 row)
add_provenance

(1 row)
remove_provenance

(1 row)
WARNING:  ProvSQL: converting agg_token to text: provenance information is lost
DETAIL:  provsql-reason: stored-agg-token-conversion; scope: deliberate
p|w|n|fl|e_p|e_caret|e_fl
900|900|900.0000|2.23606797749979|466.666667|466.666667|1.79411078
(1 row)
p|w|n|fl|e_hand|e_fl_hand
900|900|900.0000|2.23606797749979|466.666667|1.79411078
(1 row)
remove_provenance

(1 row)
k|p
1|0.500000
(1 row)
remove_provenance

(1 row)
WARNING:  ProvSQL: converting agg_token to text: provenance information is lost
DETAIL:  provsql-reason: stored-agg-token-conversion; scope: deliberate
id|p
1|10
2|400
(2 rows)
remove_provenance

(1 row)
add_provenance

(1 row)
remove_provenance

(1 row)
WARNING:  ProvSQL: converting agg_token to text: provenance information is lost
DETAIL:  provsql-reason: stored-agg-token-conversion; scope: deliberate
int_div|pct|plus_coalesce|by_case|rounded|e
1|150.0000000000000000|5|1|150.00|77.777778
(1 row)
int_div|pct|plus_coalesce|by_case|rounded|e_hand
1|150.0000000000000000|5|1|150.00|77.777778
(1 row)
remove_provenance

(1 row)
add_provenance

(1 row)
remove_provenance

(1 row)
g|p_gt3
1|0.250000
2|0.500000
(2 rows)
remove_provenance

(1 row)
g|p_eq3
1|0.500000
2|0.000000
(2 rows)
remove_provenance

(1 row)
g|p_gt3
1|0.250000
2|0.500000
(2 rows)
remove_provenance

(1 row)
add_provenance

(1 row)
remove_provenance

(1 row)
span|e
364 (*)|121.333333
(1 row)
remove_provenance

(1 row)
p
0.250000
(1 row)
WARNING:  ProvSQL: aggregate result read as a plain value: provenance not tracked, although the statement tracks agg_dt
DETAIL:  provsql-reason: aggregate-read-as-plain-value; scope: gap; reader: operator
HINT:  Mark it plain() to say so.
remove_provenance

(1 row)
span
364
(1 row)
remove_provenance

(1 row)