sqlalchemy/sqlalchemy issues and pull requests

#12868 - JSONB subscript index not used anymore after sqlalchemy 2.0.42

Issue - State: closed - Opened by valumapps 2 months ago - 8 comments
Labels: bug, documentation, postgresql, regression, great mcve, json

#12648 - more mysql server default parenthesization rules are needed to know to not render parenthesis for a function that is exactly NOW/CURRENT_TIMESTAMP with fractional seconds

Issue - State: closed - Opened by zzzeek 6 months ago - 2 comments
Labels: bug, mysql, regression

#12600 - Reflection regression in postgresql

Issue - State: closed - Opened by CaselIT 7 months ago - 18 comments
Labels: bug, postgresql, reflection, regression

#12451 - Invalid SQL emitted using aliased() and two tables with the same name in different schemas

Issue - State: closed - Opened by loic-simon 9 months ago - 4 comments
Labels: bug, sql, regression, near-term release

#12174 - all PG domain reflection tests failing for pg17

Issue - State: closed - Opened by zzzeek 12 months ago - 7 comments
Labels: postgresql, blocker, reflection, regression

#12019 - Unable to use IN operator in 2.0.36 to select a list of columns

Issue - State: closed - Opened by CaselIT about 1 year ago - 8 comments
Labels: bug, sql, regression

#12002 - TypeDecorator pickling error in 2.0, works fine in 1.4.54

Issue - State: closed - Opened by zzzeek about 1 year ago - 2 comments
Labels: bug, datatypes, regression, near-term release

#11965 - Backwards incompatible break in 2.0.31? "assertion failed attempting to produce joined eager loads"

Issue - State: closed - Opened by bchopson about 1 year ago - 3 comments
Labels: bug, orm, loader options, regression

#11840 - `get_check_constraints` result changed in SQLAlchemy 2.0.33-34

Issue - State: closed - Opened by ziima about 1 year ago - 9 comments
Labels: bug, sqlite, blocker, reflection, regression

#11832 - `get_check_constraints` result changed in SQLAlchemy 2.0.33

Issue - State: closed - Opened by harupy about 1 year ago - 8 comments
Labels: sqlite, reflection, awaiting info, regression, near-term release

#11703 - with_statement_hint() has lost its generative capability

Issue - State: closed - Opened by zzzeek over 1 year ago - 3 comments
Labels: bug, sql, blocker, regression, near-term release

#11661 - restore list mutation in `bulk_insert_mappings` with `return_defaults=True`

Issue - State: closed - Opened by zzzeek over 1 year ago - 5 comments
Labels: bug, orm, regression, patch provided, near-term release, dml

#11625 - delete statement generates invalid SQL starting with 2.0.21

Issue - State: closed - Opened by zzzeek over 1 year ago - 2 comments
Labels: bug, regression, inheritance, near-term release, dml

#11562 - TypeError when calling .one() on an AppenderQuery from instance not in session

Issue - State: closed - Opened by clj over 1 year ago - 4 comments
Labels: orm, regression, near-term release

#11200 - regression due to #11055

Issue - State: closed - Opened by zzzeek over 1 year ago - 10 comments
Labels: bug, regression, typing, near-term release

#11173 - Behaviour of subqueryload is inconsistent going from 2.0.27 to 2.0.28 (using postgres)

Issue - State: open - Opened by zzzeek over 1 year ago
Labels: bug, orm, loader options, regression, statement caching, near-term release

#11085 - avoid full clone / traversal for _extra_criteria if no bound parameters

Issue - State: closed - Opened by zzzeek over 1 year ago - 12 comments
Labels: bug, orm, performance, regression, statement caching

#11010 - Version 2.0.14 seems to broke one of my queries which used `Relationship.and_(...)`

Issue - State: closed - Opened by zzzeek almost 2 years ago - 2 comments
Labels: orm, regression, near-term release

#10920 - Versioning with a History Table in 2.0 copies indexes and has name conflicts

Issue - State: closed - Opened by zzzeek almost 2 years ago - 2 comments
Labels: regression, near-term release, examples

#10834 - Query with enable_eagerloads(False) and yield_per() raises InvalidRequestError

Issue - State: closed - Opened by james-emerton almost 2 years ago - 3 comments
Labels: bug, regression, near-term release

#10098 - Use of session without ORM results in `'NoneType' object has no attribute 'mapper'` AttributeError

Issue - State: closed - Opened by stephenfin over 2 years ago - 6 comments
Labels: bug, orm, regression, great mcve, near-term release

#10069 - support postgresql host forms that have a colon in them but are not multihost format

Issue - State: closed - Opened by aebrahim over 2 years ago - 17 comments
Labels: bug, postgresql, regression, near-term release

#9820 - sqlalchemy.orm.mapper.validates() behavior change

Issue - State: closed - Opened by zzzeek over 2 years ago - 1 comment
Labels: bug, orm, regression, near-term release

#9767 - `DELETE RETURNING` and `UPDATE RETURNING` CTEs no longer compile with ORM API in SQLAlchemy 2.0

Issue - State: closed - Opened by optimalstrategy over 2 years ago - 3 comments
Labels: bug, orm, regression, great mcve, near-term release

#9739 - Commit two or more objects with `LargeBinary` column throws `sqlalchemy.exc.DBAPIError`

Issue - State: closed - Opened by Rubikoid over 2 years ago - 2 comments
Labels: bug, postgresql, regression, near-term release

#9701 - Floats are rounded to whole numbers when inserted in batches

Issue - State: closed - Opened by rbuffat over 2 years ago - 14 comments
Labels: bug, postgresql, datatypes, regression, near-term release

#9682 - SQLAlchemy v2.x: URL.normalized_query throws AttributeError (while v1.4x did not)

Issue - State: closed - Opened by davidandreoletti over 2 years ago - 3 comments
Labels: bug, engine, regression, near-term release

#9611 - postgresql ENUM auto-chooses the name from the given Enum, so "name" needs to be optional

Issue - State: closed - Opened by al-dpopowich over 2 years ago - 3 comments
Labels: bug, postgresql, regression

#9583 - ORM-enabled insert silently fails on values() w/ bindparam(), due to insert mode auto-detection

Issue - State: closed - Opened by zzzeek over 2 years ago - 3 comments
Labels: bug, orm, regression, near-term release

#9442 - we likely need to keep some mention of postgresql 8.2 around to have nominal redshift support

Issue - State: closed - Opened by zoomequipd over 2 years ago - 20 comments
Labels: bug, wontfix / out of scope, postgresql, regression, near-term release

#8661 - `Invalid precision value` when inserting long string on varchar column in SQLAlchemy 2.0.0b1

Issue - State: closed - Opened by harupy about 3 years ago - 8 comments
Labels: bug, SQL Server, datatypes, regression, great mcve

#6409 - 1.4.11 Got Future <Future pending> attached to a different loop when using asyncio.gather()

Issue - State: closed - Opened by FNSdev over 4 years ago - 8 comments
Labels: bug, regression, great mcve, asyncio

#6274 - Fix the error message when aliased() is invoked against a select() or union() and do legacy coercion

Issue - State: open - Opened by andrewcooke over 4 years ago - 6 comments
Labels: bug, orm, regression

#5698 - Cannot query Redshift in 1.4.0b1

Issue - State: closed - Opened by ravisurdhar about 5 years ago - 5 comments
Labels: bug, postgresql, regression

GitHub / sqlalchemy/sqlalchemy issues and pull requests