Refs #30591 -- Fixed introspection of check and unique column constraints on MariaDB.

Unnamed unique and check columns constraints have the same name as
a column. Ensure uniqueness by using custom names.

Thanks Adnan Umer for the report.

2 files changed, 7 insertions, 0 deletions

diff --git a/tests/introspection/models.py b/tests/introspection/models.py
index 6f43359dd4..c3f6338176 100644
--- a/tests/introspection/models.py
+++ b/tests/introspection/models.py
@@ -83,6 +83,7 @@ class Comment(models.Model):
 
 class CheckConstraintModel(models.Model):
     up_votes = models.PositiveIntegerField()
+    voting_number = models.PositiveIntegerField(unique=True)
 
     class Meta:
         required_db_features = {
diff --git a/tests/introspection/tests.py b/tests/introspection/tests.py
index 91b6ec732e..5e6fd3d741 100644
--- a/tests/introspection/tests.py
+++ b/tests/introspection/tests.py
@@ -268,9 +268,15 @@ class IntrospectionTests(TransactionTestCase):
             elif details['columns'] == ['up_votes'] and details['check']:
                 assertDetails(details, ['up_votes'], check=True)
                 field_constraints.add(name)
+            elif details['columns'] == ['voting_number'] and details['check']:
+                assertDetails(details, ['voting_number'], check=True)
+                field_constraints.add(name)
             elif details['columns'] == ['ref'] and details['unique']:
                 assertDetails(details, ['ref'], unique=True)
                 field_constraints.add(name)
+            elif details['columns'] == ['voting_number'] and details['unique']:
+                assertDetails(details, ['voting_number'], unique=True)
+                field_constraints.add(name)
             elif details['columns'] == ['article_id'] and details['index']:
                 assertDetails(details, ['article_id'], index=True)
                 field_constraints.add(name)