[1.7.x] Fixed #23416 -- Make sure DatabaseCreation respects checks.

Migrations respected Field.db_parameters()['check'], but
DatabaseCreation was still using just Field.db_type().

Backport of 14c8456 from master

2 files changed, 14 insertions, 0 deletions

diff --git a/tests/commands_sql/models.py b/tests/commands_sql/models.py
index 78ad722307..fe5768b3dd 100644
--- a/tests/commands_sql/models.py
+++ b/tests/commands_sql/models.py
@@ -8,3 +8,4 @@ class Comment(models.Model):
 class Book(models.Model):
     title = models.CharField(max_length=100, db_index=True)
     comments = models.ManyToManyField(Comment)
+    counter = models.PositiveIntegerField()
diff --git a/tests/commands_sql/tests.py b/tests/commands_sql/tests.py
index 3d9e234ff0..ef21acaca0 100644
--- a/tests/commands_sql/tests.py
+++ b/tests/commands_sql/tests.py
@@ -1,6 +1,7 @@
 from __future__ import unicode_literals
 
 import re
+import unittest
 
 from django.apps import apps
 from django.core.management.color import no_style
@@ -43,6 +44,18 @@ class SQLCommandsTestCase(TestCase):
             'commands_sql_comment', 'commands_sql_book', 'commands_sql_book_comments'
         })
 
+    @unittest.skipUnless('PositiveIntegerField' in connections[DEFAULT_DB_ALIAS].creation.data_type_check_constraints, 'Backend does not have checks.')
+    def test_sql_create_check(self):
+        """Regression test for #23416 -- Check that db_params['check'] is respected."""
+        app_config = apps.get_app_config('commands_sql')
+        output = sql_create(app_config, no_style(), connections[DEFAULT_DB_ALIAS])
+        success = False
+        for statement in output:
+            if 'CHECK' in statement:
+                success = True
+        if not success:
+            self.fail("'CHECK' not found in ouput %s" % output)
+
     def test_sql_delete(self):
         app_config = apps.get_app_config('commands_sql')
         output = sql_delete(app_config, no_style(), connections[DEFAULT_DB_ALIAS], close_connection=False)