| 1 | ======================================================================
|
|---|
| 2 | ERROR: test_lead_default (expressions_window.tests.WindowFunctionTests)
|
|---|
| 3 | ----------------------------------------------------------------------
|
|---|
| 4 | Traceback (most recent call last):
|
|---|
| 5 | File "/media/sf_django/django/db/backends/utils.py", line 85, in _execute
|
|---|
| 6 | return self.cursor.execute(sql, params)
|
|---|
| 7 | File "/media/sf_django/django/db/backends/mysql/base.py", line 71, in execute
|
|---|
| 8 | return self.cursor.execute(query, args)
|
|---|
| 9 | File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/cursors.py", line 250, in execute
|
|---|
| 10 | self.errorhandler(self, exc, value)
|
|---|
| 11 | File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler
|
|---|
| 12 | raise errorvalue
|
|---|
| 13 | File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/cursors.py", line 247, in execute
|
|---|
| 14 | res = self._query(query)
|
|---|
| 15 | File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/cursors.py", line 412, in _query
|
|---|
| 16 | rowcount = self._do_query(q)
|
|---|
| 17 | File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/cursors.py", line 375, in _do_query
|
|---|
| 18 | db.query(q)
|
|---|
| 19 | File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/connections.py", line 276, in query
|
|---|
| 20 | _mysql.connection.query(self, query)
|
|---|
| 21 | _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")
|
|---|
| 22 |
|
|---|
| 23 | The above exception was the direct cause of the following exception:
|
|---|
| 24 |
|
|---|
| 25 | Traceback (most recent call last):
|
|---|
| 26 | File "/media/sf_django/tests/expressions_window/tests.py", line 424, in test_lead_default
|
|---|
| 27 | self.assertEqual(list(qs.values_list('lead_default', flat=True).distinct()), [60000])
|
|---|
| 28 | File "/media/sf_django/django/db/models/query.py", line 268, in __iter__
|
|---|
| 29 | self._fetch_all()
|
|---|
| 30 | File "/media/sf_django/django/db/models/query.py", line 1183, in _fetch_all
|
|---|
| 31 | self._result_cache = list(self._iterable_class(self))
|
|---|
| 32 | File "/media/sf_django/django/db/models/query.py", line 176, in __iter__
|
|---|
| 33 | for row in compiler.results_iter(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size):
|
|---|
| 34 | File "/media/sf_django/django/db/models/sql/compiler.py", line 1013, in results_iter
|
|---|
| 35 | results = self.execute_sql(MULTI, chunked_fetch=chunked_fetch, chunk_size=chunk_size)
|
|---|
| 36 | File "/media/sf_django/django/db/models/sql/compiler.py", line 1061, in execute_sql
|
|---|
| 37 | cursor.execute(sql, params)
|
|---|
| 38 | File "/media/sf_django/django/db/backends/utils.py", line 68, in execute
|
|---|
| 39 | return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
|
|---|
| 40 | File "/media/sf_django/django/db/backends/utils.py", line 77, in _execute_with_wrappers
|
|---|
| 41 | return executor(sql, params, many, context)
|
|---|
| 42 | File "/media/sf_django/django/db/backends/utils.py", line 85, in _execute
|
|---|
| 43 | return self.cursor.execute(sql, params)
|
|---|
| 44 | File "/media/sf_django/django/db/utils.py", line 89, in __exit__
|
|---|
| 45 | raise dj_exc_value.with_traceback(traceback) from exc_value
|
|---|
| 46 | File "/media/sf_django/django/db/backends/utils.py", line 85, in _execute
|
|---|
| 47 | return self.cursor.execute(sql, params)
|
|---|
| 48 | File "/media/sf_django/django/db/backends/mysql/base.py", line 71, in execute
|
|---|
| 49 | return self.cursor.execute(query, args)
|
|---|
| 50 | File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/cursors.py", line 250, in execute
|
|---|
| 51 | self.errorhandler(self, exc, value)
|
|---|
| 52 | File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler
|
|---|
| 53 | raise errorvalue
|
|---|
| 54 | File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/cursors.py", line 247, in execute
|
|---|
| 55 | res = self._query(query)
|
|---|
| 56 | File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/cursors.py", line 412, in _query
|
|---|
| 57 | rowcount = self._do_query(q)
|
|---|
| 58 | File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/cursors.py", line 375, in _do_query
|
|---|
| 59 | db.query(q)
|
|---|
| 60 | File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/connections.py", line 276, in query
|
|---|
| 61 | _mysql.connection.query(self, query)
|
|---|
| 62 | 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")
|
|---|
| 63 |
|
|---|
| 64 | ======================================================================
|
|---|
| 65 | ERROR: test_range_unbound (expressions_window.tests.WindowFunctionTests)
|
|---|
| 66 | A query with RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING.
|
|---|
| 67 | ----------------------------------------------------------------------
|
|---|
| 68 | Traceback (most recent call last):
|
|---|
| 69 | File "/media/sf_django/django/db/backends/utils.py", line 85, in _execute
|
|---|
| 70 | return self.cursor.execute(sql, params)
|
|---|
| 71 | File "/media/sf_django/django/db/backends/mysql/base.py", line 71, in execute
|
|---|
| 72 | return self.cursor.execute(query, args)
|
|---|
| 73 | File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/cursors.py", line 250, in execute
|
|---|
| 74 | self.errorhandler(self, exc, value)
|
|---|
| 75 | File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler
|
|---|
| 76 | raise errorvalue
|
|---|
| 77 | File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/cursors.py", line 247, in execute
|
|---|
| 78 | res = self._query(query)
|
|---|
| 79 | File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/cursors.py", line 412, in _query
|
|---|
| 80 | rowcount = self._do_query(q)
|
|---|
| 81 | File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/cursors.py", line 375, in _do_query
|
|---|
| 82 | db.query(q)
|
|---|
| 83 | File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/connections.py", line 276, in query
|
|---|
| 84 | _mysql.connection.query(self, query)
|
|---|
| 85 | _mysql_exceptions.OperationalError: (4019, 'RANGE-type frame requires ORDER BY clause with single sort key')
|
|---|
| 86 |
|
|---|
| 87 | The above exception was the direct cause of the following exception:
|
|---|
| 88 |
|
|---|
| 89 | Traceback (most recent call last):
|
|---|
| 90 | File "/media/sf_django/tests/expressions_window/tests.py", line 583, in test_range_unbound
|
|---|
| 91 | ], transform=lambda row: (row.name, row.department, row.salary, row.hire_date, row.sum))
|
|---|
| 92 | File "/media/sf_django/django/test/testcases.py", line 967, in assertQuerysetEqual
|
|---|
| 93 | items = map(transform, qs)
|
|---|
| 94 | File "/media/sf_django/django/db/models/query.py", line 268, in __iter__
|
|---|
| 95 | self._fetch_all()
|
|---|
| 96 | File "/media/sf_django/django/db/models/query.py", line 1183, in _fetch_all
|
|---|
| 97 | self._result_cache = list(self._iterable_class(self))
|
|---|
| 98 | File "/media/sf_django/django/db/models/query.py", line 54, in __iter__
|
|---|
| 99 | results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
|
|---|
| 100 | File "/media/sf_django/django/db/models/sql/compiler.py", line 1061, in execute_sql
|
|---|
| 101 | cursor.execute(sql, params)
|
|---|
| 102 | File "/media/sf_django/django/db/backends/utils.py", line 68, in execute
|
|---|
| 103 | return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
|
|---|
| 104 | File "/media/sf_django/django/db/backends/utils.py", line 77, in _execute_with_wrappers
|
|---|
| 105 | return executor(sql, params, many, context)
|
|---|
| 106 | File "/media/sf_django/django/db/backends/utils.py", line 85, in _execute
|
|---|
| 107 | return self.cursor.execute(sql, params)
|
|---|
| 108 | File "/media/sf_django/django/db/utils.py", line 89, in __exit__
|
|---|
| 109 | raise dj_exc_value.with_traceback(traceback) from exc_value
|
|---|
| 110 | File "/media/sf_django/django/db/backends/utils.py", line 85, in _execute
|
|---|
| 111 | return self.cursor.execute(sql, params)
|
|---|
| 112 | File "/media/sf_django/django/db/backends/mysql/base.py", line 71, in execute
|
|---|
| 113 | return self.cursor.execute(query, args)
|
|---|
| 114 | File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/cursors.py", line 250, in execute
|
|---|
| 115 | self.errorhandler(self, exc, value)
|
|---|
| 116 | File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler
|
|---|
| 117 | raise errorvalue
|
|---|
| 118 | File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/cursors.py", line 247, in execute
|
|---|
| 119 | res = self._query(query)
|
|---|
| 120 | File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/cursors.py", line 412, in _query
|
|---|
| 121 | rowcount = self._do_query(q)
|
|---|
| 122 | File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/cursors.py", line 375, in _do_query
|
|---|
| 123 | db.query(q)
|
|---|
| 124 | File "/home/tim/.virtualenvs/django36/lib/python3.6/site-packages/MySQLdb/connections.py", line 276, in query
|
|---|
| 125 | _mysql.connection.query(self, query)
|
|---|
| 126 | django.db.utils.OperationalError: (4019, 'RANGE-type frame requires ORDER BY clause with single sort key')
|
|---|
| 127 |
|
|---|
| 128 | ======================================================================
|
|---|
| 129 | FAIL: test_function_list_of_values (expressions_window.tests.WindowFunctionTests)
|
|---|
| 130 | ----------------------------------------------------------------------
|
|---|
| 131 | Traceback (most recent call last):
|
|---|
| 132 | File "/media/sf_django/tests/expressions_window/tests.py", line 266, in test_function_list_of_values
|
|---|
| 133 | ('Brown', 53000, 'Sales', datetime.date(2009, 9, 1), None),
|
|---|
| 134 | AssertionError: Sequences differ: <QuerySet [('Jones', 45000, 'Accounting',[740 chars]ne)]> != [('Jones', 45000, 'Accounting', datetime.[729 chars]one)]
|
|---|
| 135 |
|
|---|
| 136 | First differing element 1:
|
|---|
| 137 | ('Williams', 37000, 'Accounting', datetime.date(2009, 6, 1), 50000)
|
|---|
| 138 | ('Jenson', 45000, 'Accounting', datetime.date(2008, 4, 1), 37000)
|
|---|
| 139 |
|
|---|
| 140 | Diff is 1600 characters long. Set self.maxDiff to None to see it.
|
|---|
| 141 |
|
|---|
| 142 | ======================================================================
|
|---|
| 143 | FAIL: test_lag (expressions_window.tests.WindowFunctionTests)
|
|---|
| 144 | ----------------------------------------------------------------------
|
|---|
| 145 | Traceback (most recent call last):
|
|---|
| 146 | File "/media/sf_django/tests/expressions_window/tests.py", line 203, in test_lag
|
|---|
| 147 | ], transform=lambda row: (row.name, row.salary, row.department, row.lag))
|
|---|
| 148 | File "/media/sf_django/django/test/testcases.py", line 976, in assertQuerysetEqual
|
|---|
| 149 | return self.assertEqual(list(items), values, msg=msg)
|
|---|
| 150 | AssertionError: Lists differ: [('Jones', 45000, 'Accounting', 45000), ('Wi[400 chars]one)] != [('Williams', 37000, 'Accounting', None), ('[400 chars]000)]
|
|---|
| 151 |
|
|---|
| 152 | First differing element 0:
|
|---|
| 153 | ('Jones', 45000, 'Accounting', 45000)
|
|---|
| 154 | ('Williams', 37000, 'Accounting', None)
|
|---|
| 155 |
|
|---|
| 156 | Diff is 846 characters long. Set self.maxDiff to None to see it.
|
|---|
| 157 |
|
|---|
| 158 | ======================================================================
|
|---|
| 159 | FAIL: test_lead (expressions_window.tests.WindowFunctionTests)
|
|---|
| 160 | ----------------------------------------------------------------------
|
|---|
| 161 | Traceback (most recent call last):
|
|---|
| 162 | File "/media/sf_django/tests/expressions_window/tests.py", line 389, in test_lead
|
|---|
| 163 | ], transform=lambda row: (row.name, row.salary, row.department, row.hire_date, row.lead))
|
|---|
| 164 | File "/media/sf_django/django/test/testcases.py", line 976, in assertQuerysetEqual
|
|---|
| 165 | return self.assertEqual(list(items), values, msg=msg)
|
|---|
| 166 | AssertionError: Lists differ: [('Jo[60 chars]), ('Williams', 37000, 'Accounting', datetime.[659 chars]one)] != [('Jo[60 chars]), ('Jenson', 45000, 'Accounting', datetime.da[659 chars]one)]
|
|---|
| 167 |
|
|---|
| 168 | First differing element 1:
|
|---|
| 169 | ('Williams', 37000, 'Accounting', datetime.date(2009, 6, 1), 50000)
|
|---|
| 170 | ('Jenson', 45000, 'Accounting', datetime.date(2008, 4, 1), 37000)
|
|---|
| 171 |
|
|---|
| 172 | Diff is 950 characters long. Set self.maxDiff to None to see it.
|
|---|
| 173 |
|
|---|
| 174 | ----------------------------------------------------------------------
|
|---|