====================================================================== ERROR: test_lead_default (expressions_window.tests.WindowFunctionTests) ---------------------------------------------------------------------- Traceback (most recent call last): File "/media/sf_django/django/db/backends/utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "/media/sf_django/django/db/backends/mysql/base.py", line 71, in execute return self.cursor.execute(query, args) File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/cursors.py", line 250, in execute self.errorhandler(self, exc, value) File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler raise errorvalue File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/cursors.py", line 247, in execute res = self._query(query) File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/cursors.py", line 412, in _query rowcount = self._do_query(q) File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/cursors.py", line 375, in _do_query db.query(q) File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/connections.py", line 276, in query _mysql.connection.query(self, query) _mysql_exceptions.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' 60000) OVER (PARTITION BY `expressions_window_employee`.`department` ORDER BY `' at line 1") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/media/sf_django/tests/expressions_window/tests.py", line 424, in test_lead_default self.assertEqual(list(qs.values_list('lead_default', flat=True).distinct()), [60000]) File "/media/sf_django/django/db/models/query.py", line 268, in __iter__ self._fetch_all() File "/media/sf_django/django/db/models/query.py", line 1183, in _fetch_all self._result_cache = list(self._iterable_class(self)) File "/media/sf_django/django/db/models/query.py", line 176, in __iter__ for row in compiler.results_iter(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size): File "/media/sf_django/django/db/models/sql/compiler.py", line 1013, in results_iter results = self.execute_sql(MULTI, chunked_fetch=chunked_fetch, chunk_size=chunk_size) File "/media/sf_django/django/db/models/sql/compiler.py", line 1061, in execute_sql cursor.execute(sql, params) File "/media/sf_django/django/db/backends/utils.py", line 68, in execute return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) File "/media/sf_django/django/db/backends/utils.py", line 77, in _execute_with_wrappers return executor(sql, params, many, context) File "/media/sf_django/django/db/backends/utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "/media/sf_django/django/db/utils.py", line 89, in __exit__ raise dj_exc_value.with_traceback(traceback) from exc_value File "/media/sf_django/django/db/backends/utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "/media/sf_django/django/db/backends/mysql/base.py", line 71, in execute return self.cursor.execute(query, args) File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/cursors.py", line 250, in execute self.errorhandler(self, exc, value) File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler raise errorvalue File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/cursors.py", line 247, in execute res = self._query(query) File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/cursors.py", line 412, in _query rowcount = self._do_query(q) File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/cursors.py", line 375, in _do_query db.query(q) File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/connections.py", line 276, in query _mysql.connection.query(self, query) django.db.utils.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' 60000) OVER (PARTITION BY `expressions_window_employee`.`department` ORDER BY `' at line 1") ====================================================================== ERROR: test_range_unbound (expressions_window.tests.WindowFunctionTests) A query with RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING. ---------------------------------------------------------------------- Traceback (most recent call last): File "/media/sf_django/django/db/backends/utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "/media/sf_django/django/db/backends/mysql/base.py", line 71, in execute return self.cursor.execute(query, args) File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/cursors.py", line 250, in execute self.errorhandler(self, exc, value) File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler raise errorvalue File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/cursors.py", line 247, in execute res = self._query(query) File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/cursors.py", line 412, in _query rowcount = self._do_query(q) File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/cursors.py", line 375, in _do_query db.query(q) File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/connections.py", line 276, in query _mysql.connection.query(self, query) _mysql_exceptions.OperationalError: (4019, 'RANGE-type frame requires ORDER BY clause with single sort key') The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/media/sf_django/tests/expressions_window/tests.py", line 583, in test_range_unbound ], transform=lambda row: (row.name, row.department, row.salary, row.hire_date, row.sum)) File "/media/sf_django/django/test/testcases.py", line 967, in assertQuerysetEqual items = map(transform, qs) File "/media/sf_django/django/db/models/query.py", line 268, in __iter__ self._fetch_all() File "/media/sf_django/django/db/models/query.py", line 1183, in _fetch_all self._result_cache = list(self._iterable_class(self)) File "/media/sf_django/django/db/models/query.py", line 54, in __iter__ results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size) File "/media/sf_django/django/db/models/sql/compiler.py", line 1061, in execute_sql cursor.execute(sql, params) File "/media/sf_django/django/db/backends/utils.py", line 68, in execute return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) File "/media/sf_django/django/db/backends/utils.py", line 77, in _execute_with_wrappers return executor(sql, params, many, context) File "/media/sf_django/django/db/backends/utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "/media/sf_django/django/db/utils.py", line 89, in __exit__ raise dj_exc_value.with_traceback(traceback) from exc_value File "/media/sf_django/django/db/backends/utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "/media/sf_django/django/db/backends/mysql/base.py", line 71, in execute return self.cursor.execute(query, args) File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/cursors.py", line 250, in execute self.errorhandler(self, exc, value) File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler raise errorvalue File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/cursors.py", line 247, in execute res = self._query(query) File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/cursors.py", line 412, in _query rowcount = self._do_query(q) File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/cursors.py", line 375, in _do_query db.query(q) File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/connections.py", line 276, in query _mysql.connection.query(self, query) django.db.utils.OperationalError: (4019, 'RANGE-type frame requires ORDER BY clause with single sort key') ====================================================================== FAIL: test_function_list_of_values (expressions_window.tests.WindowFunctionTests) ---------------------------------------------------------------------- Traceback (most recent call last): File "/media/sf_django/tests/expressions_window/tests.py", line 266, in test_function_list_of_values ('Brown', 53000, 'Sales', datetime.date(2009, 9, 1), None), AssertionError: Sequences differ: != [('Jones', 45000, 'Accounting', datetime.[729 chars]one)] First differing element 1: ('Williams', 37000, 'Accounting', datetime.date(2009, 6, 1), 50000) ('Jenson', 45000, 'Accounting', datetime.date(2008, 4, 1), 37000) Diff is 1600 characters long. Set self.maxDiff to None to see it. ====================================================================== FAIL: test_lag (expressions_window.tests.WindowFunctionTests) ---------------------------------------------------------------------- Traceback (most recent call last): File "/media/sf_django/tests/expressions_window/tests.py", line 203, in test_lag ], transform=lambda row: (row.name, row.salary, row.department, row.lag)) File "/media/sf_django/django/test/testcases.py", line 976, in assertQuerysetEqual return self.assertEqual(list(items), values, msg=msg) AssertionError: Lists differ: [('Jones', 45000, 'Accounting', 45000), ('Wi[400 chars]one)] != [('Williams', 37000, 'Accounting', None), ('[400 chars]000)] First differing element 0: ('Jones', 45000, 'Accounting', 45000) ('Williams', 37000, 'Accounting', None) Diff is 846 characters long. Set self.maxDiff to None to see it. ====================================================================== FAIL: test_lead (expressions_window.tests.WindowFunctionTests) ---------------------------------------------------------------------- Traceback (most recent call last): File "/media/sf_django/tests/expressions_window/tests.py", line 389, in test_lead ], transform=lambda row: (row.name, row.salary, row.department, row.hire_date, row.lead)) File "/media/sf_django/django/test/testcases.py", line 976, in assertQuerysetEqual return self.assertEqual(list(items), values, msg=msg) AssertionError: Lists differ: [('Jo[60 chars]), ('Williams', 37000, 'Accounting', datetime.[659 chars]one)] != [('Jo[60 chars]), ('Jenson', 45000, 'Accounting', datetime.da[659 chars]one)] First differing element 1: ('Williams', 37000, 'Accounting', datetime.date(2009, 6, 1), 50000) ('Jenson', 45000, 'Accounting', datetime.date(2008, 4, 1), 37000) Diff is 950 characters long. Set self.maxDiff to None to see it. ----------------------------------------------------------------------