11 test failures with PyPy3.9 7.3.11 in 2.0.0 (and git main) #9154

============================================================== FAILURES ===============================================================
__________________________________________ DictOfTupleUpdateTest.test_update_multi_elem_varg __________________________________________
[gw0] linux -- Python 3.9.16 /tmp/sqlalchemy/.tox/pypy3/bin/python
Traceback (most recent call last):
  File "/tmp/sqlalchemy/lib/sqlalchemy/testing/assertions.py", line 441, in _expect_raises
    yield ec
  File "/tmp/sqlalchemy/lib/sqlalchemy/testing/assertions.py", line 418, in _assert_raises
    callable_(*args, **kwargs)
  File "/tmp/sqlalchemy/lib/sqlalchemy/ext/associationproxy.py", line 1755, in update
    up.update(*a, **kw)
TypeError: dict.update() takes from 0 to 1 positional arguments but 2 were given

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/tmp/sqlalchemy/test/ext/test_associationproxy.py", line 2404, in test_update_multi_elem_varg
    assert_raises_message(
  File "/tmp/sqlalchemy/lib/sqlalchemy/testing/assertions.py", line 368, in assert_raises_message
    return _assert_raises(
  File "/tmp/sqlalchemy/lib/sqlalchemy/testing/assertions.py", line 418, in _assert_raises
    callable_(*args, **kwargs)
  File "/usr/lib/pypy3.9/contextlib.py", line 137, in __exit__
    self.gen.throw(typ, value, traceback)
  File "/tmp/sqlalchemy/lib/sqlalchemy/testing/assertions.py", line 450, in _expect_raises
    assert re.search(msg, error_as_string, re.UNICODE), "%r !~ %s" % (
AssertionError: 'update expected at most 1 arguments?, got 2' !~ dict.update() takes from 0 to 1 positional arguments but 2 were given
assert None
 +  where None = <function search at 0x00007fd3de58d880>('update expected at most 1 arguments?, got 2', 'dict.update() takes from 0 to 1 positional arguments but 2 were given', re.UNICODE)
 +    where <function search at 0x00007fd3de58d880> = re.search
 +    and   re.UNICODE = re.UNICODE
------------------------------------------------------ Captured stderr teardown -------------------------------------------------------
Error emptying table b: OperationalError('(_sqlite3.OperationalError) no such table: b')
Error emptying table a: OperationalError('(_sqlite3.OperationalError) no such table: a')
___________________________________________ DictOfTupleUpdateTest.test_update_one_elem_varg ___________________________________________
[gw0] linux -- Python 3.9.16 /tmp/sqlalchemy/.tox/pypy3/bin/python
Traceback (most recent call last):
  File "/tmp/sqlalchemy/lib/sqlalchemy/testing/assertions.py", line 441, in _expect_raises
    yield ec
  File "/tmp/sqlalchemy/lib/sqlalchemy/testing/assertions.py", line 418, in _assert_raises
    callable_(*args, **kwargs)
  File "/tmp/sqlalchemy/lib/sqlalchemy/ext/associationproxy.py", line 1755, in update
    up.update(*a, **kw)
ValueError: sequence of pairs expected

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/tmp/sqlalchemy/test/ext/test_associationproxy.py", line 2394, in test_update_one_elem_varg
    assert_raises_message(
  File "/tmp/sqlalchemy/lib/sqlalchemy/testing/assertions.py", line 368, in assert_raises_message
    return _assert_raises(
  File "/tmp/sqlalchemy/lib/sqlalchemy/testing/assertions.py", line 418, in _assert_raises
    callable_(*args, **kwargs)
  File "/usr/lib/pypy3.9/contextlib.py", line 137, in __exit__
    self.gen.throw(typ, value, traceback)
  File "/tmp/sqlalchemy/lib/sqlalchemy/testing/assertions.py", line 450, in _expect_raises
    assert re.search(msg, error_as_string, re.UNICODE), "%r !~ %s" % (
AssertionError: 'dictionary update sequence element #1 has length 5; 2 is required' !~ sequence of pairs expected
assert None
 +  where None = <function search at 0x00007fd3de58d880>('dictionary update sequence element #1 has length 5; 2 is required', 'sequence of pairs expected', re.UNICODE)
 +    where <function search at 0x00007fd3de58d880> = re.search
 +    and   re.UNICODE = re.UNICODE
------------------------------------------------------ Captured stderr teardown -------------------------------------------------------
Error emptying table b: OperationalError('(_sqlite3.OperationalError) no such table: b')
Error emptying table a: OperationalError('(_sqlite3.OperationalError) no such table: a')
____________________________________________ ProxyHybridTest.test_msg_fails_on_cls_access _____________________________________________
[gw0] linux -- Python 3.9.16 /tmp/sqlalchemy/.tox/pypy3/bin/python
Traceback (most recent call last):
  File "/tmp/sqlalchemy/lib/sqlalchemy/ext/associationproxy.py", line 639, in for_proxy
    cls._cls_unwrap_target_assoc_proxy(target_class, value_attr),
  File "/tmp/sqlalchemy/lib/sqlalchemy/ext/associationproxy.py", line 710, in _cls_unwrap_target_assoc_proxy
    attr = getattr(target_class, value_attr)
  File "/tmp/sqlalchemy/lib/sqlalchemy/ext/hybrid.py", line 932, in __get__
    return self._expr_comparator(owner)
  File "/tmp/sqlalchemy/lib/sqlalchemy/ext/hybrid.py", line 1162, in expr_comparator
    comparator(owner),
  File "/tmp/sqlalchemy/lib/sqlalchemy/ext/hybrid.py", line 1132, in _expr
    return ExprComparator(cls, expr(cls), self)
  File "/tmp/sqlalchemy/test/ext/test_associationproxy.py", line 3424, in fails_on_class_access
    return len(self.data)
TypeError: 'InstrumentedAttribute' has no length

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

Traceback (most recent call last):
  File "/tmp/sqlalchemy/lib/sqlalchemy/testing/assertions.py", line 441, in _expect_raises
    yield ec
  File "/tmp/sqlalchemy/test/ext/test_associationproxy.py", line 3445, in test_msg_fails_on_cls_access
    a1.fails_on_class_access
  File "/tmp/sqlalchemy/lib/sqlalchemy/ext/associationproxy.py", line 426, in __get__
    inst = self._as_instance(owner, instance)
  File "/tmp/sqlalchemy/lib/sqlalchemy/ext/associationproxy.py", line 491, in _as_instance
    inst = AssociationProxyInstance.for_proxy(self, owner, obj)
  File "/tmp/sqlalchemy/lib/sqlalchemy/ext/associationproxy.py", line 649, in for_proxy
    raise exc.InvalidRequestError(
sqlalchemy.exc.InvalidRequestError: Association proxy received an unexpected error when trying to retreive attribute "B.fails_on_class_access" from class "B": 'InstrumentedAttribute' has no length

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/tmp/sqlalchemy/test/ext/test_associationproxy.py", line 3445, in test_msg_fails_on_cls_access
    a1.fails_on_class_access
  File "/usr/lib/pypy3.9/contextlib.py", line 137, in __exit__
    self.gen.throw(typ, value, traceback)
  File "/tmp/sqlalchemy/lib/sqlalchemy/testing/assertions.py", line 450, in _expect_raises
    assert re.search(msg, error_as_string, re.UNICODE), "%r !~ %s" % (
AssertionError: 'Association proxy received an unexpected error when trying to retreive attribute "B.fails_on_class_access" from class "B": .* no len\\(\\)' !~ Association proxy received an unexpected error when trying to retreive attribute "B.fails_on_class_access" from class "B": 'InstrumentedAttribute' has no length
assert None
 +  where None = <function search at 0x00007fd3de58d880>('Association proxy received an unexpected error when trying to retreive attribute "B.fails_on_class_access" from class "B": .* no len\\(\\)', 'Association proxy received an unexpected error when trying to retreive attribute "B.fails_on_class_access" from class "B": \'InstrumentedAttribute\' has no length', re.UNICODE)
 +    where <function search at 0x00007fd3de58d880> = re.search
 +    and   re.UNICODE = re.UNICODE
------------------------------------------------------ Captured stderr teardown -------------------------------------------------------
Error emptying table c: OperationalError('(_sqlite3.OperationalError) no such table: c')
Error emptying table b: OperationalError('(_sqlite3.OperationalError) no such table: b')
Error emptying table a: OperationalError('(_sqlite3.OperationalError) no such table: a')
__________________________________ TestTypes_sqlite+pysqlite_3_40_1.test_cant_parse_datetime_message __________________________________
[gw2] linux -- Python 3.9.16 /tmp/sqlalchemy/.tox/pypy3/bin/python
Traceback (most recent call last):
  File "/usr/lib/pypy3.9/datetime.py", line 1488, in fromisoformat
    return cls(*_parse_isoformat_time(time_string))
  File "/usr/lib/pypy3.9/datetime.py", line 335, in _parse_isoformat_time
    time_comps = _parse_hh_mm_ss_ff(timestr)
  File "/usr/lib/pypy3.9/datetime.py", line 296, in _parse_hh_mm_ss_ff
    time_comps[comp] = int(tstr[pos:pos+2])
ValueError: invalid literal for int() with base 10: 'AS'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/tmp/sqlalchemy/lib/sqlalchemy/testing/assertions.py", line 441, in _expect_raises
    yield ec
  File "/tmp/sqlalchemy/lib/sqlalchemy/testing/assertions.py", line 418, in _assert_raises
    callable_(*args, **kwargs)
  File "/tmp/sqlalchemy/test/dialect/test_sqlite.py", line 122, in <lambda>
    lambda: connection.execute(
  File "/tmp/sqlalchemy/lib/sqlalchemy/engine/result.py", line 1541, in scalar
    return self._only_one_row(
  File "/tmp/sqlalchemy/lib/sqlalchemy/engine/result.py", line 749, in _only_one_row
    row = make_row(row) if make_row else row
  File "/usr/lib/pypy3.9/functools.py", line 302, in __call__
    return self.func(*self.args, *args, **keywords)
  File "/tmp/sqlalchemy/lib/sqlalchemy/engine/_py_row.py", line 64, in __init__
    [
  File "/tmp/sqlalchemy/lib/sqlalchemy/engine/_py_row.py", line 65, in <listcomp>
    proc(value) if proc else value
  File "/tmp/sqlalchemy/lib/sqlalchemy/engine/_py_processors.py", line 125, in str_to_time
    dt_value = time_cls.fromisoformat(value)
  File "/usr/lib/pypy3.9/datetime.py", line 1490, in fromisoformat
    raise ValueError(f'Invalid isoformat string: {time_string!r}')
ValueError: Invalid isoformat string: 'ASDF'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/tmp/sqlalchemy/test/dialect/test_sqlite.py", line 119, in test_cant_parse_datetime_message
    assert_raises_message(
  File "/tmp/sqlalchemy/lib/sqlalchemy/testing/assertions.py", line 368, in assert_raises_message
    return _assert_raises(
  File "/tmp/sqlalchemy/lib/sqlalchemy/testing/assertions.py", line 418, in _assert_raises
    callable_(*args, **kwargs)
  File "/usr/lib/pypy3.9/contextlib.py", line 137, in __exit__
    self.gen.throw(typ, value, traceback)
  File "/tmp/sqlalchemy/lib/sqlalchemy/testing/assertions.py", line 455, in _expect_raises
    _assert_proper_exception_context(err)
  File "/tmp/sqlalchemy/lib/sqlalchemy/testing/assertions.py", line 352, in _assert_proper_exception_context
    assert False, (
AssertionError: Exception ValueError("Invalid isoformat string: 'ASDF'") was correctly raised but did not set a cause, within context ValueError("invalid literal for int() with base 10: 'AS'") as its cause.
assert False
____________________________________________ PyDateProcessorTest.test_date_invalid_string _____________________________________________
[gw1] linux -- Python 3.9.16 /tmp/sqlalchemy/.tox/pypy3/bin/python
Traceback (most recent call last):
  File "/usr/lib/pypy3.9/datetime.py", line 895, in fromisoformat
    assert len(date_string) == 10
AssertionError

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/tmp/sqlalchemy/lib/sqlalchemy/testing/assertions.py", line 441, in _expect_raises
    yield ec
  File "/tmp/sqlalchemy/lib/sqlalchemy/testing/assertions.py", line 418, in _assert_raises
    callable_(*args, **kwargs)
  File "/tmp/sqlalchemy/lib/sqlalchemy/engine/_py_processors.py", line 133, in str_to_date
    dt_value = date_cls.fromisoformat(value)
  File "/usr/lib/pypy3.9/datetime.py", line 898, in fromisoformat
    raise ValueError(f'Invalid isoformat string: {date_string!r}')
ValueError: Invalid isoformat string: '5:a'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/tmp/sqlalchemy/test/engine/test_processors.py", line 105, in test_date_invalid_string
    assert_raises_message(
  File "/tmp/sqlalchemy/lib/sqlalchemy/testing/assertions.py", line 368, in assert_raises_message
    return _assert_raises(
  File "/tmp/sqlalchemy/lib/sqlalchemy/testing/assertions.py", line 418, in _assert_raises
    callable_(*args, **kwargs)
  File "/usr/lib/pypy3.9/contextlib.py", line 137, in __exit__
    self.gen.throw(typ, value, traceback)
  File "/tmp/sqlalchemy/lib/sqlalchemy/testing/assertions.py", line 455, in _expect_raises
    _assert_proper_exception_context(err)
  File "/tmp/sqlalchemy/lib/sqlalchemy/testing/assertions.py", line 352, in _assert_proper_exception_context
    assert False, (
AssertionError: Exception ValueError("Invalid isoformat string: '5:a'") was correctly raised but did not set a cause, within context AssertionError() as its cause.
assert False
__________________________________________ PyDateProcessorTest.test_datetime_invalid_string ___________________________________________
[gw1] linux -- Python 3.9.16 /tmp/sqlalchemy/.tox/pypy3/bin/python
Traceback (most recent call last):
  File "/usr/lib/pypy3.9/datetime.py", line 1781, in fromisoformat
    date_components = _parse_isoformat_date(dstr)
  File "/usr/lib/pypy3.9/datetime.py", line 273, in _parse_isoformat_date
    year = int(dtstr[0:4])
ValueError: invalid literal for int() with base 10: '5:a'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/tmp/sqlalchemy/lib/sqlalchemy/testing/assertions.py", line 441, in _expect_raises
    yield ec
  File "/tmp/sqlalchemy/lib/sqlalchemy/testing/assertions.py", line 418, in _assert_raises
    callable_(*args, **kwargs)
  File "/tmp/sqlalchemy/lib/sqlalchemy/engine/_py_processors.py", line 117, in str_to_datetime
    dt_value = datetime_cls.fromisoformat(value)
  File "/usr/lib/pypy3.9/datetime.py", line 1783, in fromisoformat
    raise ValueError(f'Invalid isoformat string: {date_string!r}')
ValueError: Invalid isoformat string: '5:a'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/tmp/sqlalchemy/test/engine/test_processors.py", line 113, in test_datetime_invalid_string
    assert_raises_message(
  File "/tmp/sqlalchemy/lib/sqlalchemy/testing/assertions.py", line 368, in assert_raises_message
    return _assert_raises(
  File "/tmp/sqlalchemy/lib/sqlalchemy/testing/assertions.py", line 418, in _assert_raises
    callable_(*args, **kwargs)
  File "/usr/lib/pypy3.9/contextlib.py", line 137, in __exit__
    self.gen.throw(typ, value, traceback)
  File "/tmp/sqlalchemy/lib/sqlalchemy/testing/assertions.py", line 455, in _expect_raises
    _assert_proper_exception_context(err)
  File "/tmp/sqlalchemy/lib/sqlalchemy/testing/assertions.py", line 352, in _assert_proper_exception_context
    assert False, (
AssertionError: Exception ValueError("Invalid isoformat string: '5:a'") was correctly raised but did not set a cause, within context ValueError("invalid literal for int() with base 10: '5:a'") as its cause.
assert False
____________________________________________ PyDateProcessorTest.test_time_invalid_string _____________________________________________
[gw1] linux -- Python 3.9.16 /tmp/sqlalchemy/.tox/pypy3/bin/python
Traceback (most recent call last):
  File "/usr/lib/pypy3.9/datetime.py", line 1488, in fromisoformat
    return cls(*_parse_isoformat_time(time_string))
  File "/usr/lib/pypy3.9/datetime.py", line 335, in _parse_isoformat_time
    time_comps = _parse_hh_mm_ss_ff(timestr)
  File "/usr/lib/pypy3.9/datetime.py", line 296, in _parse_hh_mm_ss_ff
    time_comps[comp] = int(tstr[pos:pos+2])
ValueError: invalid literal for int() with base 10: '5:'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/tmp/sqlalchemy/lib/sqlalchemy/testing/assertions.py", line 441, in _expect_raises
    yield ec
  File "/tmp/sqlalchemy/lib/sqlalchemy/testing/assertions.py", line 418, in _assert_raises
    callable_(*args, **kwargs)
  File "/tmp/sqlalchemy/lib/sqlalchemy/engine/_py_processors.py", line 125, in str_to_time
    dt_value = time_cls.fromisoformat(value)
  File "/usr/lib/pypy3.9/datetime.py", line 1490, in fromisoformat
    raise ValueError(f'Invalid isoformat string: {time_string!r}')
ValueError: Invalid isoformat string: '5:a'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/tmp/sqlalchemy/test/engine/test_processors.py", line 121, in test_time_invalid_string
    assert_raises_message(
  File "/tmp/sqlalchemy/lib/sqlalchemy/testing/assertions.py", line 368, in assert_raises_message
    return _assert_raises(
  File "/tmp/sqlalchemy/lib/sqlalchemy/testing/assertions.py", line 418, in _assert_raises
    callable_(*args, **kwargs)
  File "/usr/lib/pypy3.9/contextlib.py", line 137, in __exit__
    self.gen.throw(typ, value, traceback)
  File "/tmp/sqlalchemy/lib/sqlalchemy/testing/assertions.py", line 455, in _expect_raises
    _assert_proper_exception_context(err)
  File "/tmp/sqlalchemy/lib/sqlalchemy/testing/assertions.py", line 352, in _assert_proper_exception_context
    assert False, (
AssertionError: Exception ValueError("Invalid isoformat string: '5:a'") was correctly raised but did not set a cause, within context ValueError("invalid literal for int() with base 10: '5:'") as its cause.
assert False
____________________________________ ReturningGuardsTest_sqlite+pysqlite_3_40_1.test_delete_single ____________________________________
[gw3] linux -- Python 3.9.16 /tmp/sqlalchemy/.tox/pypy3/bin/python
Traceback (most recent call last):
  File "/tmp/sqlalchemy/lib/sqlalchemy/testing/suite/test_dialect.py", line 670, in test_delete_single
    run_stmt(stmt, False, "b_id", connection.dialect.delete_returning)
  File "/tmp/sqlalchemy/lib/sqlalchemy/testing/suite/test_dialect.py", line 595, in go
    connection.execute(
  File "/usr/lib/pypy3.9/contextlib.py", line 126, in __exit__
    next(self.gen)
  File "/tmp/sqlalchemy/lib/sqlalchemy/testing/assertions.py", line 466, in _expect_raises
    assert success, "Callable did not raise an exception"
AssertionError: Callable did not raise an exception
assert False
____________________________________ ReturningGuardsTest_sqlite+pysqlite_3_40_1.test_insert_single ____________________________________
[gw3] linux -- Python 3.9.16 /tmp/sqlalchemy/.tox/pypy3/bin/python
Traceback (most recent call last):
  File "/tmp/sqlalchemy/lib/sqlalchemy/testing/suite/test_dialect.py", line 611, in test_insert_single
    run_stmt(stmt, False, "id", connection.dialect.insert_returning)
  File "/tmp/sqlalchemy/lib/sqlalchemy/testing/suite/test_dialect.py", line 595, in go
    connection.execute(
  File "/usr/lib/pypy3.9/contextlib.py", line 126, in __exit__
    next(self.gen)
  File "/tmp/sqlalchemy/lib/sqlalchemy/testing/assertions.py", line 466, in _expect_raises
    assert success, "Callable did not raise an exception"
AssertionError: Callable did not raise an exception
assert False
____________________________________ ReturningGuardsTest_sqlite+pysqlite_3_40_1.test_update_single ____________________________________
[gw3] linux -- Python 3.9.16 /tmp/sqlalchemy/.tox/pypy3/bin/python
Traceback (most recent call last):
  File "/tmp/sqlalchemy/lib/sqlalchemy/testing/suite/test_dialect.py", line 636, in test_update_single
    run_stmt(stmt, False, "b_id", connection.dialect.update_returning)
  File "/tmp/sqlalchemy/lib/sqlalchemy/testing/suite/test_dialect.py", line 595, in go
    connection.execute(
  File "/usr/lib/pypy3.9/contextlib.py", line 126, in __exit__
    next(self.gen)
  File "/tmp/sqlalchemy/lib/sqlalchemy/testing/assertions.py", line 466, in _expect_raises
    assert success, "Callable did not raise an exception"
AssertionError: Callable did not raise an exception
assert False
____________________________________________________ ImmutableDictTest.test_pep584 ____________________________________________________
[gw2] linux -- Python 3.9.16 /tmp/sqlalchemy/.tox/pypy3/bin/python
Traceback (most recent call last):
  File "/tmp/sqlalchemy/test/base/test_utils.py", line 356, in test_pep584
    i2 = {"x": 3} | i2
  File "/tmp/sqlalchemy/lib/sqlalchemy/util/_py_collections.py", line 145, in __ror__
    return immutabledict(super().__ror__(__value))
AttributeError: 'super' object has no attribute '__ror__'. Did you mean: '__dir__'?
-------------------------------------------------------- Captured stdout call ---------------------------------------------------------
b'immutabledict object is immutable'