\set ECHO none
add_provenance

(1 row)
add_provenance

(1 row)
remove_provenance

(1 row)
a|sx|p
10|100 (*)|1.0000
20|200 (*)|1.0000
30||1.0000
(3 rows)
add_provenance

(1 row)
add_provenance

(1 row)
remove_provenance

(1 row)
a|p
10|0.7500
(1 row)
add_provenance

(1 row)
add_provenance

(1 row)
remove_provenance

(1 row)
a|p
10|0.5000
20|0.0000
(2 rows)
add_provenance

(1 row)
add_provenance

(1 row)
add_provenance

(1 row)
remove_provenance

(1 row)
a|sx|p
10|7 (*)|1.0000
20|8 (*)|1.0000
(2 rows)
add_provenance

(1 row)
add_provenance

(1 row)
add_provenance

(1 row)
remove_provenance

(1 row)
a|sx|p
10|7 (*)|1.0000
20|8 (*)|1.0000
(2 rows)
remove_provenance

(1 row)
a|p
10|0.5000
20|0.5000
(2 rows)
add_provenance

(1 row)
add_provenance

(1 row)
ERROR:  ProvSQL: Subqueries (EXISTS, IN, scalar subquery) not supported
add_provenance

(1 row)
remove_provenance

(1 row)
a|p
10|1.0000
20|0.7500
(2 rows)
add_provenance

(1 row)
add_provenance

(1 row)
remove_provenance

(1 row)
a|c
10|1 (*)
20|2 (*)
30|0 (*)
(3 rows)
remove_provenance

(1 row)
a|m
10|100 (*)
20|201 (*)
30|
(3 rows)
remove_provenance

(1 row)
a|p
10|0.0000
20|0.2500
30|0.0000
(3 rows)
add_provenance

(1 row)
add_provenance

(1 row)
remove_provenance

(1 row)
a|p
10|0.5000
20|0.7500
30|0.0000
(3 rows)
remove_provenance

(1 row)
a|p
10|0.5000
20|0.2500
30|1.0000
(3 rows)
remove_provenance

(1 row)
a|p
10|0.5000
20|0.7500
30|0.0000
(3 rows)
remove_provenance

(1 row)
a|p
10|0.5000
20|0.2500
30|1.0000
(3 rows)
remove_provenance

(1 row)
a|p
10|0.0000
20|0.7500
30|0.0000
(3 rows)
add_provenance

(1 row)
add_provenance

(1 row)
remove_provenance

(1 row)
a|p
100|0.5000
200|0.0000
300|0.0000
(3 rows)
add_provenance

(1 row)
add_provenance

(1 row)
remove_provenance

(1 row)
a|sorted|p
10|{100,NULL}|1.0000
20|{200,201}|1.0000
30||1.0000
(3 rows)
add_provenance

(1 row)
add_provenance

(1 row)
add_provenance

(1 row)
remove_provenance

(1 row)
a|p
10|0.2500
20|0.2500
30|0.0000
(3 rows)
remove_provenance

(1 row)
a|c
10|1 (*)
20|1 (*)
30|0 (*)
(3 rows)
add_provenance

(1 row)
add_provenance

(1 row)
remove_provenance

(1 row)
a|c|p
10|3 (*)|1.0000
20|3 (*)|1.0000
(2 rows)
remove_provenance

(1 row)
a|p
10|0.5000
20|0.5000
(2 rows)
remove_provenance

(1 row)
a|v
10|100 (*)
20|100 (*)
(2 rows)
add_provenance

(1 row)
add_provenance

(1 row)
remove_provenance

(1 row)
a|p
10|0.8750
20|0.8750
(2 rows)
remove_provenance

(1 row)
a|p
10|0.7500
20|0.7500
(2 rows)
remove_provenance

(1 row)
a|p
10|0.5000
20|0.5000
(2 rows)
remove_provenance

(1 row)
a|p
10|0.0000
20|0.0000
(2 rows)
remove_provenance

(1 row)
a|p
10|0.7500
20|0.7500
(2 rows)
add_provenance

(1 row)
add_provenance

(1 row)
remove_provenance

(1 row)
a|p
10|0.1250
10|0.1250
20|0.1250
(3 rows)
remove_provenance

(1 row)
a|p
10|0.2500
10|0.2500
20|0.2500
(3 rows)
remove_provenance

(1 row)
a|p
20|0.1250
(1 row)
add_provenance

(1 row)
add_provenance

(1 row)
remove_provenance

(1 row)
a|p
10|0.5000
20|0.5000
(2 rows)
remove_provenance

