\set ECHO none add_provenance (1 row) WARNING: ProvSQL: converting agg_token to text: provenance information is lost DETAIL: provsql-reason: stored-agg-token-conversion; scope: deliberate q|g|c|rk|e_rank window over a subquery|1|2|1|1.166667 window over a subquery|2|1|3|1.500000 window over a subquery|3|2|1|1.166667 (3 rows) WARNING: ProvSQL: converting agg_token to text: provenance information is lost DETAIL: provsql-reason: stored-agg-token-conversion; scope: deliberate q|g|c|rk|e_rank window over its own aggregates|1|2|1|1.166667 window over its own aggregates|2|1|3|1.500000 window over its own aggregates|3|2|1|1.166667 (3 rows) q|same same tokens as (a)|t (1 row) WARNING: ProvSQL: converting agg_token to text: provenance information is lost DETAIL: provsql-reason: stored-agg-token-conversion; scope: deliberate q|g|c|rk|e_rank window over its own aggregates, ordered|1|2|1|1.166667 window over its own aggregates, ordered|2|1|3|1.500000 window over its own aggregates, ordered|3|2|1|1.166667 (3 rows) WARNING: ProvSQL: row_number() over an aggregate result is tracked as rank(), which it differs from when groups tie on the ORDER BY DETAIL: provsql-reason: row-number-over-aggregate-as-rank; scope: deliberate 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 WARNING: ProvSQL: converting agg_token to text: provenance information is lost DETAIL: provsql-reason: stored-agg-token-conversion; scope: deliberate q|g|c|p top 2|1|2|0.750000 top 2|2|1|0.468750 top 2|3|2|0.750000 (3 rows) WARNING: ProvSQL: converting agg_token to text: provenance information is lost DETAIL: provsql-reason: stored-agg-token-conversion; scope: deliberate q|g|dr|e_dense dense_rank|1|2|1.250000 dense_rank|2|1|1.000000 dense_rank|3|2|1.250000 (3 rows) add_provenance (1 row) WARNING: ProvSQL: converting agg_token to text: provenance information is lost DETAIL: provsql-reason: stored-agg-token-conversion; scope: deliberate q|part|g|dr|e_dense dense_rank per partition|x|1|2|1.166667 dense_rank per partition|x|2|1|1.000000 dense_rank per partition|y|3|2|1.166667 dense_rank per partition|y|4|1|1.000000 (4 rows) WARNING: ProvSQL: converting agg_token to text: provenance information is lost DETAIL: provsql-reason: stored-agg-token-conversion; scope: deliberate q|g|dr|e_dense dense_rank over a sum|1|3|2.166667 dense_rank over a sum|2|1|1.000000 dense_rank over a sum|3|2|1.583333 (3 rows) WARNING: ProvSQL: row_number() over an aggregate result is tracked as rank(), which it differs from when groups tie on the ORDER BY DETAIL: provsql-reason: row-number-over-aggregate-as-rank; scope: deliberate 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 WARNING: ProvSQL: converting agg_token to text: provenance information is lost DETAIL: provsql-reason: stored-agg-token-conversion; scope: deliberate q|g|c|p top 2 by an arithmetic key|1|3|0.750000 top 2 by an arithmetic key|2|2|0.468750 top 2 by an arithmetic key|3|3|0.750000 (3 rows) 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 k|r|p 1|1|0.750000 2|2|0.500000 (2 rows) remove_provenance (1 row) 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 c|rk |1 (1 row) remove_provenance (1 row) 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 pid|r 1|2 2|3 3|1 (3 rows) remove_provenance (1 row) add_provenance (1 row) remove_provenance (1 row) q|k|p dense_rank ASC NULLS FIRST|1|0.375000 dense_rank ASC NULLS FIRST|2|0.625000 dense_rank ASC NULLS FIRST|3|0.031250 rank DESC|1|0.437500 rank DESC|2|0.312500 rank DESC|3|0.281250 (6 rows) remove_provenance (1 row) add_provenance (1 row) add_provenance (1 row) remove_provenance (1 row) WARNING: ProvSQL: row_number() over an aggregate result is tracked as rank(), which it differs from when groups tie on the ORDER BY DETAIL: provsql-reason: row-number-over-aggregate-as-rank; scope: deliberate remove_provenance (1 row) remove_provenance (1 row) remove_provenance (1 row) add_provenance (1 row) add_provenance (1 row) remove_provenance (1 row) p|n|rk 0.500000|1.500000|1.500000 0.500000|1.500000|1.500000 (2 rows) remove_provenance (1 row) remove_provenance (1 row) add_provenance (1 row) WARNING: ProvSQL: row_number() over an aggregate result is tracked as rank(), which it differs from when groups tie on the ORDER BY DETAIL: provsql-reason: row-number-over-aggregate-as-rank; scope: deliberate 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) deposit_id|p 1|0.000000 2|0.250000 3|0.250000 4|0.125000 5|0.125000 (5 rows) remove_provenance (1 row)