\set ECHO none
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
sd|var|sdp|vp
1.5275252316519467|2.3333333333333333|1.2472191289246471|1.5555555555555556
(1 row)
sd|var|sdp|vp
1.5275252316519467|2.3333333333333333|1.2472191289246471|1.5555555555555556
(1 row)
e_sd|e_var|e_sdp|e_vp
1.442541|2.333333|0.606746|0.722222
(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
vp|e_vp|e_sdp|e_var
1.00000000000000000000|0.333333|0.333333|2.000000
(1 row)
remove_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
g|sd|vp
1|1.5275252316519467|1.5555555555555556
2||0
(2 rows)
g|sd|vp
1|1.5275252316519467|1.5555555555555556
2||0
(2 rows)
WARNING:  ProvSQL: aggregate result read as a plain value: provenance not tracked, although the statement tracks dev
DETAIL:  provsql-reason: aggregate-read-as-plain-value; scope: gap; reader: cast
HINT:  Mark it plain() to say so.
sd_float|provsql
1.527525|d265daa9-f206-561d-845c-2a85fa0fa72c
(1 row)
remove_provenance

(1 row)
add_provenance

(1 row)
remove_provenance

(1 row)
g|vp|vp_cond|sp|sp_cond|mn|sm
1|0.000000|0.000000|0.000000|0.000000|4.000000|4.000000
2|0.083333|0.083333|0.166667|0.166667|5.333333|7.333333
(2 rows)
remove_provenance

(1 row)