Modify partition tests

Reflect the fact that USING orioledb clause for partitioned (parent) table is prohibited in PG16 but allowed since PG17
cloudnepal · Nov 14, 2024 · af47ac2 · af47ac2
1 parent 78ddd88
commit af47ac2
Show file tree

Hide file tree

Showing 3 changed files with 755 additions and 6 deletions.
diff --git a/expected/partition.out b/expected/partition.out
@@ -596,11 +596,15 @@ SELECT tableoid::regclass, * FROM o_test_partition_multiple_moves;
  o_test_partition_multiple_moves_child2 |     2 |     1 |    60
 (1 row)
 
-SET default_table_access_method to orioledb;
+-- Should succeed in PG17 but fail in PG16
 CREATE TABLE o_test_partition_pkey_update_move (
   val_1 INT PRIMARY KEY
+) PARTITION BY LIST (val_1) USING orioledb;
+ERROR:  specifying a table access method is not supported on a partitioned table
+-- Create it using default AM for PG16
+CREATE TABLE IF NOT EXISTS o_test_partition_pkey_update_move (
+  val_1 INT PRIMARY KEY
 ) PARTITION BY LIST (val_1);
-RESET default_table_access_method;
 CREATE TABLE o_test_partition_pkey_update_move_child1
 	PARTITION OF o_test_partition_pkey_update_move FOR VALUES IN (1);
 CREATE TABLE o_test_partition_pkey_update_move_child2 (