Refs #32502 -- Avoided table rebuild when adding fields with no default on SQLite.

1 files changed, 9 insertions, 0 deletions

diff --git a/tests/schema/tests.py b/tests/schema/tests.py
index e94659544a..72a73745ed 100644
--- a/tests/schema/tests.py
+++ b/tests/schema/tests.py
@@ -517,6 +517,15 @@ class SchemaTests(TransactionTestCase):
             'column': editor.quote_name(new_field.name),
         }
         self.assertFalse(any(drop_default_sql in query['sql'] for query in ctx.captured_queries))
+        # Table is not rebuilt.
+        self.assertIs(any(
+            'CREATE TABLE' in query['sql']
+            for query in ctx.captured_queries
+        ), False)
+        self.assertIs(any(
+            'DROP TABLE' in query['sql']
+            for query in ctx.captured_queries
+        ), False)
         columns = self.column_classes(Author)
         self.assertEqual(columns['age'][0], connection.features.introspected_field_types['IntegerField'])
         self.assertTrue(columns['age'][1][6])