Compatibility with SQLAlchemy 2.1

[amotl]

Problem

The nightly CI workflow started failing on Jan 22, 3:45 AM GMT+1.

Details

Those tests were impacted.

• test_assign_to_object_type_after_commit
• test_change_tracking
• test_deep_nested_object_change_tracking
• test_delete_nested_object_tracking
• test_nested_object_change_tracking
• test_partial_dict_update_only_one_key_changed
• test_partial_dict_update_with_delitem
• test_partial_dict_update_with_delitem_setitem
• test_partial_dict_update_with_regular_column
• test_partial_dict_update_with_setitem_delitem
• test_partial_dict_update_with_setitem_delitem_setitem
• test_update_with_dict_column

Observations

The tests only fail on the particular CI matrix slot that permits Python pre-release packages.

Details

[amotl]

Evaluation

only the particular CI matrix slot fails that permits Python pre-release packages

Because all other test matrix slots succeed, it is unlikely that the problem is related with any specific CrateDB version.

[amotl]

The prerelease test matrix slot detected a regression with upcoming SQLAlchemy 2.1.

Using SQLAlchemy version: 2.1.0b1

-- https://github.com/crate/sqlalchemy-cratedb/actions/runs/21422834575/job/61685619836#step:6:362

[amotl]

We can observe those different types of exceptions.

sqlalchemy.exc.ObjectNotExecutableError: Not an executable object

KeyError: "Deferred loader for attribute 'name' failed to populate correctly"

AttributeError: '_BulkORMUpdate' object has no attribute '_ordered_values'

AttributeError: 'UpdateDMLState' object has no attribute '_ordered_values'

[amotl]

The latter two seem to have a tangible root cause, the others have not been investigated yet:

        if _compile_state_isinsert(compile_state) and compile_state._has_multi_parameters:
            mp = compile_state._multi_parameters
            assert mp is not None
            spd = mp[0]
            stmt_parameter_tuples = list(spd.items())
>       elif compile_state._ordered_values:
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
E       AttributeError: 'UpdateDMLState' object has no attribute '_ordered_values'
src/sqlalchemy_cratedb/compat/core20.py:278: AttributeError

-- https://github.com/crate/sqlalchemy-cratedb/actions/runs/21234082106/job/61098202676#step:6:1293

The _ordered_values attribute was removed with sqlalchemy/sqlalchemy@359f2ef.