PS_NITPICKS_20241022_GENCOLS_V400003.txt

text/plain

Filename: PS_NITPICKS_20241022_GENCOLS_V400003.txt
Type: text/plain
Part: 0
Message: Re: Pgoutput not capturing the generated columns
diff --git a/src/test/subscription/t/011_generated.pl b/src/test/subscription/t/011_generated.pl
index ff44c87..24134fa 100644
--- a/src/test/subscription/t/011_generated.pl
+++ b/src/test/subscription/t/011_generated.pl
@@ -239,7 +239,6 @@ $node_subscriber->safe_psql('postgres',
 	"ALTER TABLE tab_alter ALTER COLUMN b DROP EXPRESSION");
 
 # Insert data to verify replication.
-
 $node_publisher->safe_psql('postgres',
 	"INSERT INTO tab_alter VALUES (1,1), (2,2), (3,3)");
 
@@ -297,7 +296,6 @@ $node_subscriber->safe_psql(
 
 # Wait for initial sync.
 $node_subscriber->wait_for_subscription_sync;
-
 $node_publisher->wait_for_catchup('sub1');
 
 # Initial sync test when publish_generated_columns=false.
@@ -306,7 +304,6 @@ $result = $node_subscriber->safe_psql('postgres',
 is( $result, qq(1|
 1|),
 	'tab_gen_to_gen initial sync, when publish_generated_columns=false');
-
 $result = $node_subscriber->safe_psql('postgres',
 	"SELECT * FROM tab_gen_to_gen2 ORDER BY a");
 is( $result, qq(|2
@@ -331,7 +328,6 @@ is( $result, qq(1|
 3|),
 	'tab_gen_to_gen incremental replication, when publish_generated_columns=false'
 );
-
 $result = $node_subscriber->safe_psql('postgres',
 	"SELECT * FROM tab_gen_to_gen2 ORDER BY a");
 is( $result, qq(|2
@@ -376,7 +372,6 @@ $node_subscriber->safe_psql(
 
 # Wait for initial sync.
 $node_subscriber->wait_for_subscription_sync;
-
 $node_publisher->wait_for_catchup('sub1');
 
 # Initial sync test when publish_generated_columns=true.
@@ -385,7 +380,6 @@ $result = $node_subscriber->safe_psql('postgres',
 is( $result, qq(1|2
 1|2),
 	'tab_gen_to_gen3 initial sync, when publish_generated_columns=true');
-
 $result = $node_subscriber->safe_psql('postgres',
 	"SELECT * FROM tab_gen_to_gen4 ORDER BY a");
 is( $result, qq(|2
@@ -411,7 +405,6 @@ is( $result, qq(1|2
 3|6),
 	'tab_gen_to_gen3 incremental replication, when publish_generated_columns=true'
 );
-
 $result = $node_subscriber->safe_psql('postgres',
 	"SELECT * FROM tab_gen_to_gen4 ORDER BY a");
 is( $result, qq(|2