Fixed #31248 -- Added missing space before USING SQL on PostGIS.

1 files changed, 19 insertions, 0 deletions

diff --git a/tests/gis_tests/geoapp/test_indexes.py b/tests/gis_tests/geoapp/test_indexes.py
new file mode 100644
index 0000000000..ce6b998794
--- /dev/null
+++ b/tests/gis_tests/geoapp/test_indexes.py
@@ -0,0 +1,19 @@
+from unittest import skipUnless
+
+from django.db import connection
+from django.db.models import Index
+from django.test import TestCase
+
+from ..utils import postgis
+from .models import City
+
+
+class SchemaIndexesTests(TestCase):
+    @skipUnless(postgis, 'This is a PostGIS-specific test.')
+    def test_using_sql(self):
+        index = Index(fields=['point'])
+        editor = connection.schema_editor()
+        self.assertIn(
+            '%s USING ' % editor.quote_name(City._meta.db_table),
+            str(index.create_sql(City, editor)),
+        )