﻿id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
29876	MySQL 8 fails to run GIS tests	Tom Forbes	nobody	"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')
}}}
"	Bug	closed	GIS	dev	Normal	fixed			Unreviewed	0	0	0	0	0	0
