gistfile1.txt

test/orm/inheritance/test_with_poly.py::PolymorphicUnionsTest::test_col_expression_base_plus_two_subs PASSED [ 99%]
test/orm/inheritance/test_with_poly.py::PolymorphicUnionsTest::test_join_base_to_sub PASSED [ 99%]
test/orm/inheritance/test_with_poly.py::PolymorphicUnionsTest::test_join_to_join_columns PASSED [ 99%]
test/orm/inheritance/test_with_poly.py::PolymorphicUnionsTest::test_join_to_join_entities PASSED [ 99%]
test/aaa_profiling/test_zoomark.py::ZooMarkTest::test_invocation SKIPPED [ 99%]
test/aaa_profiling/test_zoomark_orm.py::ZooMarkTest::test_invocation SKIPPED [100%]

=================================== FAILURES ===================================
_____________ QueryTest_sqlite+pysqlite_3_30_0.test_order_by_nulls _____________
Traceback (most recent call last):
  File "/nix/store/9h3wjm32pbqax1bvq6g7344xxcz4fi5w-python3.7-SQLAlchemy-1.3.10/lib/python3.7/site-packages/sqlalchemy/testing/exclusions.py", line 96, in decorate
    return self._do(config._current, fn, *args, **kw)
  File "/nix/store/9h3wjm32pbqax1bvq6g7344xxcz4fi5w-python3.7-SQLAlchemy-1.3.10/lib/python3.7/site-packages/sqlalchemy/testing/exclusions.py", line 125, in _do
    self._expect_success(cfg, name=fn.__name__)
  File "/nix/store/9h3wjm32pbqax1bvq6g7344xxcz4fi5w-python3.7-SQLAlchemy-1.3.10/lib/python3.7/site-packages/sqlalchemy/testing/exclusions.py", line 153, in _expect_success
    fail._as_string(config) for fail in self.fails
AssertionError: Unexpected success for 'test_order_by_nulls' (not postgresql and not oracle and not firebird)
_________________ SessionBindTest.test_column_property_select __________________
Traceback (most recent call last):
  File "/nix/store/9h3wjm32pbqax1bvq6g7344xxcz4fi5w-python3.7-SQLAlchemy-1.3.10/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1249, in _execute_context
    cursor, statement, parameters, context
  File "/nix/store/9h3wjm32pbqax1bvq6g7344xxcz4fi5w-python3.7-SQLAlchemy-1.3.10/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 580, in do_execute
    cursor.execute(statement, parameters)
sqlite3.OperationalError: misuse of aggregate: max()

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/build/SQLAlchemy-1.3.10/test/orm/test_query.py", line 5586, in test_column_property_select
    session.query(func.max(User.score)).scalar()
  File "/nix/store/9h3wjm32pbqax1bvq6g7344xxcz4fi5w-python3.7-SQLAlchemy-1.3.10/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3330, in scalar
    ret = self.one()
  File "/nix/store/9h3wjm32pbqax1bvq6g7344xxcz4fi5w-python3.7-SQLAlchemy-1.3.10/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3300, in one
    ret = self.one_or_none()
  File "/nix/store/9h3wjm32pbqax1bvq6g7344xxcz4fi5w-python3.7-SQLAlchemy-1.3.10/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3269, in one_or_none
    ret = list(self)
  File "/nix/store/9h3wjm32pbqax1bvq6g7344xxcz4fi5w-python3.7-SQLAlchemy-1.3.10/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3342, in __iter__
    return self._execute_and_instances(context)
  File "/nix/store/9h3wjm32pbqax1bvq6g7344xxcz4fi5w-python3.7-SQLAlchemy-1.3.10/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3367, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)
  File "/nix/store/9h3wjm32pbqax1bvq6g7344xxcz4fi5w-python3.7-SQLAlchemy-1.3.10/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 988, in execute
    return meth(self, multiparams, params)
  File "/nix/store/9h3wjm32pbqax1bvq6g7344xxcz4fi5w-python3.7-SQLAlchemy-1.3.10/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 287, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/nix/store/9h3wjm32pbqax1bvq6g7344xxcz4fi5w-python3.7-SQLAlchemy-1.3.10/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1107, in _execute_clauseelement
    distilled_params,
  File "/nix/store/9h3wjm32pbqax1bvq6g7344xxcz4fi5w-python3.7-SQLAlchemy-1.3.10/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1253, in _execute_context
    e, statement, parameters, cursor, context
  File "/nix/store/9h3wjm32pbqax1bvq6g7344xxcz4fi5w-python3.7-SQLAlchemy-1.3.10/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1473, in _handle_dbapi_exception
    util.raise_from_cause(sqlalchemy_exception, exc_info)
  File "/nix/store/9h3wjm32pbqax1bvq6g7344xxcz4fi5w-python3.7-SQLAlchemy-1.3.10/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 398, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb, cause=cause)
  File "/nix/store/9h3wjm32pbqax1bvq6g7344xxcz4fi5w-python3.7-SQLAlchemy-1.3.10/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 152, in reraise
    raise value.with_traceback(tb)
  File "/nix/store/9h3wjm32pbqax1bvq6g7344xxcz4fi5w-python3.7-SQLAlchemy-1.3.10/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1249, in _execute_context
    cursor, statement, parameters, context
  File "/nix/store/9h3wjm32pbqax1bvq6g7344xxcz4fi5w-python3.7-SQLAlchemy-1.3.10/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 580, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) misuse of aggregate: max()
[SQL: SELECT max((SELECT sum(addresses.id) AS sum_1
FROM addresses, users
WHERE addresses.user_id = users.id)) AS max_1]
(Background on this error at: http://sqlalche.me/e/e3q8)