\set ECHO none add_provenance (1 row) root_gate case (1 row) display 30 (*) (1 row) display_from_uuid 30 (*) (1 row) e_pick|var_pick|m2_pick 50.0000|1266.6667|3766.6667 (1 row) add_provenance (1 row) e_certain|var_certain 30.0000|0.0000 (1 row) add_provenance (1 row) display_minmax 20 (*) (1 row) e_minmax|var_minmax 14.8000|40.5600 (1 row) add_provenance (1 row) e_const|var_const 12.5000|168.7500 (1 row) display_default 0 (*) (1 row) add_provenance (1 row) display_arith 330 (*) (1 row) arith_branch_mc_close t (1 row) add_provenance (1 row) e_cond_defined|var_cond_defined 73.3333|2022.2222 (1 row) never_defined_null t (1 row) add_provenance (1 row) g|p|p_type 1|110 (*)|agg_token (1 row) add_provenance (1 row) add_provenance (1 row) WARNING: ProvSQL: aggregate result read as a plain value: provenance not tracked, although the statement tracks cn_t DETAIL: provsql-reason: aggregate-read-as-plain-value; scope: gap; reader: conditional HINT: Mark it plain() to say so. remove_provenance (1 row) WARNING: ProvSQL: converting agg_token to text: provenance information is lost DETAIL: provsql-reason: stored-agg-token-conversion; scope: deliberate tag|s|e_s|d a|20|20.0000|01-01-2021 a|20|20.0000|01-01-2020 a|20|20.0000|01-01-2021 b||| b|||01-01-2019 b||| c||| c||| c||| (9 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 tag|s a| b|30 (2 rows) add_provenance (1 row) WARNING: ProvSQL: aggregate result read as a plain value: provenance not tracked, although the statement tracks cc DETAIL: provsql-reason: aggregate-read-as-plain-value; scope: gap; reader: conditional HINT: Mark it plain() to say so. WARNING: ProvSQL: converting agg_token to text: provenance information is lost DETAIL: provsql-reason: stored-agg-token-conversion; scope: deliberate g|s0|e_s0|var_s0|mx|e_mx|cnt|dflt_var|three|p 1|5|3.333333|5.555556|5|3.000000|2|5|5|0.750000 2|0|0.000000|0.000000|-1|-1.000000|2|2|0|0.750000 3|7|7.000000|0.000000|7|7.000000|1|7|7|0.500000 (3 rows) WARNING: ProvSQL: converting agg_token to text: provenance information is lost DETAIL: provsql-reason: stored-agg-token-conversion; scope: deliberate g|gt|e_gt|ls|e_ls 1|5|4.000000|2|2.000000 2|2|2.000000|2|2.000000 3|7|7.000000|2|2.000000 (3 rows) WARNING: ProvSQL: converting agg_token to text: provenance information is lost DETAIL: provsql-reason: stored-agg-token-conversion; scope: deliberate gt|ls 2|2 (1 row) add_provenance (1 row) WARNING: ProvSQL: converting agg_token to text: provenance information is lost DETAIL: provsql-reason: stored-agg-token-conversion; scope: deliberate g|n3|e_n3|n1|p 1||1.500000|2|0.750000 2|5|5.000000||0.500000 (2 rows) WARNING: ProvSQL: aggregate result read as a plain value: provenance not tracked, although the statement tracks cn DETAIL: provsql-reason: aggregate-read-as-plain-value; scope: gap; reader: conditional HINT: Mark it plain() to say so. n|provsql 3|d265daa9-f206-561d-845c-2a85fa0fa72c (1 row) remove_provenance (1 row) add_provenance (1 row) WARNING: ProvSQL: converting agg_token to text: provenance information is lost DETAIL: provsql-reason: stored-agg-token-conversion; scope: deliberate gt|e_gt|ls|e_ls 14|10.250000|9|8.000000 (1 row) WARNING: ProvSQL: converting agg_token to text: provenance information is lost DETAIL: provsql-reason: stored-agg-token-conversion; scope: deliberate gl|e_gl|lg|e_lg 4|3.750000|6|5.250000 (1 row) remove_provenance (1 row) q|p 3 < greatest|0.500000 coalesce > 3|0.500000 greatest > 3|0.500000 greatest > least|0.250000 (4 rows) remove_provenance (1 row) add_provenance (1 row) WARNING: ProvSQL: converting agg_token to text: provenance information is lost DETAIL: provsql-reason: stored-agg-token-conversion; scope: deliberate g|gl|e_gl 1|4|3.666667 2|4|4.000000 (2 rows) remove_provenance (1 row) add_provenance (1 row) remove_provenance (1 row) q|p coalesce IS NULL|0.000000 greatest IS NOT NULL|0.500000 greatest IS NULL|0.250000 sum * 2 IS NULL|0.250000 (4 rows) remove_provenance (1 row) add_provenance (1 row) remove_provenance (1 row) k|p 1|0.375000 2|0.250000 (2 rows) remove_provenance (1 row) add_provenance (1 row) remove_provenance (1 row) q|p coalesce = 0|0.000000 greatest = 0|0.000000 not coalesce >= 25|0.500000 (3 rows) remove_provenance (1 row) q|ok|p grouped|f|0.500000 grouped|t|0.250000 scalar|f|0.750000 scalar|t|0.250000 (4 rows) remove_provenance (1 row) g|ok|p 1|f|0.750000 1|t|0.250000 2|f|1.000000 2|t|0.000000 (4 rows) remove_provenance (1 row) or_alone|or_false|or_int_0|or_int_5|or_bigint_5|and_alone|and_true 0.666667|0.500000|0.500000|1.750000|1.750000|0.333333|0.500000 (1 row) remove_provenance (1 row) agg_case_done ok (1 row)