Commitf27449f

committed

Add regression test for wide REPLICA IDENTITY FULL updates.

This just contains the regression tests added by a fix for a 9.4specific bug regarding $subject.Author: Andres FreundBackpatch: 9.5-

1 parentb798ea8 commitf27449fCopy full SHA for f27449f

File tree

-2

lines changed

-2

lines changed

Lines changed: 7 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -305,7 +305,13 @@ ALTER TABLE toasted_several REPLICA IDENTITY FULL;`
`305`	`305`	`ALTER TABLE toasted_several ALTER COLUMN toasted_key SET STORAGE EXTERNAL;`
`306`	`306`	`ALTER TABLE toasted_several ALTER COLUMN toasted_col1 SET STORAGE EXTERNAL;`
`307`	`307`	`ALTER TABLE toasted_several ALTER COLUMN toasted_col2 SET STORAGE EXTERNAL;`
`308`		`-INSERT INTO toasted_several(toasted_key) VALUES(repeat('9876543210', 2000));`
	`308`	`+INSERT INTO toasted_several(toasted_key) VALUES(repeat('9876543210', 10000));`
	`309`	`+SELECT pg_column_size(toasted_key) > 2^16 FROM toasted_several;`
	`310`	`+ ?column?`
	`311`	`+----------`
	`312`	`+ t`
	`313`	`+(1 row)`
	`314`	`+`
`309`	`315`	`SELECT regexp_replace(data, '^(.{100}).*(.{100})$', '\1..\2') FROM pg_logical_slot_peek_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1');`
`310`	`316`	`regexp_replace`
`311`	`317`	`------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------`

Lines changed: 2 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -279,7 +279,8 @@ ALTER TABLE toasted_several ALTER COLUMN toasted_key SET STORAGE EXTERNAL;`
`279`	`279`	`ALTERTABLE toasted_several ALTER COLUMN toasted_col1SET STORAGE EXTERNAL;`
`280`	`280`	`ALTERTABLE toasted_several ALTER COLUMN toasted_col2SET STORAGE EXTERNAL;`
`281`	`281`
`282`		`-INSERT INTO toasted_several(toasted_key)VALUES(repeat('9876543210',2000));`
	`282`	`+INSERT INTO toasted_several(toasted_key)VALUES(repeat('9876543210',10000));`
	`283`	`+SELECT pg_column_size(toasted_key)>2^16FROM toasted_several;`
`283`	`284`
`284`	`285`	`SELECT regexp_replace(data,'^(.{100}).*(.{100})$','\1..\2')FROM pg_logical_slot_peek_changes('regression_slot',NULL,NULL,'include-xids','0','skip-empty-xacts','1');`
`285`	`286`

Comments

(0)