Fixed #23581 -- Prevented extraneous DROP DEFAULT statements.

Thanks john_scott for the report and Markus Holtermann for review.

1 files changed, 4 insertions, 0 deletions

diff --git a/tests/schema/tests.py b/tests/schema/tests.py
index 53e67b5647..e9de2131a9 100644
--- a/tests/schema/tests.py
+++ b/tests/schema/tests.py
@@ -547,6 +547,10 @@ class SchemaTests(TransactionTestCase):
                 strict=True,
             )
 
+        # This will fail if DROP DEFAULT is inadvertently executed on this
+        # field which drops the id sequence, at least on PostgreSQL.
+        Author.objects.create(name='Foo')
+
     def test_rename(self):
         """
         Tests simple altering of fields