diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/json.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/json.out --- /tmp/cirrus-ci-build/src/test/regress/expected/json.out 2024-09-14 03:59:12.071267559 +0000 +++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/json.out 2024-09-14 04:04:01.233401247 +0000 @@ -2728,19 +2728,19 @@ select (test_json_dot.test_json).b, json_query(test_json, 'lax $.b' WITH CONDITIONAL WRAPPER NULL ON EMPTY NULL ON ERROR) as expected from test_json_dot; b | expected -------------+------------- - [42] | [42] + 42 | 42 {"c": 42} | {"c": 42} {"c": "42"} | {"c": "42"} {"c": "42"} | {"c": "42"} (4 rows) select (test_json_dot.test_json).b.c, json_query(test_json, 'lax $.b.c' WITH CONDITIONAL WRAPPER NULL ON EMPTY NULL ON ERROR) as expected from test_json_dot; - c | expected ---------+---------- - | - [42] | [42] - ["42"] | ["42"] - ["42"] | ["42"] + c | expected +------+---------- + | + 42 | 42 + "42" | "42" + "42" | "42" (4 rows) select (test_json_dot.test_json).d, json_query(test_json, 'lax $.d' WITH CONDITIONAL WRAPPER NULL ON EMPTY NULL ON ERROR) as expected from test_json_dot; @@ -2780,7 +2780,7 @@ -----------------+----------------- | | - [11] | [11] + 11 | 11 {"x": [11, 12]} | {"x": [11, 12]} (4 rows) @@ -2789,7 +2789,7 @@ -----------------+----------------- | | - [12] | [12] + 12 | 12 {"y": [21, 22]} | {"y": [21, 22]} (4 rows) diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/jsonb.out --- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2024-09-14 03:59:12.071267559 +0000 +++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/jsonb.out 2024-09-14 04:04:01.637400927 +0000 @@ -5726,17 +5726,17 @@ select (test_jsonb_dot.test_jsonb).b from test_jsonb_dot; b ------------- - [42] + 42 {"c": 42} {"c": "42"} (3 rows) select (test_jsonb_dot.test_jsonb).b.c from test_jsonb_dot; - c --------- + c +------ - [42] - ["42"] + 42 + "42" (3 rows) select (test_json_dot.test_json).d from test_json_dot; @@ -5763,11 +5763,11 @@ ^ -- array element access select (test_jsonb_dot.test_jsonb).d[0] from test_jsonb_dot; - d ------- + d +---- - [11] + 11 (3 rows) -- wildcard member access