diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/stats_export_import.out /tmp/cirrus-ci-build/build-32/testrun/pg_upgrade/002_pg_upgrade/data/results/stats_export_import.out --- /tmp/cirrus-ci-build/src/test/regress/expected/stats_export_import.out 2024-02-27 22:27:33.158774535 +0000 +++ /tmp/cirrus-ci-build/build-32/testrun/pg_upgrade/002_pg_upgrade/data/results/stats_export_import.out 2024-02-27 22:34:20.346473017 +0000 @@ -649,21 +649,13 @@ :'table_stats_json'::jsonb, true, false); - pg_import_rel_stats ---------------------- - t -(1 row) - +ERROR: Attribute duplicate count 1509583364 on attnum 1 attname id stainherit f SELECT pg_import_rel_stats( 'stats_export_import.is_odd'::regclass, :'index_stats_json'::jsonb, true, false); - pg_import_rel_stats ---------------------- - t -(1 row) - +ERROR: Attribute duplicate count 1510058952 on attnum 1 attname expr stainherit f SELECT pg_import_ext_stats( e.oid, :'ext_stats_json'::jsonb, @@ -672,11 +664,7 @@ FROM pg_statistic_ext AS e WHERE e.stxrelid = 'stats_export_import.test'::regclass AND e.stxname = 'evens_test'; - pg_import_ext_stats ---------------------- - t -(1 row) - +ERROR: invalid memory alloc request size 2653757132 -- This should return 0 rows SELECT staattnum, stainherit, stanullfrac, stawidth, stadistinct, stakind1, stakind2, stakind3, stakind4, stakind5, @@ -694,9 +682,14 @@ FROM pg_statistic WHERE starelid IN ('stats_export_import.test'::regclass, 'stats_export_import.is_odd'::regclass); - staattnum | stainherit | stanullfrac | stawidth | stadistinct | stakind1 | stakind2 | stakind3 | stakind4 | stakind5 | staop1 | staop2 | staop3 | staop4 | staop5 | stacoll1 | stacoll2 | stacoll3 | stacoll4 | stacoll5 | stanumbers1 | stanumbers2 | stanumbers3 | stanumbers4 | stanumbers5 | sv1 | sv2 | sv3 | sv4 | sv5 ------------+------------+-------------+----------+-------------+----------+----------+----------+----------+----------+--------+--------+--------+--------+--------+----------+----------+----------+----------+----------+-------------+-------------+-------------+-------------+-------------+-----+-----+-----+-----+----- -(0 rows) + staattnum | stainherit | stanullfrac | stawidth | stadistinct | stakind1 | stakind2 | stakind3 | stakind4 | stakind5 | staop1 | staop2 | staop3 | staop4 | staop5 | stacoll1 | stacoll2 | stacoll3 | stacoll4 | stacoll5 | stanumbers1 | stanumbers2 | stanumbers3 | stanumbers4 | stanumbers5 | sv1 | sv2 | sv3 | sv4 | sv5 +-----------+------------+-------------+----------+-------------+----------+----------+----------+----------+----------+--------+--------+--------+--------+--------+----------+----------+----------+----------+----------+-------------+-------------+--------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+-------------------------------------------------------------------------------------------------------------------------------------------+-----+--------------------------------------------------+-----+----- + 1 | f | 0 | 4 | -1 | 2 | 3 | 0 | 0 | 0 | 97 | 97 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | {1} | | | | {1,2,3,4} | | | | + 3 | f | 0.25 | 57 | -0.75 | 2 | 3 | 0 | 0 | 0 | 2990 | 2990 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | {1} | | | | {"(1,1.1,ONE,01-01-2001,\"{\"\"xkey\"\": \"\"xval\"\"}\")","(2,2.2,TWO,02-02-2002,\"[true, 4, \"\"six\"\"]\")","(3,3.3,TRE,03-03-2003,)"} | | | | + 4 | f | 0.25 | 45 | -0.75 | 2 | 3 | 4 | 5 | 0 | 1072 | 1072 | 98 | 98 | 0 | 100 | 100 | 100 | 100 | 0 | | {-1} | {0.33333334,0.33333334,0.33333334,0.33333334,0.33333334,0.33333334,0.33333334,0.33333334,0.33333334,0} | {2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,3,2.3333333} | | {"{\"\\\"orange\\\"\",purple,cyan}","{blue,yellow}","{red,green}"} | | {"\"orange\"",blue,cyan,green,purple,red,yellow} | | + 2 | f | 0 | 4 | -1 | 2 | 3 | 0 | 0 | 0 | 664 | 664 | 0 | 0 | 0 | 100 | 100 | 0 | 0 | 0 | | {-0.4} | | | | {four,one,tre,two} | | | | + 1 | f | 0.25 | 1 | -0.5 | 1 | 3 | 0 | 0 | 0 | 91 | 58 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | {0.5} | {0.5} | | | | {t} | | | | +(5 rows) -- This should return 0 rows SELECT staattnum, stainherit, stanullfrac, stawidth, stadistinct, @@ -726,8 +719,8 @@ ORDER BY relname; relname | reltuples ---------+----------- - is_odd | 4 - test | 4 + is_odd | 0 + test | -1 (2 rows) -- This should return 0 rows @@ -760,9 +753,10 @@ JOIN pg_statistic_ext_data AS d ON d.stxoid = e.oid WHERE e.stxrelid = 'stats_export_import.test'::regclass AND e.stxname = 'evens_test'; - stxdinherit | stxdndistinct | stxddependencies | stxdmcv | stxdexpr --------------+---------------+------------------+---------+---------- -(0 rows) + stxdinherit | stxdndistinct | stxddependencies | stxdmcv | stxdexpr +-------------+---------------+--------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------- + f | {"2, -1": 4} | {"2 => -1": 1.000000, "-1 => 2": 0.500000} | \xc251a6e1010000000400000002001900000010000000040000001d00000020000000ffffffff00000000020000000200000000000000010000000100000004000000666f7572030000006f6e65030000007472650300000074776f00010001000000000000d03f000000000000b03f000000000000000000000000d03f000000000000c03f010000000000000000000000d03f000000000000c03f020000000000000000000000d03f000000000000b03f03000100 | {"(0,0,f,0.25,1,-0.5,1,3,0,0,0,91,58,0,0,0,0,0,0,0,0,{0.5},{0.5},,,,{f},,,,)"} +(1 row) SELECT staattnum, stainherit, stanullfrac, stawidth, stadistinct, stakind1, stakind2, stakind3, stakind4, stakind5,