[YSQL] YSQL Major Version Upgrade fails for unique constraints on partitioned tables

[fizaaluthra]

Jira Link: DB-14191

Description

diff --git a/src/yb/integration-tests/upgrade-tests/pg15_upgrade-test.cc b/src/yb/integration-tests/upgrade-tests/pg15_upgrade-test.cc
index db47f04602..e690e099c2 100644
--- a/src/yb/integration-tests/upgrade-tests/pg15_upgrade-test.cc
+++ b/src/yb/integration-tests/upgrade-tests/pg15_upgrade-test.cc
@@ -1299,4 +1299,25 @@ TEST_F(Pg15UpgradeSequenceTest, IdentityColumn) {
     ASSERT_NO_FATALS(Add3Rows(conn, kSequencePg11, seq_val_pg11_));
   }
 }
+
+TEST_F(Pg15UpgradeTest, UniqueConstraintsPartitionedTables) {
+  ASSERT_OK(ExecuteStatements(
+  {
+    "CREATE TABLE employees_hash ("
+    "    id INT,"
+    "    age INT,"
+    "    val BIGINT,"
+    "    text_column1 TEXT,"
+    "    uuid_col UUID,"
+    "    PRIMARY KEY (id, age)"
+    ") PARTITION BY RANGE (age);",
+    "CREATE TABLE employees_hash_young PARTITION OF employees_hash"
+    "    FOR VALUES FROM (0) TO (30);",
+    "CREATE TABLE employees_hash_old PARTITION OF employees_hash"
+    "    FOR VALUES FROM (30) TO (100);",
+    "ALTER TABLE employees_hash ADD CONSTRAINT employees_hash_unique_id UNIQUE (id, age);"
+  }));
+  ASSERT_OK(UpgradeClusterToMixedMode());
+  ASSERT_OK(FinalizeUpgradeFromMixedMode());
+}
 }  // namespace yb

Run the test

./yb_build.sh release --cxx-test pg15_upgrade-test --gtest_filter Pg15UpgradeTest.UniqueConstraintsPartitionedTables

Issue Type

kind/bug

Warning: Please confirm that this issue does not contain any sensitive information

• I confirm this issue does not contain any sensitive information.

[fizaaluthra]

Related to #24260 (general issue with ysql dump)