[Sqlalchemy-tickets] Issue #3649: Tests fail with Python built with newer sqlite (zzzeek/sqlalchemy)

[cwebber <iss...@bi...>]

New issue 3649: Tests fail with Python built with newer sqlite
https://bitbucket.org/zzzeek/sqlalchemy/issues/3649/tests-fail-with-python-built-with-newer

cwebber:

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