#29847: Window function test failures with MySQL 8
-------------------------------------+-------------------------------------
Reporter: Tom | Owner: nobody
Forbes |
Type: | Status: new
Uncategorized |
Component: Database | Version: 2.1
layer (models, ORM) |
Severity: Normal | Keywords:
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
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:
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/29847>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/046.d14c90b1097492d8b656ea5c75742222%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
