\set ECHO none
add_provenance

(1 row)
add_provenance

(1 row)
cols
a,b,e,provsql
(1 row)
cols
x,y,z,provsql
(1 row)
remove_provenance

(1 row)
x|y|z
1|10|-1
2|20|-2
(2 rows)
remove_provenance

(1 row)
a|b|e
2|20|-2
1|10|-1
(2 rows)
remove_provenance

(1 row)
a
1
2
(2 rows)
remove_provenance

(1 row)
a|c
2|4
1|5
(2 rows)
remove_provenance

(1 row)
a|j|s|r|rb
1|{"a":1,"b":10}|(1,10)|(1,10)|10
2|{"a":2,"b":20}|(2,20)|(2,20)|20
(2 rows)
format_type
star_t
(1 row)
WARNING:  ProvSQL: aggregate result read as a plain value: provenance not tracked, although the statement tracks star_t
DETAIL:  provsql-reason: aggregate-read-as-plain-value; scope: gap; reader: cast
HINT:  Mark it plain() to say so.
remove_provenance

(1 row)
j
[{"a":1,"b":10}, 
 {"a":2,"b":20}]
(1 row)
remove_provenance

(1 row)
a|j
1|{"a":1,"c":5}
2|
(2 rows)
remove_provenance

(1 row)
jx|jw
{"a":1,"b":10}|{"a":1,"b":10}
{"a":2,"b":20}|{"a":2,"b":20}
(2 rows)
WARNING:  ProvSQL: aggregate result read as a plain value: provenance not tracked, although the statement tracks star_t
DETAIL:  provsql-reason: aggregate-read-as-plain-value; scope: gap; reader: constructor
HINT:  Mark it plain() to say so.
remove_provenance

(1 row)
j
{"a":1,"n":1}
{"a":2,"n":1}
(2 rows)
add_provenance

(1 row)
add_provenance

(1 row)
remove_provenance

(1 row)
t|l|r
case|1|1
case|2|2
eq|1|1
eq|2|2
in|1|
in|2|
join|1|1
join|3|3
not-distinct|1|1
not-distinct|2|2
row-eq|1|1
row-eq|2|2
row-lt|1|2
row-lt|1|4
row-lt|2|4
row-lt|3|4
self-ne|1|2
self-ne|1|3
self-ne|2|1
self-ne|2|3
self-ne|3|1
self-ne|3|2
star|1|1
star|2|2
text|1|1
text|3|3
(26 rows)
remove_provenance

(1 row)
id|bid|same
1|1|t
1|3|f
2|1|f
2|3|f
3|1|f
3|3|t
(6 rows)
remove_provenance

(1 row)
WARNING:  ProvSQL: converting agg_token to text: provenance information is lost
DETAIL:  provsql-reason: stored-agg-token-conversion; scope: deliberate
a|n
(1,x)|2
(2,y)|1
(3,z)|1
(3 rows)
remove_provenance

(1 row)
remove_provenance

(1 row)