\set ECHO none
remove_provenance

(1 row)
city|count
Berlin|2 (*)
New York|2 (*)
Paris|3 (*)
(3 rows)
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)
city|count
Paris|3 (*)
Berlin|2 (*)
New York|2 (*)
(3 rows)
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)
city|cnt
Paris|3 (*)
Berlin|2 (*)
New York|2 (*)
(3 rows)
remove_provenance

(1 row)
city|m
Berlin|Susan (*)
New York|Paul (*)
Paris|Nancy (*)
(3 rows)
add_provenance

(1 row)
add_provenance

(1 row)
WARNING:  ProvSQL: an order-dependent aggregate reads rows whose order the query does not determine (without ORDER BY, or tying on it, with different values): their order in the database as it is is read in every world
DETAIL:  provsql-reason: aggregate-order-undetermined; scope: deliberate
WARNING:  ProvSQL: an order-dependent aggregate reads rows whose order the query does not determine (without ORDER BY, or tying on it, with different values): their order in the database as it is is read in every world
DETAIL:  provsql-reason: aggregate-order-undetermined; scope: deliberate
WARNING:  ProvSQL: an order-dependent aggregate reads rows whose order the query does not determine (without ORDER BY, or tying on it, with different values): their order in the database as it is is read in every world
DETAIL:  provsql-reason: aggregate-order-undetermined; scope: deliberate
remove_provenance

(1 row)
remove_provenance

(1 row)
remove_provenance

(1 row)
remove_provenance

(1 row)
remove_provenance

(1 row)
q|d|v
no ORDER BY|1|a,b,c (*)
(1 row)
q|d|v
peers differ|1|{a,b,c} (*)
(1 row)
q|d|v
tie in another world only|1|a (*)
(1 row)
q|d|v
total ORDER BY|1|["a", "b", "c"] (*)
total ORDER BY|2|["x", "x"] (*)
(2 rows)
q|d|v
peers equal|2|x,x (*)
(1 row)
WARNING:  ProvSQL: window function: provenance not tracked, although the statement tracks aob
DETAIL:  provsql-reason: window-not-tracked; scope: gap
HINT:  Mark it plain() to say so.
WARNING:  ProvSQL: a window function reads rows whose order the query does not determine (lag or lead with rows tying on its ORDER BY, first_value, last_value or nth_value with tying rows of different values): the order of the database as it is is read in every world
DETAIL:  provsql-reason: window-order-undetermined; scope: deliberate
WARNING:  ProvSQL: window function: provenance not tracked, although the statement tracks aob
DETAIL:  provsql-reason: window-not-tracked; scope: gap
HINT:  Mark it plain() to say so.
WARNING:  ProvSQL: a window function reads rows whose order the query does not determine (lag or lead with rows tying on its ORDER BY, first_value, last_value or nth_value with tying rows of different values): the order of the database as it is is read in every world
DETAIL:  provsql-reason: window-order-undetermined; scope: deliberate
WARNING:  ProvSQL: window function: provenance not tracked, although the statement tracks aob
DETAIL:  provsql-reason: window-not-tracked; scope: gap
HINT:  Mark it plain() to say so.
WARNING:  ProvSQL: a window function reads rows whose order the query does not determine (lag or lead with rows tying on its ORDER BY, first_value, last_value or nth_value with tying rows of different values): the order of the database as it is is read in every world
DETAIL:  provsql-reason: window-order-undetermined; scope: deliberate
WARNING:  ProvSQL: window function: provenance not tracked, although the statement tracks aob
DETAIL:  provsql-reason: window-not-tracked; scope: gap
HINT:  Mark it plain() to say so.
WARNING:  ProvSQL: window function: provenance not tracked, although the statement tracks aob
DETAIL:  provsql-reason: window-not-tracked; scope: gap
HINT:  Mark it plain() to say so.
remove_provenance

(1 row)
remove_provenance

(1 row)
remove_provenance

(1 row)
remove_provenance

(1 row)
remove_provenance

(1 row)
add_provenance

(1 row)
add_provenance

(1 row)
WARNING:  ProvSQL: row_number() / LIMIT / DISTINCT ON is tracked as rank() (WITH TIES), which it differs from when rows tie on the ORDER BY
DETAIL:  provsql-reason: row-number-as-rank; scope: deliberate
remove_provenance

(1 row)
remove_provenance

(1 row)
remove_provenance

(1 row)
remove_provenance

(1 row)
remove_provenance

(1 row)
remove_provenance

(1 row)