[Django] #29876: MySQL 8 fails to run GIS tests
Django
--------------------------------------+------------------------
Reporter: Tom Forbes | Owner: nobody
Type: Bug | Status: new
Component: GIS | Version: master
Severity: Normal | Keywords:
Triage Stage: Unreviewed | Has patch: 0
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
--------------------------------------+------------------------
When attempting to run the GIS test suite using the mysql:8 docker image I
get the following error:
{{{
Creating table relatedapp_author
Creating table relatedapp_article
Creating table relatedapp_book
Creating table relatedapp_event
Running deferred SQL…
Traceback (most recent call last):
File "/tests/django/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
File "/tests/django/django/db/backends/mysql/base.py", line 71, in
execute
return self.cursor.execute(query, args)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line
250, in execute
self.errorhandler(self, exc, value)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py",
line 50, in defaulterrorhandler
raise errorvalue
File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line
247, in execute
res = self._query(query)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line
412, in _query
rowcount = self._do_query(q)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line
375, in _do_query
db.query(q)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py",
line 276, in query
_mysql.connection.query(self, query)
_mysql_exceptions.OperationalError: (1070, 'Too many key parts specified;
max 1 parts allowed')
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/29876>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
Django
Reporter: Tom Forbes | Owner: nobody
Component: GIS | Version: master
Severity: Normal | Resolution: fixed
Keywords: | Triage Stage: Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
Changes (by Florian Apolloner):
* status: new => closed
* resolution: => fixed
Comment:
Fixed in
https://github.com/django/django/commit/4269648c0fe59a7edfa11f022f17cd251e9c49ca
--
Ticket URL: <https://code.djangoproject.com/ticket/29876#comment:1>
Django
Reporter: Tom Forbes | Owner: nobody
Component: GIS | Version: master
Severity: Normal | Resolution: fixed
Keywords: | Triage Stage: Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
Comment (by Florian Apolloner <florian@…>):
In [changeset:"4269648c0fe59a7edfa11f022f17cd251e9c49ca" 4269648c]:
{{{
#!CommitTicketReference repository=""
revision="4269648c0fe59a7edfa11f022f17cd251e9c49ca"
Fixed #29876 -- MySQL does not support SPATIAL fields in unique indices.
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/29876#comment:2>