diff -U3 /tmp/cirrus-ci-build/src/pl/plpython/expected/plpython_spi.out /tmp/cirrus-ci-build/build/testrun/plpython/regress/results/plpython_spi.out --- /tmp/cirrus-ci-build/src/pl/plpython/expected/plpython_spi.out 2024-03-27 22:35:14.170087000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/plpython/regress/results/plpython_spi.out 2024-03-27 22:52:58.824021000 +0000 @@ -157,6 +157,7 @@ return None $$ LANGUAGE plpython3u; SELECT result_metadata_test($$SELECT 1 AS foo, '11'::text AS bar UNION SELECT 2, '22'$$); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: True INFO: ['foo', 'bar'] INFO: [23, 25] @@ -191,6 +192,7 @@ (1 row) SELECT result_nrows_test($$INSERT INTO foo2 VALUES (1, 'one'), (2, 'two')$$); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree result_nrows_test ------------------- 2 @@ -220,6 +222,7 @@ (1 row) SELECT result_len_test($$INSERT INTO foo3 VALUES (1, 'one'), (2, 'two')$$); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree result_len_test ----------------- 0 @@ -256,6 +259,7 @@ $$ LANGUAGE plpython3u; SELECT result_subscript_test(); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: 2 INFO: 4 INFO: [2, 3] @@ -287,6 +291,7 @@ return str(result) $$ LANGUAGE plpython3u; SELECT result_str_test($$SELECT 1 AS foo UNION SELECT 2$$); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree result_str_test ------------------------------------------------------------ diff -U3 /tmp/cirrus-ci-build/src/pl/plpython/expected/plpython_setof.out /tmp/cirrus-ci-build/build/testrun/plpython/regress/results/plpython_setof.out --- /tmp/cirrus-ci-build/src/pl/plpython/expected/plpython_setof.out 2024-03-27 22:35:14.169937000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/plpython/regress/results/plpython_setof.out 2024-03-27 22:52:58.989282000 +0000 @@ -166,6 +166,7 @@ (4 rows) SELECT * FROM get_user_records(); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree fname | lname | username | userid --------+-------+----------+-------- jane | doe | j_doe | 1 @@ -190,6 +191,7 @@ (4 rows) SELECT * FROM get_user_records2(); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree fname | lname | username | userid --------+-------+----------+-------- jane | doe | j_doe | 1 diff -U3 /tmp/cirrus-ci-build/src/pl/plpython/expected/plpython_record.out /tmp/cirrus-ci-build/build/testrun/plpython/regress/results/plpython_record.out --- /tmp/cirrus-ci-build/src/pl/plpython/expected/plpython_record.out 2024-03-27 22:35:14.169782000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/plpython/regress/results/plpython_record.out 2024-03-27 22:52:59.037019000 +0000 @@ -53,264 +53,308 @@ $$ LANGUAGE plpython3u; -- Test tuple returning functions SELECT * FROM test_table_record_as('dict', null, null, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- | (1 row) SELECT * FROM test_table_record_as('dict', 'one', null, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- one | (1 row) SELECT * FROM test_table_record_as('dict', null, 2, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- | 2 (1 row) SELECT * FROM test_table_record_as('dict', 'three', 3, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- three | 3 (1 row) SELECT * FROM test_table_record_as('dict', null, null, true); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- | (1 row) SELECT * FROM test_table_record_as('tuple', null, null, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- | (1 row) SELECT * FROM test_table_record_as('tuple', 'one', null, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- one | (1 row) SELECT * FROM test_table_record_as('tuple', null, 2, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- | 2 (1 row) SELECT * FROM test_table_record_as('tuple', 'three', 3, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- three | 3 (1 row) SELECT * FROM test_table_record_as('tuple', null, null, true); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- | (1 row) SELECT * FROM test_table_record_as('list', null, null, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- | (1 row) SELECT * FROM test_table_record_as('list', 'one', null, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- one | (1 row) SELECT * FROM test_table_record_as('list', null, 2, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- | 2 (1 row) SELECT * FROM test_table_record_as('list', 'three', 3, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- three | 3 (1 row) SELECT * FROM test_table_record_as('list', null, null, true); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- | (1 row) SELECT * FROM test_table_record_as('obj', null, null, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- | (1 row) SELECT * FROM test_table_record_as('obj', 'one', null, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- one | (1 row) SELECT * FROM test_table_record_as('obj', null, 2, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- | 2 (1 row) SELECT * FROM test_table_record_as('obj', 'three', 3, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- three | 3 (1 row) SELECT * FROM test_table_record_as('obj', null, null, true); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- | (1 row) SELECT * FROM test_type_record_as('dict', null, null, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- | (1 row) SELECT * FROM test_type_record_as('dict', 'one', null, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- one | (1 row) SELECT * FROM test_type_record_as('dict', null, 2, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- | 2 (1 row) SELECT * FROM test_type_record_as('dict', 'three', 3, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- three | 3 (1 row) SELECT * FROM test_type_record_as('dict', null, null, true); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- | (1 row) SELECT * FROM test_type_record_as('tuple', null, null, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- | (1 row) SELECT * FROM test_type_record_as('tuple', 'one', null, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- one | (1 row) SELECT * FROM test_type_record_as('tuple', null, 2, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- | 2 (1 row) SELECT * FROM test_type_record_as('tuple', 'three', 3, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- three | 3 (1 row) SELECT * FROM test_type_record_as('tuple', null, null, true); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- | (1 row) SELECT * FROM test_type_record_as('list', null, null, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- | (1 row) SELECT * FROM test_type_record_as('list', 'one', null, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- one | (1 row) SELECT * FROM test_type_record_as('list', null, 2, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- | 2 (1 row) SELECT * FROM test_type_record_as('list', 'three', 3, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- three | 3 (1 row) SELECT * FROM test_type_record_as('list', null, null, true); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- | (1 row) SELECT * FROM test_type_record_as('obj', null, null, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- | (1 row) SELECT * FROM test_type_record_as('obj', 'one', null, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- one | (1 row) SELECT * FROM test_type_record_as('obj', null, 2, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- | 2 (1 row) SELECT * FROM test_type_record_as('obj', 'three', 3, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- three | 3 (1 row) SELECT * FROM test_type_record_as('obj', null, null, true); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- | (1 row) SELECT * FROM test_type_record_as('str', 'one', 1, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- 'one' | 1 (1 row) SELECT * FROM test_in_out_params('test_in'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree second ------------------- test_in_in_to_out (1 row) SELECT * FROM test_in_out_params_multi('test_in'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree second | third ----------------------------+---------------------------- test_in_record_in_to_out_1 | test_in_record_in_to_out_2 (1 row) SELECT * FROM test_inout_params('test_in'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first --------------- test_in_inout @@ -322,6 +366,7 @@ ALTER TABLE table_record ADD COLUMN first text; ALTER TABLE table_record ADD COLUMN second int4; SELECT * FROM test_table_record_as('obj', 'one', 1, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- one | 1 @@ -332,6 +377,7 @@ ALTER TYPE type_record ADD ATTRIBUTE first text; ALTER TYPE type_record ADD ATTRIBUTE second int4; SELECT * FROM test_type_record_as('obj', 'one', 1, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- one | 1 @@ -342,6 +388,7 @@ return { 'first': 'first' } $$ LANGUAGE plpython3u; SELECT * FROM test_type_record_error1(); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ERROR: key "second" not found in mapping HINT: To return null in a column, add the value None to the mapping with the key named after the column. CONTEXT: while creating return value @@ -350,6 +397,7 @@ return [ 'first' ] $$ LANGUAGE plpython3u; SELECT * FROM test_type_record_error2(); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ERROR: length of returned sequence did not match number of columns in row CONTEXT: while creating return value PL/Python function "test_type_record_error2" @@ -359,6 +407,7 @@ return type_record $$ LANGUAGE plpython3u; SELECT * FROM test_type_record_error3(); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ERROR: attribute "second" does not exist in Python object HINT: To return null in a column, let the returned object have an attribute named after column with value None. CONTEXT: while creating return value @@ -367,6 +416,7 @@ return 'foo' $$ LANGUAGE plpython3u; SELECT * FROM test_type_record_error4(); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ERROR: malformed record literal: "foo" DETAIL: Missing left parenthesis. CONTEXT: while creating return value diff -U3 /tmp/cirrus-ci-build/src/pl/plpython/expected/plpython_trigger.out /tmp/cirrus-ci-build/build/testrun/plpython/regress/results/plpython_trigger.out --- /tmp/cirrus-ci-build/src/pl/plpython/expected/plpython_trigger.out 2024-03-27 22:35:14.170623000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/plpython/regress/results/plpython_trigger.out 2024-03-27 22:52:59.146538000 +0000 @@ -295,6 +295,7 @@ NOTICE: TD[table_schema] => public NOTICE: TD[when] => INSTEAD OF update trigger_test_view set v = 'update' where i = 1; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree NOTICE: TD[args] => ['24', 'skidoo view'] NOTICE: TD[event] => UPDATE NOTICE: TD[level] => ROW @@ -306,6 +307,7 @@ NOTICE: TD[table_schema] => public NOTICE: TD[when] => INSTEAD OF delete from trigger_test_view; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree NOTICE: TD[args] => ['24', 'skidoo view'] NOTICE: TD[event] => DELETE NOTICE: TD[level] => ROW @@ -595,7 +597,9 @@ REFERENCING OLD TABLE AS old_table NEW TABLE AS new_table FOR EACH STATEMENT EXECUTE PROCEDURE transition_table_test_f(); UPDATE transition_table_test SET name = 'b'; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: old: 1 -> a +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: new: 1 -> b DROP TABLE transition_table_test; DROP FUNCTION transition_table_test_f(); diff -U3 /tmp/cirrus-ci-build/src/pl/plpython/expected/plpython_types.out /tmp/cirrus-ci-build/build/testrun/plpython/regress/results/plpython_types.out --- /tmp/cirrus-ci-build/src/pl/plpython/expected/plpython_types.out 2024-03-27 22:35:14.171003000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/plpython/regress/results/plpython_types.out 2024-03-27 22:52:59.261357000 +0000 @@ -9,6 +9,7 @@ return x $$ LANGUAGE plpython3u; SELECT * FROM test_type_conversion_bool(true); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: (True, ) test_type_conversion_bool --------------------------- @@ -16,6 +17,7 @@ (1 row) SELECT * FROM test_type_conversion_bool(false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: (False, ) test_type_conversion_bool --------------------------- @@ -23,6 +25,7 @@ (1 row) SELECT * FROM test_type_conversion_bool(null); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: (None, ) test_type_conversion_bool --------------------------- @@ -50,6 +53,7 @@ return ret $$ LANGUAGE plpython3u; SELECT * FROM test_type_conversion_bool_other(0); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: (0, False) test_type_conversion_bool_other --------------------------------- @@ -57,6 +61,7 @@ (1 row) SELECT * FROM test_type_conversion_bool_other(1); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: (5, True) test_type_conversion_bool_other --------------------------------- @@ -64,6 +69,7 @@ (1 row) SELECT * FROM test_type_conversion_bool_other(2); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: ('', False) test_type_conversion_bool_other --------------------------------- @@ -71,6 +77,7 @@ (1 row) SELECT * FROM test_type_conversion_bool_other(3); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: ('fa', True) test_type_conversion_bool_other --------------------------------- @@ -78,6 +85,7 @@ (1 row) SELECT * FROM test_type_conversion_bool_other(4); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: ([], False) test_type_conversion_bool_other --------------------------------- @@ -85,6 +93,7 @@ (1 row) SELECT * FROM test_type_conversion_bool_other(5); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: ([0], True) test_type_conversion_bool_other --------------------------------- @@ -96,6 +105,7 @@ return x $$ LANGUAGE plpython3u; SELECT * FROM test_type_conversion_char('a'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: ('a', ) test_type_conversion_char --------------------------- @@ -103,6 +113,7 @@ (1 row) SELECT * FROM test_type_conversion_char(null); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: (None, ) test_type_conversion_char --------------------------- @@ -114,6 +125,7 @@ return x $$ LANGUAGE plpython3u; SELECT * FROM test_type_conversion_int2(100::int2); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: (100, ) test_type_conversion_int2 --------------------------- @@ -121,6 +133,7 @@ (1 row) SELECT * FROM test_type_conversion_int2(-100::int2); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: (-100, ) test_type_conversion_int2 --------------------------- @@ -128,6 +141,7 @@ (1 row) SELECT * FROM test_type_conversion_int2(null); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: (None, ) test_type_conversion_int2 --------------------------- @@ -139,6 +153,7 @@ return x $$ LANGUAGE plpython3u; SELECT * FROM test_type_conversion_int4(100); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: (100, ) test_type_conversion_int4 --------------------------- @@ -146,6 +161,7 @@ (1 row) SELECT * FROM test_type_conversion_int4(-100); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: (-100, ) test_type_conversion_int4 --------------------------- @@ -153,6 +169,7 @@ (1 row) SELECT * FROM test_type_conversion_int4(null); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: (None, ) test_type_conversion_int4 --------------------------- @@ -164,6 +181,7 @@ return x $$ LANGUAGE plpython3u; SELECT * FROM test_type_conversion_int8(100); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: (100, ) test_type_conversion_int8 --------------------------- @@ -171,6 +189,7 @@ (1 row) SELECT * FROM test_type_conversion_int8(-100); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: (-100, ) test_type_conversion_int8 --------------------------- @@ -178,6 +197,7 @@ (1 row) SELECT * FROM test_type_conversion_int8(5000000000); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: (5000000000, ) test_type_conversion_int8 --------------------------- @@ -185,6 +205,7 @@ (1 row) SELECT * FROM test_type_conversion_int8(null); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: (None, ) test_type_conversion_int8 --------------------------- @@ -198,6 +219,7 @@ return x $$ LANGUAGE plpython3u; SELECT * FROM test_type_conversion_numeric(100); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: ('100', 'Decimal') test_type_conversion_numeric ------------------------------ @@ -205,6 +227,7 @@ (1 row) SELECT * FROM test_type_conversion_numeric(-100); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: ('-100', 'Decimal') test_type_conversion_numeric ------------------------------ @@ -212,6 +235,7 @@ (1 row) SELECT * FROM test_type_conversion_numeric(100.0); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: ('100.0', 'Decimal') test_type_conversion_numeric ------------------------------ @@ -219,6 +243,7 @@ (1 row) SELECT * FROM test_type_conversion_numeric(100.00); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: ('100.00', 'Decimal') test_type_conversion_numeric ------------------------------ @@ -226,6 +251,7 @@ (1 row) SELECT * FROM test_type_conversion_numeric(5000000000.5); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: ('5000000000.5', 'Decimal') test_type_conversion_numeric ------------------------------ @@ -233,6 +259,7 @@ (1 row) SELECT * FROM test_type_conversion_numeric(1234567890.0987654321); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: ('1234567890.0987654321', 'Decimal') test_type_conversion_numeric ------------------------------ @@ -240,6 +267,7 @@ (1 row) SELECT * FROM test_type_conversion_numeric(-1234567890.0987654321); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: ('-1234567890.0987654321', 'Decimal') test_type_conversion_numeric ------------------------------ @@ -247,6 +275,7 @@ (1 row) SELECT * FROM test_type_conversion_numeric(null); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: ('None', 'NoneType') test_type_conversion_numeric ------------------------------ @@ -258,6 +287,7 @@ return x $$ LANGUAGE plpython3u; SELECT * FROM test_type_conversion_float4(100); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: (100.0, ) test_type_conversion_float4 ----------------------------- @@ -265,6 +295,7 @@ (1 row) SELECT * FROM test_type_conversion_float4(-100); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: (-100.0, ) test_type_conversion_float4 ----------------------------- @@ -272,6 +303,7 @@ (1 row) SELECT * FROM test_type_conversion_float4(5000.5); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: (5000.5, ) test_type_conversion_float4 ----------------------------- @@ -279,6 +311,7 @@ (1 row) SELECT * FROM test_type_conversion_float4(null); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: (None, ) test_type_conversion_float4 ----------------------------- @@ -290,6 +323,7 @@ return x $$ LANGUAGE plpython3u; SELECT * FROM test_type_conversion_float8(100); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: (100.0, ) test_type_conversion_float8 ----------------------------- @@ -297,6 +331,7 @@ (1 row) SELECT * FROM test_type_conversion_float8(-100); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: (-100.0, ) test_type_conversion_float8 ----------------------------- @@ -304,6 +339,7 @@ (1 row) SELECT * FROM test_type_conversion_float8(5000000000.5); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: (5000000000.5, ) test_type_conversion_float8 ----------------------------- @@ -311,6 +347,7 @@ (1 row) SELECT * FROM test_type_conversion_float8(null); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: (None, ) test_type_conversion_float8 ----------------------------- @@ -318,6 +355,7 @@ (1 row) SELECT * FROM test_type_conversion_float8(100100100.654321); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: (100100100.654321, ) test_type_conversion_float8 ----------------------------- @@ -329,6 +367,7 @@ return x $$ LANGUAGE plpython3u; SELECT * FROM test_type_conversion_oid(100); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: (100, ) test_type_conversion_oid -------------------------- @@ -336,6 +375,7 @@ (1 row) SELECT * FROM test_type_conversion_oid(2147483649); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: (2147483649, ) test_type_conversion_oid -------------------------- @@ -343,6 +383,7 @@ (1 row) SELECT * FROM test_type_conversion_oid(null); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: (None, ) test_type_conversion_oid -------------------------- @@ -354,6 +395,7 @@ return x $$ LANGUAGE plpython3u; SELECT * FROM test_type_conversion_text('hello world'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: ('hello world', ) test_type_conversion_text --------------------------- @@ -361,6 +403,7 @@ (1 row) SELECT * FROM test_type_conversion_text(null); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: (None, ) test_type_conversion_text --------------------------- @@ -372,6 +415,7 @@ return x $$ LANGUAGE plpython3u; SELECT * FROM test_type_conversion_bytea('hello world'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: (b'hello world', ) test_type_conversion_bytea ---------------------------- @@ -379,6 +423,7 @@ (1 row) SELECT * FROM test_type_conversion_bytea(E'null\\000byte'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: (b'null\x00byte', ) test_type_conversion_bytea ---------------------------- @@ -386,6 +431,7 @@ (1 row) SELECT * FROM test_type_conversion_bytea(null); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: (None, ) test_type_conversion_bytea ---------------------------- @@ -404,6 +450,7 @@ return 'FAILED: ' + str(e) $$ LANGUAGE plpython3u; SELECT test_type_unmarshal(x) FROM test_type_marshal() x; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree test_type_unmarshal --------------------- hello world @@ -417,14 +464,17 @@ return y $$ LANGUAGE plpython3u; SELECT * FROM test_type_conversion_booltrue(true, true); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree test_type_conversion_booltrue ------------------------------- t (1 row) SELECT * FROM test_type_conversion_booltrue(false, true); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ERROR: value for domain booltrue violates check constraint "booltrue_check" SELECT * FROM test_type_conversion_booltrue(true, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ERROR: value for domain booltrue violates check constraint "booltrue_check" CONTEXT: while creating return value PL/Python function "test_type_conversion_booltrue" @@ -434,6 +484,7 @@ return y $$ LANGUAGE plpython3u; SELECT * FROM test_type_conversion_uint2(100::uint2, 50); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: (100, ) test_type_conversion_uint2 ---------------------------- @@ -441,11 +492,13 @@ (1 row) SELECT * FROM test_type_conversion_uint2(100::uint2, -50); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: (100, ) ERROR: value for domain uint2 violates check constraint "uint2_check" CONTEXT: while creating return value PL/Python function "test_type_conversion_uint2" SELECT * FROM test_type_conversion_uint2(null, 1); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: (None, ) test_type_conversion_uint2 ---------------------------- @@ -457,14 +510,17 @@ return y $$ LANGUAGE plpython3u; SELECT * FROM test_type_conversion_nnint(10, 20); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree test_type_conversion_nnint ---------------------------- 20 (1 row) SELECT * FROM test_type_conversion_nnint(null, 20); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ERROR: value for domain nnint violates check constraint "nnint_check" SELECT * FROM test_type_conversion_nnint(10, null); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ERROR: value for domain nnint violates check constraint "nnint_check" CONTEXT: while creating return value PL/Python function "test_type_conversion_nnint" @@ -474,6 +530,7 @@ return y $$ LANGUAGE plpython3u; SELECT * FROM test_type_conversion_bytea10('hello wold', 'hello wold'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: (b'hello wold', ) test_type_conversion_bytea10 ------------------------------ @@ -481,15 +538,19 @@ (1 row) SELECT * FROM test_type_conversion_bytea10('hello world', 'hello wold'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ERROR: value for domain bytea10 violates check constraint "bytea10_check" SELECT * FROM test_type_conversion_bytea10('hello word', 'hello world'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: (b'hello word', ) ERROR: value for domain bytea10 violates check constraint "bytea10_check" CONTEXT: while creating return value PL/Python function "test_type_conversion_bytea10" SELECT * FROM test_type_conversion_bytea10(null, 'hello word'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ERROR: value for domain bytea10 violates check constraint "bytea10_check" SELECT * FROM test_type_conversion_bytea10('hello word', null); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: (b'hello word', ) ERROR: value for domain bytea10 violates check constraint "bytea10_check" CONTEXT: while creating return value @@ -502,6 +563,7 @@ return x $$ LANGUAGE plpython3u; SELECT * FROM test_type_conversion_array_int4(ARRAY[0, 100]); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: ([0, 100], ) test_type_conversion_array_int4 --------------------------------- @@ -509,6 +571,7 @@ (1 row) SELECT * FROM test_type_conversion_array_int4(ARRAY[0,-100,55]); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: ([0, -100, 55], ) test_type_conversion_array_int4 --------------------------------- @@ -516,6 +579,7 @@ (1 row) SELECT * FROM test_type_conversion_array_int4(ARRAY[NULL,1]); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: ([None, 1], ) test_type_conversion_array_int4 --------------------------------- @@ -523,6 +587,7 @@ (1 row) SELECT * FROM test_type_conversion_array_int4(ARRAY[]::integer[]); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: ([], ) test_type_conversion_array_int4 --------------------------------- @@ -530,6 +595,7 @@ (1 row) SELECT * FROM test_type_conversion_array_int4(NULL); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: (None, ) test_type_conversion_array_int4 --------------------------------- @@ -537,6 +603,7 @@ (1 row) SELECT * FROM test_type_conversion_array_int4(ARRAY[[1,2,3],[4,5,6]]); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: ([[1, 2, 3], [4, 5, 6]], ) test_type_conversion_array_int4 --------------------------------- @@ -544,6 +611,7 @@ (1 row) SELECT * FROM test_type_conversion_array_int4(ARRAY[[[1,2,NULL],[NULL,5,6]],[[NULL,8,9],[10,11,12]]]); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: ([[[1, 2, None], [None, 5, 6]], [[None, 8, 9], [10, 11, 12]]], ) test_type_conversion_array_int4 --------------------------------------------------- @@ -551,6 +619,7 @@ (1 row) SELECT * FROM test_type_conversion_array_int4('[2:4]={1,2,3}'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: ([1, 2, 3], ) test_type_conversion_array_int4 --------------------------------- @@ -562,6 +631,7 @@ return x $$ LANGUAGE plpython3u; SELECT * FROM test_type_conversion_array_int8(ARRAY[[[1,2,NULL],[NULL,5,6]],[[NULL,8,9],[10,11,12]]]::int8[]); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: ([[[1, 2, None], [None, 5, 6]], [[None, 8, 9], [10, 11, 12]]], ) test_type_conversion_array_int8 --------------------------------------------------- @@ -574,6 +644,7 @@ $$ LANGUAGE plpython3u; SELECT * FROM test_type_conversion_array_date(ARRAY[[['2016-09-21','2016-09-22',NULL],[NULL,'2016-10-21','2016-10-22']], [[NULL,'2016-11-21','2016-10-21'],['2015-09-21','2015-09-22','2014-09-21']]]::date[]); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: ([[['09-21-2016', '09-22-2016', None], [None, '10-21-2016', '10-22-2016']], [[None, '11-21-2016', '10-21-2016'], ['09-21-2015', '09-22-2015', '09-21-2014']]], ) test_type_conversion_array_date --------------------------------------------------------------------------------------------------------------------------------- @@ -588,6 +659,7 @@ [NULL,'2016-10-21 11:34:25.078792-04','2016-10-21 11:34:24.098792-04']], [[NULL,'2016-01-21 11:34:24.078792-04','2016-11-21 11:34:24.108792-04'], ['2015-09-21 11:34:24.079792-04','2014-09-21 11:34:24.078792-04','2013-09-21 11:34:24.078792-04']]]::timestamp[]); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: ([[['Wed Sep 21 15:34:24.078792 2016', 'Sat Oct 22 11:34:24.078795 2016', None], [None, 'Fri Oct 21 11:34:25.078792 2016', 'Fri Oct 21 11:34:24.098792 2016']], [[None, 'Thu Jan 21 11:34:24.078792 2016', 'Mon Nov 21 11:34:24.108792 2016'], ['Mon Sep 21 11:34:24.079792 2015', 'Sun Sep 21 11:34:24.078792 2014', 'Sat Sep 21 11:34:24.078792 2013']]], ) test_type_conversion_array_timestamp ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ @@ -647,6 +719,7 @@ return x $$ LANGUAGE plpython3u; SELECT * FROM test_type_conversion_array_text(ARRAY['foo', 'bar']); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: (['foo', 'bar'], ) test_type_conversion_array_text --------------------------------- @@ -654,6 +727,7 @@ (1 row) SELECT * FROM test_type_conversion_array_text(ARRAY[['foo', 'bar'],['foo2', 'bar2']]); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: ([['foo', 'bar'], ['foo2', 'bar2']], ) test_type_conversion_array_text --------------------------------- @@ -665,6 +739,7 @@ return x $$ LANGUAGE plpython3u; SELECT * FROM test_type_conversion_array_bytea(ARRAY[E'\\xdeadbeef'::bytea, NULL]); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: ([b'\xde\xad\xbe\xef', None], ) test_type_conversion_array_bytea ---------------------------------- @@ -675,6 +750,7 @@ return [123, 'abc'] $$ LANGUAGE plpython3u; SELECT * FROM test_type_conversion_array_mixed1(); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree test_type_conversion_array_mixed1 ----------------------------------- {123,abc} @@ -684,6 +760,7 @@ return [123, 'abc'] $$ LANGUAGE plpython3u; SELECT * FROM test_type_conversion_array_mixed2(); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ERROR: invalid input syntax for type integer: "abc" CONTEXT: while creating return value PL/Python function "test_type_conversion_array_mixed2" @@ -738,6 +815,7 @@ return [[1,2,3],[4,5]] $$ LANGUAGE plpython3u; SELECT * FROM test_type_conversion_mdarray_malformed(); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ERROR: multidimensional arrays must have array expressions with matching dimensions CONTEXT: while creating return value PL/Python function "test_type_conversion_mdarray_malformed" @@ -745,6 +823,7 @@ return [[1,2,3], "abc"] $$ LANGUAGE plpython3u; SELECT * FROM test_type_conversion_mdarray_malformed2(); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ERROR: multidimensional arrays must have array expressions with matching dimensions CONTEXT: while creating return value PL/Python function "test_type_conversion_mdarray_malformed2" @@ -752,6 +831,7 @@ return ["abc", [1,2,3]] $$ LANGUAGE plpython3u; SELECT * FROM test_type_conversion_mdarray_malformed3(); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ERROR: multidimensional arrays must have array expressions with matching dimensions CONTEXT: while creating return value PL/Python function "test_type_conversion_mdarray_malformed3" @@ -759,6 +839,7 @@ return [[[[[[[1]]]]]]] $$ LANGUAGE plpython3u; SELECT * FROM test_type_conversion_mdarray_toodeep(); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ERROR: number of array dimensions exceeds the maximum allowed (6) CONTEXT: while creating return value PL/Python function "test_type_conversion_mdarray_toodeep" @@ -766,6 +847,7 @@ return [{'first': 'one', 'second': 42}, {'first': 'two', 'second': 11}] $$ LANGUAGE plpython3u; SELECT * FROM test_type_conversion_array_record(); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree test_type_conversion_array_record ----------------------------------- {"(one,42)","(two,11)"} @@ -775,6 +857,7 @@ return 'abc' $$ LANGUAGE plpython3u; SELECT * FROM test_type_conversion_array_string(); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree test_type_conversion_array_string ----------------------------------- {a,b,c} @@ -784,6 +867,7 @@ return ('abc', 'def') $$ LANGUAGE plpython3u; SELECT * FROM test_type_conversion_array_tuple(); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree test_type_conversion_array_tuple ---------------------------------- {abc,def} @@ -793,6 +877,7 @@ return 5 $$ LANGUAGE plpython3u; SELECT * FROM test_type_conversion_array_error(); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ERROR: return value of function with array return type is not a Python sequence CONTEXT: while creating return value PL/Python function "test_type_conversion_array_error" @@ -805,6 +890,7 @@ return x $$ LANGUAGE plpython3u; SELECT * FROM test_type_conversion_array_domain(ARRAY[0, 100]::ordered_pair_domain); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: ([0, 100], ) test_type_conversion_array_domain ----------------------------------- @@ -812,6 +898,7 @@ (1 row) SELECT * FROM test_type_conversion_array_domain(NULL::ordered_pair_domain); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INFO: (None, ) test_type_conversion_array_domain ----------------------------------- @@ -822,6 +909,7 @@ return [2,1] $$ LANGUAGE plpython3u; SELECT * FROM test_type_conversion_array_domain_check_violation(); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ERROR: value for domain ordered_pair_domain violates check constraint "ordered_pair_domain_check" CONTEXT: while creating return value PL/Python function "test_type_conversion_array_domain_check_violation" @@ -904,6 +992,7 @@ bonus integer ); INSERT INTO employee VALUES ('John', 100, 10), ('Mary', 200, 10); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree CREATE OR REPLACE FUNCTION test_composite_table_input(e employee) RETURNS integer AS $$ return e['basesalary'] + e['bonus'] $$ LANGUAGE plpython3u; diff -U3 /tmp/cirrus-ci-build/src/pl/plpython/expected/plpython_quote.out /tmp/cirrus-ci-build/build/testrun/plpython/regress/results/plpython_quote.out --- /tmp/cirrus-ci-build/src/pl/plpython/expected/plpython_quote.out 2024-03-27 22:35:14.169650000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/plpython/regress/results/plpython_quote.out 2024-03-27 22:52:59.407390000 +0000 @@ -16,6 +16,7 @@ (''), (''''), ('xyzv')) AS v(t); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree quote ----------- 'abc' @@ -33,6 +34,7 @@ (''), (''''), (NULL)) AS v(t); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree quote ----------- 'abc' @@ -47,6 +49,7 @@ ('abc'), ('a b c'), ('a " ''abc''')) AS v(t); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree quote -------------- abc diff -U3 /tmp/cirrus-ci-build/src/pl/plpython/expected/plpython_composite.out /tmp/cirrus-ci-build/build/testrun/plpython/regress/results/plpython_composite.out --- /tmp/cirrus-ci-build/src/pl/plpython/expected/plpython_composite.out 2024-03-27 22:35:14.168104000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/plpython/regress/results/plpython_composite.out 2024-03-27 22:52:59.464498000 +0000 @@ -8,12 +8,14 @@ (1 row) SELECT * FROM multiout_simple(); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree i | j ---+--- 1 | 2 (1 row) SELECT i, j + 2 FROM multiout_simple(); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree i | ?column? ---+---------- 1 | 4 @@ -35,12 +37,14 @@ (1 row) SELECT * FROM multiout_simple_setof(); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree column1 | column2 ---------+--------- 1 | 2 (1 row) SELECT * FROM multiout_simple_setof(3); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree column1 | column2 ---------+--------- 1 | 2 @@ -69,6 +73,7 @@ return "('%s',%r)" % (first, second) $$ LANGUAGE plpython3u; SELECT * FROM multiout_record_as('dict', 'foo', 1, 'f'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- foo | 1 @@ -81,150 +86,175 @@ (1 row) SELECT * FROM multiout_record_as('dict', null, null, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- | (1 row) SELECT * FROM multiout_record_as('dict', 'one', null, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- one | (1 row) SELECT * FROM multiout_record_as('dict', null, 2, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- | 2 (1 row) SELECT * FROM multiout_record_as('dict', 'three', 3, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- three | 3 (1 row) SELECT * FROM multiout_record_as('dict', null, null, true); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- | (1 row) SELECT * FROM multiout_record_as('tuple', null, null, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- | (1 row) SELECT * FROM multiout_record_as('tuple', 'one', null, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- one | (1 row) SELECT * FROM multiout_record_as('tuple', null, 2, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- | 2 (1 row) SELECT * FROM multiout_record_as('tuple', 'three', 3, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- three | 3 (1 row) SELECT * FROM multiout_record_as('tuple', null, null, true); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- | (1 row) SELECT * FROM multiout_record_as('list', null, null, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- | (1 row) SELECT * FROM multiout_record_as('list', 'one', null, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- one | (1 row) SELECT * FROM multiout_record_as('list', null, 2, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- | 2 (1 row) SELECT * FROM multiout_record_as('list', 'three', 3, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- three | 3 (1 row) SELECT * FROM multiout_record_as('list', null, null, true); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- | (1 row) SELECT * FROM multiout_record_as('obj', null, null, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- | (1 row) SELECT * FROM multiout_record_as('obj', 'one', null, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- one | (1 row) SELECT * FROM multiout_record_as('obj', null, 2, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- | 2 (1 row) SELECT * FROM multiout_record_as('obj', 'three', 3, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- three | 3 (1 row) SELECT * FROM multiout_record_as('obj', null, null, true); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- | (1 row) SELECT * FROM multiout_record_as('str', 'one', 1, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- 'one' | 1 (1 row) SELECT * FROM multiout_record_as('str', 'one', 2, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- 'one' | 2 (1 row) SELECT *, s IS NULL AS snull FROM multiout_record_as('tuple', 'xxx', NULL, 'f') AS f(f, s); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree f | s | snull -----+---+------- xxx | | t (1 row) SELECT *, f IS NULL AS fnull, s IS NULL AS snull FROM multiout_record_as('tuple', 'xxx', 1, 't') AS f(f, s); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree f | s | fnull | snull ---+---+-------+------- | | t | t (1 row) SELECT * FROM multiout_record_as('obj', NULL, 10, 'f'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- | 10 @@ -239,6 +269,7 @@ yield power, length $$ LANGUAGE plpython3u; SELECT * FROM multiout_setof(3); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree power_of_2 | length ------------+-------- 1 | 1 @@ -262,6 +293,7 @@ {'x': 0, 'y' :'zero'}] $$ LANGUAGE plpython3u; SELECT * FROM multiout_return_table(); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree x | y ---+------- 4 | four @@ -275,6 +307,7 @@ yield [[1,2,3], None] $$ LANGUAGE plpython3u; SELECT * FROM multiout_array(); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree column1 | column2 ---------+--------- {1} | a @@ -290,12 +323,14 @@ {'first': 3, 'second': 4 }] $$ LANGUAGE plpython3u; SELECT * FROM singleout_composite(); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- 1 | 2 (1 row) SELECT * FROM multiout_composite(); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree first | second -------+-------- 1 | 2 @@ -325,12 +360,14 @@ yield (i, d) $$ LANGUAGE plpython3u; SELECT * FROM multiout_composite(2); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree n | column2 ---+--------- 2 | (4,6) (1 row) SELECT * FROM multiout_table_type_setof('dict', 'f', 3); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree n | column2 ---+--------- 0 | (6,9) @@ -339,6 +376,7 @@ (3 rows) SELECT * FROM multiout_table_type_setof('dict', 'f', 7); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree n | column2 ---+--------- 0 | (14,21) @@ -351,6 +389,7 @@ (7 rows) SELECT * FROM multiout_table_type_setof('tuple', 'f', 2); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree n | column2 ---+--------- 0 | (4,6) @@ -358,6 +397,7 @@ (2 rows) SELECT * FROM multiout_table_type_setof('tuple', 'f', 3); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree n | column2 ---+--------- 0 | (6,9) @@ -366,6 +406,7 @@ (3 rows) SELECT * FROM multiout_table_type_setof('list', 'f', 2); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree n | column2 ---+--------- 0 | (4,6) @@ -373,6 +414,7 @@ (2 rows) SELECT * FROM multiout_table_type_setof('list', 'f', 3); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree n | column2 ---+--------- 0 | (6,9) @@ -381,6 +423,7 @@ (3 rows) SELECT * FROM multiout_table_type_setof('obj', 'f', 4); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree n | column2 ---+--------- 0 | (8,12) @@ -390,6 +433,7 @@ (4 rows) SELECT * FROM multiout_table_type_setof('obj', 'f', 5); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree n | column2 ---+--------- 0 | (10,15) @@ -400,6 +444,7 @@ (5 rows) SELECT * FROM multiout_table_type_setof('str', 'f', 6); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree n | column2 ---+--------- 0 | (12,18) @@ -411,6 +456,7 @@ (6 rows) SELECT * FROM multiout_table_type_setof('str', 'f', 7); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree n | column2 ---+--------- 0 | (14,21) @@ -423,6 +469,7 @@ (7 rows) SELECT * FROM multiout_table_type_setof('dict', 't', 3); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree n | column2 ---+--------- 0 | @@ -440,6 +487,7 @@ (1, (3, 4))] $$ LANGUAGE plpython3u; SELECT * FROM changing_test(); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree n | column2 ---+--------- 1 | (1,2) @@ -448,15 +496,18 @@ ALTER TABLE changing DROP COLUMN j; SELECT * FROM changing_test(); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ERROR: length of returned sequence did not match number of columns in row CONTEXT: while creating return value PL/Python function "changing_test" SELECT * FROM changing_test(); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ERROR: length of returned sequence did not match number of columns in row CONTEXT: while creating return value PL/Python function "changing_test" ALTER TABLE changing ADD COLUMN j integer; SELECT * FROM changing_test(); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree n | column2 ---+--------- 1 | (1,2) @@ -476,6 +527,7 @@ {'first': 'fourth', 'second': 4}]} $$ LANGUAGE plpython3u; SELECT * FROM composite_types_table(); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree tab | typ ----------------------------+---------------------------- {"(first,1)","(second,2)"} | {"(third,3)","(fourth,4)"} @@ -488,36 +540,42 @@ return {'t': t, 'val': 10} $$ LANGUAGE plpython3u; SELECT * FROM return_record('abc') AS r(t text, val integer); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree t | val -----+----- abc | 10 (1 row) SELECT * FROM return_record('abc') AS r(t text, val bigint); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree t | val -----+----- abc | 10 (1 row) SELECT * FROM return_record('abc') AS r(t text, val integer); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree t | val -----+----- abc | 10 (1 row) SELECT * FROM return_record('abc') AS r(t varchar(30), val integer); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree t | val -----+----- abc | 10 (1 row) SELECT * FROM return_record('abc') AS r(t varchar(100), val integer); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree t | val -----+----- abc | 10 (1 row) SELECT * FROM return_record('999') AS r(val text, t integer); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree val | t -----+----- 10 | 999 @@ -527,24 +585,28 @@ return {'v1':1,'v2':2,t:3} $$ LANGUAGE plpython3u; SELECT * FROM return_record_2('v3') AS (v3 int, v2 int, v1 int); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree v3 | v2 | v1 ----+----+---- 3 | 2 | 1 (1 row) SELECT * FROM return_record_2('v3') AS (v2 int, v3 int, v1 int); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree v2 | v3 | v1 ----+----+---- 2 | 3 | 1 (1 row) SELECT * FROM return_record_2('v4') AS (v1 int, v4 int, v2 int); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree v1 | v4 | v2 ----+----+---- 1 | 3 | 2 (1 row) SELECT * FROM return_record_2('v4') AS (v1 int, v4 int, v2 int); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree v1 | v4 | v2 ----+----+---- 1 | 3 | 2 @@ -552,18 +614,21 @@ -- error SELECT * FROM return_record_2('v4') AS (v1 int, v3 int, v2 int); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ERROR: key "v3" not found in mapping HINT: To return null in a column, add the value None to the mapping with the key named after the column. CONTEXT: while creating return value PL/Python function "return_record_2" -- works SELECT * FROM return_record_2('v3') AS (v1 int, v3 int, v2 int); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree v1 | v3 | v2 ----+----+---- 1 | 3 | 2 (1 row) SELECT * FROM return_record_2('v3') AS (v1 int, v2 int, v3 int); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree v1 | v2 | v3 ----+----+---- 1 | 2 | 3 @@ -574,6 +639,7 @@ return [[('first', 1), ('second', 1)], [('first', 2), ('second', 2)], [('first', 3), ('second', 3)]]; $$ LANGUAGE plpython3u; SELECT * FROM composite_type_as_list(); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree composite_type_as_list ------------------------------------------------------------------------------------ {{"(first,1)","(second,1)"},{"(first,2)","(second,2)"},{"(first,3)","(second,3)"}} @@ -587,6 +653,7 @@ return [['first', 1]]; $$ LANGUAGE plpython3u; SELECT * FROM composite_type_as_list_broken(); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ERROR: malformed record literal: "first" DETAIL: Missing left parenthesis. HINT: To return a composite type in an array, return the composite type as a Python tuple, e.g., "[('foo',)]". diff -U3 /tmp/cirrus-ci-build/src/pl/plpython/expected/plpython_subtransaction.out /tmp/cirrus-ci-build/build/testrun/plpython/regress/results/plpython_subtransaction.out --- /tmp/cirrus-ci-build/src/pl/plpython/expected/plpython_subtransaction.out 2024-03-27 22:35:14.170246000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/plpython/regress/results/plpython_subtransaction.out 2024-03-27 22:52:59.520134000 +0000 @@ -376,12 +376,14 @@ return False # not reached $$ LANGUAGE plpython3u; SELECT cursor_in_subxact(); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree cursor_in_subxact ------------------- 16 (1 row) SELECT cursor_aborted_subxact(); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ERROR: ValueError: iterating a cursor in an aborted subtransaction CONTEXT: Traceback (most recent call last): PL/Python function "cursor_aborted_subxact", line 8, in diff -U3 /tmp/cirrus-ci-build/src/pl/plpython/expected/plpython_transaction.out /tmp/cirrus-ci-build/build/testrun/plpython/regress/results/plpython_transaction.out --- /tmp/cirrus-ci-build/src/pl/plpython/expected/plpython_transaction.out 2024-03-27 22:35:14.170375000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/plpython/regress/results/plpython_transaction.out 2024-03-27 22:52:59.582212000 +0000 @@ -111,6 +111,7 @@ -- commit inside cursor loop CREATE TABLE test2 (x int); INSERT INTO test2 VALUES (0), (1), (2), (3), (4); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree TRUNCATE test1; DO LANGUAGE plpython3u $$ for row in plpy.cursor("SELECT * FROM test2 ORDER BY x"): @@ -129,6 +130,7 @@ -- check that this doesn't leak a holdable portal SELECT * FROM pg_cursors; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree name | statement | is_holdable | is_binary | is_scrollable | creation_time ------+-----------+-------------+-----------+---------------+--------------- (0 rows) @@ -153,6 +155,7 @@ (2 rows) SELECT * FROM pg_cursors; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree name | statement | is_holdable | is_binary | is_scrollable | creation_time ------+-----------+-------------+-----------+---------------+--------------- (0 rows) @@ -170,6 +173,7 @@ (0 rows) SELECT * FROM pg_cursors; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree name | statement | is_holdable | is_binary | is_scrollable | creation_time ------+-----------+-------------+-----------+---------------+--------------- (0 rows) @@ -193,6 +197,7 @@ (3 rows) SELECT * FROM pg_cursors; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree name | statement | is_holdable | is_binary | is_scrollable | creation_time ------+-----------+-------------+-----------+---------------+--------------- (0 rows)