\set ECHO none add_provenance (1 row) remove_provenance (1 row) WARNING: ProvSQL: converting agg_token to numeric: provenance information is lost DETAIL: provsql-reason: stored-agg-token-conversion; scope: deliberate WARNING: ProvSQL: converting agg_token to double precision: provenance information is lost DETAIL: provsql-reason: stored-agg-token-conversion; scope: deliberate WARNING: ProvSQL: converting agg_token to integer: provenance information is lost DETAIL: provsql-reason: stored-agg-token-conversion; scope: deliberate WARNING: ProvSQL: converting agg_token to bigint: provenance information is lost DETAIL: provsql-reason: stored-agg-token-conversion; scope: deliberate WARNING: ProvSQL: converting agg_token to text: provenance information is lost DETAIL: provsql-reason: stored-agg-token-conversion; scope: deliberate s_num|s_f8|s_i4|s_i8|s_txt|c_i4 42|42|42|42|42|2 (1 row) s_value 42 (1 row) WARNING: ProvSQL: aggregate result read as a plain value: provenance not tracked, although the statement tracks atc DETAIL: provsql-reason: aggregate-read-as-plain-value; scope: gap; reader: operator HINT: Mark it plain() to say so. WARNING: ProvSQL: converting agg_token to numeric: provenance information is lost DETAIL: provsql-reason: stored-agg-token-conversion; scope: deliberate remove_provenance (1 row) m|m1|m2 98|42|3 (1 row) WARNING: ProvSQL: aggregate result read as a plain value: provenance not tracked, although the statement tracks atc DETAIL: provsql-reason: aggregate-read-as-plain-value; scope: gap; reader: function HINT: Mark it plain() to say so. remove_provenance (1 row) j|c|f {"n" : 2, "vs" : [10,32]}|2!|42 (1 row) WARNING: ProvSQL: aggregate result read as a plain value: provenance not tracked, although the statement tracks atc DETAIL: provsql-reason: aggregate-read-as-plain-value; scope: gap; reader: function HINT: Mark it plain() to say so. remove_provenance (1 row) j|cc {"n" : 2}|2! (1 row) untyped_abs 0.2 (1 row) untyped_round 0 (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 a|r|f|q 42|21|42|6.48074069840786 (1 row) WARNING: ProvSQL: converting agg_token to numeric: provenance information is lost DETAIL: provsql-reason: stored-agg-token-conversion; scope: deliberate lit_num 42 (1 row) WARNING: ProvSQL: converting agg_token to integer: provenance information is lost DETAIL: provsql-reason: stored-agg-token-conversion; scope: deliberate lit_i4 42 (1 row) WARNING: ProvSQL: converting agg_token to numeric: provenance information is lost DETAIL: provsql-reason: stored-agg-token-conversion; scope: deliberate WARNING: ProvSQL: converting agg_token to double precision: provenance information is lost DETAIL: provsql-reason: stored-agg-token-conversion; scope: deliberate WARNING: ProvSQL: converting agg_token to integer: provenance information is lost DETAIL: provsql-reason: stored-agg-token-conversion; scope: deliberate WARNING: ProvSQL: converting agg_token to bigint: provenance information is lost DETAIL: provsql-reason: stored-agg-token-conversion; scope: deliberate empty_num_null|empty_f8_null|empty_i4_null|empty_i8_null|empty_value_null t|t|t|t|t (1 row) WARNING: ProvSQL: converting agg_token to numeric: provenance information is lost DETAIL: provsql-reason: stored-agg-token-conversion; scope: deliberate nullword_num_null t (1 row) ERROR: invalid input syntax for agg_token: "garbage" LINE 1: SELECT 'garbage'::provsql.agg_token; ^ add_provenance (1 row) WARNING: ProvSQL: converting agg_token to numeric: provenance information is lost DETAIL: provsql-reason: stored-agg-token-conversion; 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 a|b 12|12 15|15 18|18 (3 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 to_numeric|to_bigint|to_float 7|2|7 (1 row) to_numeric|to_bigint|to_float 7|2|7 (1 row) WARNING: ProvSQL: aggregate result read as a plain value: provenance not tracked, although the statement tracks atc_cast DETAIL: provsql-reason: aggregate-read-as-plain-value; scope: gap; reader: cast HINT: Mark it plain() to say so. t|provsql 7|d265daa9-f206-561d-845c-2a85fa0fa72c (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 m|a|e_a|b|e_b 1|1|0.666667|1|0.666667 2|1|1.000000|0|0.000000 (2 rows) n|provsql |d265daa9-f206-561d-845c-2a85fa0fa72c (1 row) shout|provsql B! (*)|d265daa9-f206-561d-845c-2a85fa0fa72c (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 WARNING: ProvSQL: ordering or grouping an aggregate result reads the value shown, not per world DETAIL: provsql-reason: agg-token-ordered-by-value; scope: deliberate g|shown 3|50 1|30 2|5 (3 rows) remove_provenance (1 row) remove_provenance (1 row) add_provenance (1 row) WARNING: ProvSQL: aggregate result read as a plain value: provenance not tracked, although the statement tracks atc_arr DETAIL: provsql-reason: aggregate-read-as-plain-value; scope: gap; reader: constructor, in-list, comparison HINT: Mark it plain() to say so. elem|arr|pct|in_list|any_arr|distinct_from|row_json|xml|provsql 3|{3,6}|66|t|t|f|{"f1":3,"f2":6}|3|d265daa9-f206-561d-845c-2a85fa0fa72c (1 row) elem|arr|pct|in_list|any_arr|distinct_from|row_json|xml 3|{3,6}|66|t|t|f|{"f1":3,"f2":6}|3 (1 row) WARNING: ProvSQL: aggregate result read as a plain value: provenance not tracked, although the statement tracks atc_arr DETAIL: provsql-reason: aggregate-read-as-plain-value; scope: gap; reader: constructor, in-list, comparison HINT: Mark it plain() to say so. arr|in_list|distinct_from|provsql {3,6}|t|f|d265daa9-f206-561d-845c-2a85fa0fa72c (1 row) WARNING: ProvSQL: aggregate result read as a plain value: provenance not tracked, although the statement tracks atc_arr DETAIL: provsql-reason: aggregate-read-as-plain-value; scope: gap; reader: cast HINT: Mark it plain() to say so. t|pct|provsql 6|6.00%|d265daa9-f206-561d-845c-2a85fa0fa72c (1 row) remove_provenance (1 row) add_provenance (1 row) WARNING: ProvSQL: aggregate result read as a plain value: provenance not tracked, although the statement tracks atc_foo DETAIL: provsql-reason: aggregate-read-as-plain-value; scope: gap; reader: other HINT: Mark it plain() to say so. remove_provenance (1 row) pos 2 6 (2 rows) remove_provenance (1 row)