\set ECHO none
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
remove_provenance

(1 row)
q|g|p
choose bool|A|0.5000
choose bool|B|0.5000
(2 rows)
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)
q|g|p
choose date|A|0.5000
choose date|B|0.5000
(2 rows)
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
remove_provenance

(1 row)
q|g|p
choose = max|A|0.5000
choose = max|B|0.5000
(2 rows)
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)
q|g|p
choose < max|A|0.2500
choose < max|B|0.0000
(2 rows)