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
29847	Window function test failures with MySQL 8	Tom Forbes	Tom Forbes	"With the mysql:8 Docker image I get the following failures on master:

{{{
FAIL: test_lag (expressions_window.tests.WindowFunctionTests)
----------------------------------------------------------------------
Traceback (most recent call last):
  File ""/usr/local/lib/python3.7/unittest/case.py"", line 59, in testPartExecutor
    yield
  File ""/usr/local/lib/python3.7/unittest/case.py"", line 615, in run
    testMethod()
  File ""/tests/django/tests/expressions_window/tests.py"", line 211, in test_lag
    ], transform=lambda row: (row.name, row.salary, row.department, row.lag))
  File ""/tests/django/django/test/testcases.py"", line 975, in assertQuerysetEqual
    return self.assertEqual(list(items), values, msg=msg)
  File ""/usr/local/lib/python3.7/unittest/case.py"", line 839, in assertEqual
    assertion_func(first, second, msg=msg)
  File ""/usr/local/lib/python3.7/unittest/case.py"", line 1045, in assertListEqual
    self.assertSequenceEqual(list1, list2, msg, seq_type=list)
  File ""/usr/local/lib/python3.7/unittest/case.py"", line 1027, in assertSequenceEqual
    self.fail(msg)
  File ""/usr/local/lib/python3.7/unittest/case.py"", line 680, in fail
    raise self.failureException(msg)
AssertionError: Lists differ: [('Jones', 45000, 'Accounting', 45000), ('Ad[400 chars]000)] != [('Williams', 37000, 'Accounting', None), ('[400 chars]000)]
}}}

{{{
======================================================================
FAIL: test_lead (expressions_window.tests.WindowFunctionTests)
----------------------------------------------------------------------
Traceback (most recent call last):
  File ""/usr/local/lib/python3.7/unittest/case.py"", line 59, in testPartExecutor
    yield
  File ""/usr/local/lib/python3.7/unittest/case.py"", line 615, in run
    testMethod()
  File ""/tests/django/tests/expressions_window/tests.py"", line 400, in test_lead
    ], transform=lambda row: (row.name, row.salary, row.department, row.hire_date, row.lead))
  File ""/tests/django/django/test/testcases.py"", line 975, in assertQuerysetEqual
    return self.assertEqual(list(items), values, msg=msg)
  File ""/usr/local/lib/python3.7/unittest/case.py"", line 839, in assertEqual
    assertion_func(first, second, msg=msg)
  File ""/usr/local/lib/python3.7/unittest/case.py"", line 1045, in assertListEqual
    self.assertSequenceEqual(list1, list2, msg, seq_type=list)
  File ""/usr/local/lib/python3.7/unittest/case.py"", line 1027, in assertSequenceEqual
    self.fail(msg)
  File ""/usr/local/lib/python3.7/unittest/case.py"", line 680, in fail
    raise self.failureException(msg)
AssertionError: Lists differ: [('Williams', 37000, 'Accounting', datetime.[726 chars]one)] != [('Jones', 45000, 'Accounting', datetime.dat[726 chars]one)]
First differing element 0:
}}}"	Bug	closed	Database layer (models, ORM)	2.1	Normal	fixed		Tom Forbes	Accepted	0	0	0	0	0	0