rel_2_0_43
📦 sqlalchemyView on GitHub →
✨ 2 features🐛 4 fixes🔧 6 symbols
Summary
SQLAlchemy 2.0.43 introduces a new `skip_autocommit_rollback` engine option and adds sparse vector support to Oracle, while fixing several ORM and PostgreSQL bugs.
✨ New Features
- Added new parameter `create_engine.skip_autocommit_rollback` to prevent DBAPI `.rollback()` calls when connection is in autocommit mode, improving MySQL performance.
- Extended `_oracle.VECTOR` to support sparse vectors by introducing `_oracle.VectorStorageType` and `_oracle.SparseVector`.
🐛 Bug Fixes
- Fixed `post_update` feature applying incorrect pre-fetched values after multi-row UPDATE, which could cause subsequent DELETE failures.
- Fixed `_orm.mapped_column.use_existing_column` not working inside `Annotated` type aliases in polymorphic inheritance scenarios.
- Improved `_orm.selectin_polymorphic` loader to chunk IN expressions into 500-record batches, avoiding database limits (e.g., Oracle).
- Fixed PostgreSQL JSONB subscription syntax regression by correctly wrapping function calls in parentheses.
🔧 Affected Symbols
_orm.selectin_polymorphic_orm.mapped_columncreate_engine_oracle.VECTOR_oracle.VectorStorageType_oracle.SparseVector