(1 row)
a|p
10|0.1250
20|0.1250
(2 rows)
remove_provenance

(1 row)
a|p
10|0.5000
20|0.5000
(2 rows)
remove_provenance

(1 row)
a|p
10|0.3750
20|0.3750
(2 rows)
add_provenance

(1 row)
add_provenance

(1 row)
remove_provenance

(1 row)
a|p
10|0.2500
20|0.2500
(2 rows)
add_provenance

(1 row)
remove_provenance

(1 row)
a|p
10|0.5000
20|0.5000
(2 rows)
remove_provenance

(1 row)
a|v|p
10|1|0.5000
20|2|0.5000
30||0.5000
(3 rows)
add_provenance

(1 row)
add_provenance

(1 row)
remove_provenance

(1 row)
k|p
1|0.5000
2|0.2500
3|1.0000
(3 rows)
remove_provenance

(1 row)
k|p
1|0.1250
2|0.2500
3|1.0000
(3 rows)
remove_provenance

(1 row)
k|p
1|0.5000
2|0.5000
3|0.0000
(3 rows)
add_provenance

(1 row)
add_provenance

(1 row)
remove_provenance

(1 row)
name|latest|p
Alice|100 (*)|1.0000
Bob|300 (*)|1.0000
(2 rows)
remove_provenance

(1 row)
name|earliest
Alice|200 (*)
Bob|300 (*)
(2 rows)
add_provenance

(1 row)
add_provenance

(1 row)
remove_provenance

(1 row)
a|v|p
10|100 (*)|1.0000
20|200 (*)|1.0000
30|300 (*)|0.7500
(3 rows)
add_provenance

(1 row)
add_provenance

(1 row)
WARNING:  ProvSQL: scalar subquery nested in an expression is not tracked; its data is treated as certain and the result keeps only the outer provenance
remove_provenance

(1 row)
a|v1|p
10|101|1.0000
20|201|1.0000
30|301|1.0000
(3 rows)
WARNING:  ProvSQL: scalar subquery nested in an expression is not tracked; its data is treated as certain and the result keeps only the outer provenance
remove_provenance

(1 row)
a|p
20|1.0000
30|1.0000
(2 rows)
add_provenance

(1 row)
add_provenance

(1 row)
remove_provenance

(1 row)
a|v1|v2|p
1|100 (*)|1000 (*)|1.0000
2|200 (*)|2000 (*)|0.7500
3|300 (*)|3000 (*)|1.0000
4|||1.0000
(4 rows)
add_provenance

(1 row)
add_provenance

(1 row)
remove_provenance

(1 row)
t|a|p
gt50|1|0.5000
gt50|2|0.5000
gt50|3|0.5000
(3 rows)
remove_provenance

(1 row)
t|a|p
gt500|1|0.0000
gt500|2|0.0000
gt500|3|0.0000
(3 rows)
add_provenance

(1 row)
add_provenance

(1 row)
remove_provenance

(1 row)
a|asc_arr
1|{1,2,3} (*)
2|{40,50} (*)
3|
(3 rows)
remove_provenance

(1 row)
a|desc_arr
1|{3,2,1} (*)
2|{50,40} (*)
3|
(3 rows)
add_provenance

(1 row)
add_provenance

(1 row)
add_provenance

(1 row)
remove_provenance

(1 row)
a|p
1|1.0000
2|0.7500
3|1.0000
(3 rows)
remove_provenance

(1 row)
a|p
1|0.0000
2|0.2500
3|0.0000
(3 rows)
remove_provenance

(1 row)
a|p
1|1.0000
2|0.7500
3|1.0000
(3 rows)
remove_provenance

(1 row)
a|p
1|1.0000
2|0.7500
3|1.0000
(3 rows)
remove_provenance

(1 row)
a|p
1|1.0000
2|1.0000
3|1.0000
(3 rows)
add_provenance

(1 row)
add_provenance

(1 row)
remove_provenance

(1 row)
a|p
1|0.7500
2|0.5000
3|0.5000
(3 rows)
remove_provenance

(1 row)
a|p
1|0.7500
2|0.5000
3|0.7500
(3 rows)
remove_provenance

(1 row)
a|p
1|0.0000
2|0.2500
3|0.0000
(3 rows)
remove_provenance

(1 row)
a|p
1|0.7500
2|0.2500
3|0.0000
(3 rows)
remove_provenance

(1 row)
a|p
1|0.2500
(1 row)
remove_provenance

(1 row)
a|p
1|0.5000
(1 row)
remove_provenance

(1 row)
a|p
1|0.7500
2|0.5000
3|0.5000
(3 rows)