[1.7.x] Fixed #23702 -- Fixed adding an explicit id field on SQLite.

Thanks gavinwahl for the report.

Backport of 92269b7b53 from master

1 files changed, 19 insertions, 0 deletions

diff --git a/tests/schema/tests.py b/tests/schema/tests.py
index 5b6a23bee0..3dc986e3a4 100644
--- a/tests/schema/tests.py
+++ b/tests/schema/tests.py
@@ -497,6 +497,25 @@ class SchemaTests(TransactionTestCase):
         else:
             self.fail("No FK constraint for author_id found")
 
+    def test_alter_implicit_id_to_explict(self):
+        """
+        Should be able to convert an implicit "id" field to an explicit "id"
+        primary key field.
+        """
+        with connection.schema_editor() as editor:
+            editor.create_model(Author)
+
+        new_field = IntegerField(primary_key=True)
+        new_field.set_attributes_from_name("id")
+        new_field.model = Author
+        with connection.schema_editor() as editor:
+            editor.alter_field(
+                Author,
+                Author._meta.get_field_by_name("id")[0],
+                new_field,
+                strict=True,
+            )
+
     def test_rename(self):
         """
         Tests simple altering of fields