diff options
| author | Robert Haas | 2022-09-28 13:45:27 +0000 |
|---|---|---|
| committer | Robert Haas | 2022-09-28 13:55:28 +0000 |
| commit | a448e49bcbe40fb72e1ed85af910dd216d45bad8 (patch) | |
| tree | 2815aed4f5e89bdea91cdd35ec89facaa846e438 /src/test | |
| parent | 6af082723277eeca74f2da65e7759666bf7c7f9c (diff) | |
Revert 56-bit relfilenode change and follow-up commits.
There are still some alignment-related failures in the buildfarm,
which might or might not be able to be fixed quickly, but I've also
just realized that it increased the size of many WAL records by 4 bytes
because a block reference contains a RelFileLocator. The effect of that
hasn't been studied or discussed, so revert for now.
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/alter_table.out | 24 | ||||
| -rw-r--r-- | src/test/regress/expected/fast_default.out | 4 | ||||
| -rw-r--r-- | src/test/regress/expected/oidjoins.out | 2 | ||||
| -rw-r--r-- | src/test/regress/sql/alter_table.sql | 8 | ||||
| -rw-r--r-- | src/test/regress/sql/fast_default.sql | 4 |
5 files changed, 23 insertions, 19 deletions
diff --git a/src/test/regress/expected/alter_table.out b/src/test/regress/expected/alter_table.out index 86666b83ae5..346f594ad02 100644 --- a/src/test/regress/expected/alter_table.out +++ b/src/test/regress/expected/alter_table.out @@ -2164,8 +2164,9 @@ select relname, c.oid = oldoid as orig_oid, case relfilenode when 0 then 'none' + when c.oid then 'own' when oldfilenode then 'orig' - else 'new' + else 'OTHER' end as storage, obj_description(c.oid, 'pg_class') as desc from pg_class c left join old_oids using (relname) @@ -2174,10 +2175,10 @@ select relname, relname | orig_oid | storage | desc ------------------------------+----------+---------+--------------- at_partitioned | t | none | - at_partitioned_0 | t | orig | - at_partitioned_0_id_name_key | t | orig | child 0 index - at_partitioned_1 | t | orig | - at_partitioned_1_id_name_key | t | orig | child 1 index + at_partitioned_0 | t | own | + at_partitioned_0_id_name_key | t | own | child 0 index + at_partitioned_1 | t | own | + at_partitioned_1_id_name_key | t | own | child 1 index at_partitioned_id_name_key | t | none | parent index (6 rows) @@ -2197,8 +2198,9 @@ select relname, c.oid = oldoid as orig_oid, case relfilenode when 0 then 'none' + when c.oid then 'own' when oldfilenode then 'orig' - else 'new' + else 'OTHER' end as storage, obj_description(c.oid, 'pg_class') as desc from pg_class c left join old_oids using (relname) @@ -2207,10 +2209,10 @@ select relname, relname | orig_oid | storage | desc ------------------------------+----------+---------+-------------- at_partitioned | t | none | - at_partitioned_0 | t | orig | - at_partitioned_0_id_name_key | f | new | parent index - at_partitioned_1 | t | orig | - at_partitioned_1_id_name_key | f | new | parent index + at_partitioned_0 | t | own | + at_partitioned_0_id_name_key | f | own | parent index + at_partitioned_1 | t | own | + at_partitioned_1_id_name_key | f | own | parent index at_partitioned_id_name_key | f | none | parent index (6 rows) @@ -2558,7 +2560,7 @@ CREATE FUNCTION check_ddl_rewrite(p_tablename regclass, p_ddl text) RETURNS boolean LANGUAGE plpgsql AS $$ DECLARE - v_relfilenode int8; + v_relfilenode oid; BEGIN v_relfilenode := relfilenode FROM pg_class WHERE oid = p_tablename; diff --git a/src/test/regress/expected/fast_default.out b/src/test/regress/expected/fast_default.out index 0a35f333f63..91f25717b5a 100644 --- a/src/test/regress/expected/fast_default.out +++ b/src/test/regress/expected/fast_default.out @@ -3,8 +3,8 @@ -- SET search_path = fast_default; CREATE SCHEMA fast_default; -CREATE TABLE m(id BIGINT); -INSERT INTO m VALUES (NULL::BIGINT); +CREATE TABLE m(id OID); +INSERT INTO m VALUES (NULL::OID); CREATE FUNCTION set(tabname name) RETURNS VOID AS $$ BEGIN diff --git a/src/test/regress/expected/oidjoins.out b/src/test/regress/expected/oidjoins.out index af57470f93e..215eb899be3 100644 --- a/src/test/regress/expected/oidjoins.out +++ b/src/test/regress/expected/oidjoins.out @@ -74,11 +74,11 @@ NOTICE: checking pg_type {typcollation} => pg_collation {oid} NOTICE: checking pg_attribute {attrelid} => pg_class {oid} NOTICE: checking pg_attribute {atttypid} => pg_type {oid} NOTICE: checking pg_attribute {attcollation} => pg_collation {oid} -NOTICE: checking pg_class {relam} => pg_am {oid} NOTICE: checking pg_class {relnamespace} => pg_namespace {oid} NOTICE: checking pg_class {reltype} => pg_type {oid} NOTICE: checking pg_class {reloftype} => pg_type {oid} NOTICE: checking pg_class {relowner} => pg_authid {oid} +NOTICE: checking pg_class {relam} => pg_am {oid} NOTICE: checking pg_class {reltablespace} => pg_tablespace {oid} NOTICE: checking pg_class {reltoastrelid} => pg_class {oid} NOTICE: checking pg_class {relrewrite} => pg_class {oid} diff --git a/src/test/regress/sql/alter_table.sql b/src/test/regress/sql/alter_table.sql index a67eb5f982a..9f773aeeb94 100644 --- a/src/test/regress/sql/alter_table.sql +++ b/src/test/regress/sql/alter_table.sql @@ -1478,8 +1478,9 @@ select relname, c.oid = oldoid as orig_oid, case relfilenode when 0 then 'none' + when c.oid then 'own' when oldfilenode then 'orig' - else 'new' + else 'OTHER' end as storage, obj_description(c.oid, 'pg_class') as desc from pg_class c left join old_oids using (relname) @@ -1498,8 +1499,9 @@ select relname, c.oid = oldoid as orig_oid, case relfilenode when 0 then 'none' + when c.oid then 'own' when oldfilenode then 'orig' - else 'new' + else 'OTHER' end as storage, obj_description(c.oid, 'pg_class') as desc from pg_class c left join old_oids using (relname) @@ -1639,7 +1641,7 @@ CREATE FUNCTION check_ddl_rewrite(p_tablename regclass, p_ddl text) RETURNS boolean LANGUAGE plpgsql AS $$ DECLARE - v_relfilenode int8; + v_relfilenode oid; BEGIN v_relfilenode := relfilenode FROM pg_class WHERE oid = p_tablename; diff --git a/src/test/regress/sql/fast_default.sql b/src/test/regress/sql/fast_default.sql index 819ec40fdaf..16a3b7ca51d 100644 --- a/src/test/regress/sql/fast_default.sql +++ b/src/test/regress/sql/fast_default.sql @@ -4,8 +4,8 @@ SET search_path = fast_default; CREATE SCHEMA fast_default; -CREATE TABLE m(id BIGINT); -INSERT INTO m VALUES (NULL::BIGINT); +CREATE TABLE m(id OID); +INSERT INTO m VALUES (NULL::OID); CREATE FUNCTION set(tabname name) RETURNS VOID AS $$ |
