postgres
diff --git a/‎src/test/regress/expected/reloptions.out
Copy file name to clipboardExpand all lines: src/test/regress/expected/reloptions.out
+11Lines changed: 11 additions & 0 deletions b/‎src/test/regress/expected/reloptions.out
Copy file name to clipboardExpand all lines: src/test/regress/expected/reloptions.out
+11Lines changed: 11 additions & 0 deletions
diff --git a/‎src/test/regress/sql/reloptions.sql
Copy file name to clipboardExpand all lines: src/test/regress/sql/reloptions.sql
+7Lines changed: 7 additions & 0 deletions b/‎src/test/regress/sql/reloptions.sql
Copy file name to clipboardExpand all lines: src/test/regress/sql/reloptions.sql
+7Lines changed: 7 additions & 0 deletions
@@ -87,6 +87,17 @@ SELECT reloptions FROM pg_class WHERE oid = 'reloptions_test'::regclass AND
 -- RESET fails if a value is specified
 ALTER TABLE reloptions_test RESET (fillfactor=12);
 ERROR:  RESET must not include values for parameters
+-- We can RESET an invalid option which for some reason is already set
+UPDATE pg_class
+	SET reloptions = '{fillfactor=13,autovacuum_enabled=false,illegal_option=4}'
+	WHERE oid = 'reloptions_test'::regclass;
+ALTER TABLE reloptions_test RESET (illegal_option);
+SELECT reloptions FROM pg_class WHERE oid = 'reloptions_test'::regclass;
+                reloptions                
+------------------------------------------
+ {fillfactor=13,autovacuum_enabled=false}
+(1 row)
+
 -- Test vacuum_truncate option
 DROP TABLE reloptions_test;
 CREATE TEMP TABLE reloptions_test(i INT NOT NULL, j text)
 
@@ -52,6 +52,13 @@ SELECT reloptions FROM pg_class WHERE oid = 'reloptions_test'::regclass AND
 -- RESET fails if a value is specified
 ALTER TABLE reloptions_test RESET (fillfactor=12);
 
+-- We can RESET an invalid option which for some reason is already set
+UPDATE pg_class
+	SET reloptions = '{fillfactor=13,autovacuum_enabled=false,illegal_option=4}'
+	WHERE oid = 'reloptions_test'::regclass;
+ALTER TABLE reloptions_test RESET (illegal_option);
+SELECT reloptions FROM pg_class WHERE oid = 'reloptions_test'::regclass;
+
 -- Test vacuum_truncate option
 DROP TABLE reloptions_test;