- edited description
Tests fail with Python built with newer sqlite
Issue #3649
duplicate
Python built with sqlite 3.8.11.1 and before seems to be working fine. Building with newer versions of sqlite, such as 3.10.0 or 3.10.2 results in failing tests:
=================================== FAILURES ===================================
__________ QueryTest_sqlite_pysqlite.test_column_accessor_sqlite_raw ___________
Traceback (most recent call last):
File "<string>", line 2, in test_column_accessor_sqlite_raw
File "/tmp/guix-build-python-sqlalchemy-0.9.7.drv-0/SQLAlchemy-0.9.7/test/../lib/sqlalchemy/testing/exclusions.py", line 72, in decorate
return fn(*args, **kw)
File "/tmp/guix-build-python-sqlalchemy-0.9.7.drv-0/SQLAlchemy-0.9.7/test/sql/test_query.py", line 898, in test_column_accessor_sqlite_raw
assert 'user_id' not in r
AssertionError: assert 'user_id' not in (1, 'john')
_______ QueryTest_sqlite_pysqlite.test_column_accessor_sqlite_translated _______
Traceback (most recent call last):
File "/tmp/guix-build-python-sqlalchemy-0.9.7.drv-0/SQLAlchemy-0.9.7/test/../lib/sqlalchemy/engine/result.py", line 70, in __getitem__
processor, obj, index = self._keymap[key]
KeyError: 'query_users.user_id'
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "<string>", line 2, in test_column_accessor_sqlite_translated
File "/tmp/guix-build-python-sqlalchemy-0.9.7.drv-0/SQLAlchemy-0.9.7/test/../lib/sqlalchemy/testing/exclusions.py", line 72, in decorate
return fn(*args, **kw)
File "/tmp/guix-build-python-sqlalchemy-0.9.7.drv-0/SQLAlchemy-0.9.7/test/sql/test_query.py", line 918, in test_column_accessor_sqlite_translated
eq_(r['query_users.user_id'], 1)
File "/tmp/guix-build-python-sqlalchemy-0.9.7.drv-0/SQLAlchemy-0.9.7/test/../lib/sqlalchemy/engine/result.py", line 72, in __getitem__
processor, obj, index = self._parent._key_fallback(key)
File "/tmp/guix-build-python-sqlalchemy-0.9.7.drv-0/SQLAlchemy-0.9.7/test/../lib/sqlalchemy/engine/result.py", line 331, in _key_fallback
expression._string_or_unprintable(key))
sqlalchemy.exc.NoSuchColumnError: "Could not locate column in row for column 'query_users.user_id'"
=========================== short test summary info ============================
FAIL test/sql/test_query.py::QueryTest_sqlite_pysqlite::()::test_column_accessor_sqlite_raw
FAIL test/sql/test_query.py::QueryTest_sqlite_pysqlite::()::test_column_accessor_sqlite_translated
============= 2 failed, 5803 passed, 737 skipped in 237.59 seconds =============
phase `check' failed after 241.9 seconds
Comments (3)
-
reporter -
repo owner - changed status to duplicate
Duplicate of
#3633. -
repo owner this is backported back to 1.0.12 for release soon. if you are building 0.9.7. for a distro you'd need to patch it locally.
- Log in to comment