\set ECHO none add_provenance (1 row) q|exact|probabilities whole partition|t|{0.182000000,0.428000000,0.532000000,0.400000000,0.000000000,0.000000000} (1 row) q|exact|probabilities whole table|t|{0.145600000,0.313720000,0.376600000,0.266800000,0.349200000,0.415800000} (1 row) q|exact|probabilities whole partition, ROWS|t|{0.110000000,0.242000000,0.322000000,0.340000000,0.000000000,0.000000000} (1 row) q|exact|probabilities running sum, peers included|t|{0.000000000,0.380000000,0.420000000,0.400000000,0.000000000,0.000000000} (1 row) q|exact|probabilities running count|t|{0.200000000,0.430000000,0.630000000,0.220000000,0.600000000,0.900000000} (1 row) q|exact|probabilities running count, descending|t|{0.090000000,0.360000000,0.560000000,0.400000000,0.600000000,0.900000000} (1 row) q|exact|probabilities count of a nullable column|t|{0.036000000,0.306000000,0.336000000,0.096000000,0.600000000,0.900000000} (1 row) q|exact|probabilities count(*) with FILTER|t|{0.174800000,0.404600000,0.499800000,0.334800000,0.349200000,0.559800000} (1 row) q|exact|probabilities sum with FILTER|t|{0.164000000,0.242000000,0.364000000,0.400000000,0.000000000,0.000000000} (1 row) q|exact|probabilities running max|t|{0.000000000,0.500000000,0.700000000,0.400000000,0.000000000,0.000000000} (1 row) q|exact|probabilities min|t|{0.200000000,0.100000000,0.140000000,0.080000000,0.600000000,0.900000000} (1 row) q|exact|probabilities avg|t|{0.080000000,0.440000000,0.616000000,0.400000000,0.000000000,0.000000000} (1 row) q|exact|probabilities ratio of two counts|t|{0.018000000,0.452000000,0.588000000,0.400000000,0.060000000,0.900000000} (1 row) q|exact|probabilities ratio of two sums|t|{0.018000000,0.328000000,0.448000000,0.400000000,0.060000000,0.900000000} (1 row) q|exact|probabilities cume_dist over a partition|t|{0.018000000,0.452000000,0.588000000,0.400000000,0.060000000,0.900000000} (1 row) q|exact|probabilities cume_dist, whole table|t|{0.183840000,0.500000000,0.700000000,0.400000000,0.061560000,0.556200000} (1 row) q|exact|probabilities cume_dist, descending|t|{0.200000000,0.400000000,0.560000000,0.048000000,0.600000000,0.360000000} (1 row) q|exact|probabilities percent_rank over a partition|t|{0.000000000,0.072000000,0.112000000,0.352000000,0.000000000,0.540000000} (1 row) q|exact|probabilities percent_rank, first of its partition|t|{0.200000000,0.400000000,0.560000000,0.048000000,0.600000000,0.360000000} (1 row) q|exact|probabilities percent_rank, whole table, descending|t|{0.143120000,0.027040000,0.057120000,0.000000000,0.595680000,0.835200000} (1 row) q|exact|probabilities ntile(2) over a partition|t|{0.000000000,0.018000000,0.280000000,0.352000000,0.000000000,0.540000000} (1 row) q|exact|probabilities ntile(4), whole table|t|{0.048600000,0.224640000,0.557200000,0.371040000,0.000000000,0.000000000} (1 row) q|exact|probabilities ntile(3), more buckets than rows in a partition|t|{0.018000000,0.328000000,0.210000000,0.400000000,0.060000000,0.900000000} (1 row) WARNING: ProvSQL: ntile() gives rows that tie on the ORDER BY the bucket of their rank, where SQL splits them between buckets DETAIL: provsql-reason: ntile-as-rank; scope: deliberate remove_provenance (1 row) WARNING: ProvSQL: converting agg_token to text: provenance information is lost DETAIL: provsql-reason: stored-agg-token-conversion; scope: deliberate id|b 1|1 2|1 3|1 4|2 5|1 6|2 (6 rows) q|exact|probabilities share of the partition|t|{0.078000000,0.360000000,0.560000000,0.400000000,0.600000000,0.900000000} (1 row) q|exact|probabilities rest of the partition|t|{0.182000000,0.410000000,0.490000000,0.340000000,0.000000000,0.000000000} (1 row) q|exact|probabilities constant added|t|{0.090000000,0.306000000,0.490000000,0.220000000,0.600000000,0.900000000} (1 row) remove_provenance (1 row) id|s|rs|rc|cy|a|ys 1|80 (*)|10 (*)|1 (*)|4 (*)|20.0000000000000000 (*)|{1,NULL,3,4} (*) 2|80 (*)|50 (*)|3 (*)|4 (*)|20.0000000000000000 (*)|{1,NULL,3,4} (*) 3|80 (*)|50 (*)|3 (*)|4 (*)|20.0000000000000000 (*)|{1,NULL,3,4} (*) 4|80 (*)|80 (*)|4 (*)|4 (*)|20.0000000000000000 (*)|{1,NULL,3,4} (*) 5|12 (*)|5 (*)|1 (*)|4 (*)|6.0000000000000000 (*)|{NULL,6} (*) 6|12 (*)|12 (*)|2 (*)|4 (*)|6.0000000000000000 (*)|{NULL,6} (*) (6 rows) id|s|rs|rc|cy|a|ys 1|80|10|1|4|20.0000000000000000|{1,NULL,3,4} 2|80|50|3|4|20.0000000000000000|{1,NULL,3,4} 3|80|50|3|4|20.0000000000000000|{1,NULL,3,4} 4|80|80|4|4|20.0000000000000000|{1,NULL,3,4} 5|12|5|1|4|6.0000000000000000|{NULL,6} 6|12|12|2|4|6.0000000000000000|{NULL,6} (6 rows) remove_provenance (1 row) remove_provenance (1 row) q|same same gate as GROUP BY|t (1 row) q|id|children running frame|1|1 running frame|2|3 running frame|3|3 running frame|4|4 running frame|5|1 running frame|6|2 (6 rows) remove_provenance (1 row) id|s 5|12 (*) 6|12 (*) 1|80 (*) 2|80 (*) 3|80 (*) 4|80 (*) (6 rows) WARNING: ProvSQL: window function read at an offset other than one, or over a frame of rows or groups with an offset: provenance not tracked, although the statement tracks wa DETAIL: provsql-reason: window-not-tracked; scope: deliberate HINT: Mark it plain() to say so. WARNING: ProvSQL: window function: provenance not tracked, although the statement tracks wa DETAIL: provsql-reason: window-not-tracked; scope: gap HINT: Mark it plain() to say so. remove_provenance (1 row) id|prev|last2 1||10 2|10|30 3|20|40 4|20|50 5||5 6|5|12 (6 rows) WARNING: ProvSQL: window function: provenance not tracked, although the statement tracks wa DETAIL: provsql-reason: window-not-tracked; scope: gap HINT: Mark it plain() to say so. WARNING: ProvSQL: window partitioned or ordered by an aggregate result: provenance not tracked, although the statement tracks wa DETAIL: provsql-reason: window-over-aggregate-frozen; scope: gap HINT: Mark it plain() to say so. WARNING: ProvSQL: aggregate result read as a plain value: provenance not tracked, although the statement tracks wa DETAIL: provsql-reason: aggregate-read-as-plain-value; scope: gap; reader: window HINT: Mark it plain() to say so. remove_provenance (1 row) g|s|total|rk a|80 (*)|92|2 b|12 (*)|92|1 (2 rows) WARNING: ProvSQL: aggregate result read as a plain value: provenance not tracked, although the statement tracks wa DETAIL: provsql-reason: aggregate-read-as-plain-value; scope: gap; reader: conditional HINT: Mark it plain() to say so. remove_provenance (1 row) id1|id2|d 1|2|0 2|3|3 3|4|4 5|6|6 (4 rows) id1|id2|d 1|2|0 2|3|3 3|4|4 5|6|6 (4 rows) q|exact|probabilities rows strictly before|t|{0.200000000,0.400000000,0.560000000,0.048000000,0.600000000,0.360000000} (1 row) q|exact|probabilities sum strictly before|t|{0.000000000,0.100000000,0.140000000,0.352000000,0.000000000,0.000000000} (1 row) q|exact|probabilities the others|t|{0.068000000,0.140000000,0.140000000,0.028000000,0.000000000,0.000000000} (1 row) q|exact|probabilities peers excluded|t|{0.110000000,0.040000000,0.056000000,0.180000000,0.000000000,0.000000000} (1 row) q|exact|probabilities GROUPS, running|t|{0.000000000,0.380000000,0.420000000,0.400000000,0.000000000,0.000000000} (1 row) q|exact|probabilities RANGE with an offset|t|{0.000000000,0.380000000,0.420000000,0.340000000,0.000000000,0.540000000} (1 row) q|exact|probabilities RANGE before the row|t|{0.000000000,0.100000000,0.140000000,0.340000000,0.000000000,0.000000000} (1 row) q|exact|probabilities rank|t|{0.200000000,0.500000000,0.700000000,0.220000000,0.600000000,0.900000000} (1 row) q|exact|probabilities rank, first|t|{0.018000000,0.300000000,0.420000000,0.400000000,0.004320000,0.064800000} (1 row) q|exact|probabilities rank, beyond|t|{0.000000000,0.000000000,0.000000000,0.180000000,0.000000000,0.000000000} (1 row) q|exact|probabilities rank, subtracted|t|{0.092000000,0.188000000,0.263200000,0.028960000,0.600000000,0.900000000} (1 row) q|exact|probabilities dense_rank|t|{0.200000000,0.500000000,0.700000000,0.332000000,0.600000000,0.900000000} (1 row) q|exact|probabilities dense_rank, equal|t|{0.000000000,0.000000000,0.000000000,0.068000000,0.000000000,0.000000000} (1 row) q|exact|probabilities dense_rank, two keys|t|{0.000000000,0.000000000,0.000000000,0.000000000,0.040800000,0.269640000} (1 row) q|exact|probabilities dense_rank, no ORDER BY|t|{0.200000000,0.500000000,0.700000000,0.400000000,0.600000000,0.900000000} (1 row) q|exact|probabilities row_number, total order|t|{0.200000000,0.500000000,0.630000000,0.220000000,0.600000000,0.900000000} (1 row) remove_provenance (1 row) id|rk|drk|rn 1|1 (*)|3 (*)|1 (*) 2|2 (*)|2 (*)|2 (*) 3|2 (*)|2 (*)|3 (*) 4|4 (*)|1 (*)|4 (*) 5|1 (*)|5 (*)|1 (*) 6|2 (*)|4 (*)|2 (*) (6 rows) id|rk|drk|rn 1|1|3|1 2|2|2|2 3|2|2|3 4|4|1|4 5|1|5|1 6|2|4|2 (6 rows) 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) id|rn 1|1 (*) 2|2 (*) 3|2 (*) 4|4 (*) 5|1 (*) 6|2 (*) (6 rows) add_provenance (1 row) NOTICE: ProvSQL: gate_cmp expression was shortcut by probability-side pre-pass (1 Poisson-binomial): provenance circuit reduced from 55 to 3 gates remove_provenance (1 row) id|p 7|0.000007894274 (1 row) remove_provenance (1 row) pairs 1 (1 row) WARNING: ProvSQL: window function read at an offset other than one, or over a frame of rows or groups with an offset: provenance not tracked, although the statement tracks wa DETAIL: provsql-reason: window-not-tracked; scope: deliberate HINT: Mark it plain() to say so. remove_provenance (1 row) id|s 1|10 2|50 3|50 4|70 5|5 6|12 (6 rows) remove_provenance (1 row) id|s 1|80 2|80 3|80 4|80 5|12 6|12 (6 rows) add_provenance (1 row) WARNING: ProvSQL: window function: provenance not tracked, although the statement tracks wa_nt DETAIL: provsql-reason: window-not-tracked; scope: gap HINT: Mark it plain() to say so. WARNING: ProvSQL: window partitioned or ordered by an aggregate result: provenance not tracked, although the statement tracks wa_nt DETAIL: provsql-reason: window-over-aggregate-frozen; scope: gap HINT: Mark it plain() to say so. remove_provenance (1 row) g|nt|pr|cd 1|1|0.0000|0.3333 2|2|1.0000|1.0000 3|1|0.5000|0.6667 (3 rows) 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) WARNING: ProvSQL: converting agg_token to text: provenance information is lost DETAIL: provsql-reason: stored-agg-token-conversion; scope: deliberate id|rid|c|rn 1|1|1|1 1||1|1 (2 rows) remove_provenance (1 row) remove_provenance (1 row) add_provenance (1 row) remove_provenance (1 row) id|p 1234|0.000000 1235|0.000000 2345|0.500000 2346|0.250000 3456|0.000000 3457|0.125000 (6 rows) remove_provenance (1 row)