Bundle SIM-048: asyncio stale/low urgency
Stale issue resolution sweepstale/low urgency4 issues0 PRsmedium
Issues #6121#12710#12803#12972
PRs none
- Diagnosis: This is a asyncio stale issue batch, not a single code diagnosis.
- Next action: Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.
- Evidence: issue #12972: stale/low urgency; labels: use case, asyncio; title: Move asyncio out of ext into the library proper | issue #12710: stale/low urgency; labels: bug, engine, asyncio; title: add extra shielding to async c...
- Short excerpt: issue #12972: stale/low urgency; labels: use case, asyncio; title: Move asyncio out of ext into the library proper | issue #12710: stale/low urgency; labels: bug, engine, asyncio; title: add extra shielding to async connection create | issue #12803: stale/low urgency; labels:...
- Package receipt: ee2d9d5933fa
Bundle SIM-049: #8693 sp_reset_connection not called on reused connections in pool. (MSSQL)
Stale issue resolution sweepstale/low urgency1 issue0 PRsmedium
- Diagnosis: This is a connection pool stale issue batch, not a single code diagnosis.
- Next action: Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.
- Evidence: issue #8693: stale/low urgency; labels: help wanted, documentation, connection pool, SQL Server, use case; title: sp_reset_connection not called on reused connections in pool. (MSSQL)
- Short excerpt: issue #8693: stale/low urgency; labels: help wanted, documentation, connection pool, SQL Server, use case; title: sp_reset_connection not called on reused connections in pool. (MSSQL)
- Package receipt: 71a7d9ef7e26
Bundle SIM-050: datatypes stale/low urgency
Stale issue resolution sweepstale/low urgency6 issues0 PRsmedium
Issues #4652#6874#7223#8936#11597#12628
PRs none
Context issues #3155#3444#7212
- Diagnosis: This is a datatypes stale issue batch, not a single code diagnosis.
- Next action: Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.
- Evidence: issue #12628: stale/low urgency; labels: oracle, datatypes, use case, mariadb; title: Add support for MariaDB Vector data type | issue #11597: stale/low urgency; labels: bug, datatypes, typing; title: sqltypes.Enum no...
- Short excerpt: issue #12628: stale/low urgency; labels: oracle, datatypes, use case, mariadb; title: Add support for MariaDB Vector data type | issue #11597: stale/low urgency; labels: bug, datatypes, typing; title: sqltypes.Enum not generic enough | issue #8936: stale/low urgency; labels: p...
- Review threads: thread:issue:7223, thread:issue:4652
- Package receipt: 33da5c425b40
Bundle SIM-051: declarative stale/low urgency
Stale issue resolution sweepstale/low urgency3 issues0 PRsmedium
Issues #5806#6411#9147
PRs none
Context issues #9832
- Diagnosis: This is a declarative stale issue batch, not a single code diagnosis.
- Next action: Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.
- Evidence: issue #6411: stale/low urgency; labels: declarative, use case; title: add new attribute_declared event for decalrative, intercepts all declared attrs but particularly Column | issue #5806: stale/low urgency; labels: b...
- Short excerpt: issue #6411: stale/low urgency; labels: declarative, use case; title: add new attribute_declared event for decalrative, intercepts all declared attrs but particularly Column | issue #5806: stale/low urgency; labels: bug, declarative, quagmire; title: favor module names over ta...
- Review threads: thread:issue:9147
- Package receipt: 8c91f1b2f93a
Bundle SIM-052: dialects stale/low urgency
Stale issue resolution sweepstale/low urgency2 issues0 PRsmedium
Issues #8321#10680
PRs none
- Diagnosis: This is a dialects stale issue batch, not a single code diagnosis.
- Next action: Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.
- Evidence: issue #8321: stale/low urgency; labels: sql, use case, upserts, dialects; title: Unify INSERT ... ON CONFLICT / UPSERT / MERGE functionality in single implementation | issue #10680: stale/low urgency; labels: use case...
- Short excerpt: issue #8321: stale/low urgency; labels: sql, use case, upserts, dialects; title: Unify INSERT ... ON CONFLICT / UPSERT / MERGE functionality in single implementation | issue #10680: stale/low urgency; labels: use case, dialects; title: upgrade default driver for psycopg, oracledb
- Package receipt: 393966f127d1
Bundle SIM-053: dml stale/low urgency
Stale issue resolution sweepstale/low urgency2 issues0 PRsmedium
Issues #10446#12096
PRs none
- Diagnosis: This is a dml stale issue batch, not a single code diagnosis.
- Next action: Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.
- Evidence: issue #12096: stale/low urgency; labels: bug, orm, hard orm, dml; title: delete with join and returning clause doesn't work on SQLAlchemy 2 | issue #10446: stale/low urgency; labels: orm, use case, dml; title: Support...
- Short excerpt: issue #12096: stale/low urgency; labels: bug, orm, hard orm, dml; title: delete with join and returning clause doesn't work on SQLAlchemy 2 | issue #10446: stale/low urgency; labels: orm, use case, dml; title: Support synonym with bulk_insert_mappings and insert
- Package receipt: cb73805708ef
Bundle SIM-054: documentation stale/low urgency
Stale issue resolution sweepstale/low urgency14 issues0 PRsmedium
Issues #4567#4706#4784#4790#5235#6332#7360#7517#8894#9839#10116#11062+2
PRs none
Context issues #4360#5151#6515#9586#9603#9618
- Diagnosis: This is a documentation stale issue batch, not a single code diagnosis.
- Next action: Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.
- Evidence: issue #11284: stale/low urgency; labels: bug, documentation, tests, schema; title: Missing batch_op.f() | issue #6332: stale/low urgency; labels: documentation, SQLA mypy plugin, typing; title: Documentation: use ORM...
- Short excerpt: issue #11284: stale/low urgency; labels: bug, documentation, tests, schema; title: Missing batch_op.f() | issue #6332: stale/low urgency; labels: documentation, SQLA mypy plugin, typing; title: Documentation: use ORM declarative attributes in .values instead of kwargs in "ORM-...
- Review threads: thread:issue:4784:issue:4790, thread:issue:9839, thread:issue:4567, +1
- Package receipt: 2a1d91dc821c
Bundle SIM-055: #6489 support autocommit w/ explicit isolation levels
Stale issue resolution sweepstale/low urgency2 issues0 PRsmedium
Issues #5815#6489
PRs none
Context issues #3357
- Diagnosis: This is a engine stale issue batch, not a single code diagnosis.
- Next action: Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.
- Evidence: as discussed at #3357, an additional execution option `dbapi_autocommit=True` that sets autocommit independently of setting an explicit isolation level would be | issue #5815: stale/low urgency; labels: engine, use ca...
- Short excerpt: as discussed at #3357, an additional execution option `dbapi_autocommit=True` that sets autocommit independently of setting an explicit isolation level would be | issue #5815: stale/low urgency; labels: engine, use case; title: Support transaction read only access mode API, im...
- Review threads: thread:issue:6489
- Package receipt: 4440d833569f
Bundle SIM-056: #5006 support for unusual function namespace separators
Stale issue resolution sweepstale/low urgency1 issue0 PRsmedium
- Diagnosis: This is a functions stale issue batch, not a single code diagnosis.
- Next action: Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.
- Evidence: issue #5006: stale/low urgency; labels: SQL Server, functions, use case; title: support for unusual function namespace separators
- Short excerpt: issue #5006: stale/low urgency; labels: SQL Server, functions, use case; title: support for unusual function namespace separators
- Package receipt: d29d725511e9
Bundle SIM-057: bug stale/low urgency
Stale issue resolution sweepstale/low urgency3 issues0 PRsmedium
Issues #2814#10064#10835
PRs none
- Diagnosis: This is a general stale issue batch, not a single code diagnosis.
- Next action: Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.
- Evidence: issue #10835: stale/low urgency; labels: bug, cextensions, orm - annotated declarative; title: sqlalchemy.util.OrderedSet does not work with v2 in ORM mappings | issue #10064: stale/low urgency; labels: bug, dataclass...
- Short excerpt: issue #10835: stale/low urgency; labels: bug, cextensions, orm - annotated declarative; title: sqlalchemy.util.OrderedSet does not work with v2 in ORM mappings | issue #10064: stale/low urgency; labels: bug, dataclasses, orm - annotated declarative; title: MappedAsDataclass, p...
- Package receipt: aae91f9f7e64
Bundle SIM-058: loader options stale/low urgency
Stale issue resolution sweepstale/low urgency4 issues0 PRsmedium
Issues #3037#5964#7426#8431
PRs none
Context issues #4340
- Diagnosis: This is a loader options stale issue batch, not a single code diagnosis.
- Next action: Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.
- Evidence: issue #7426: stale/low urgency; labels: bug, orm, loader options, hard orm; title: targeting of highly self-referential id column within a subquery w contains_eager | issue #3037: stale/low urgency; labels: feature, o...
- Short excerpt: issue #7426: stale/low urgency; labels: bug, orm, loader options, hard orm; title: targeting of highly self-referential id column within a subquery w contains_eager | issue #3037: stale/low urgency; labels: feature, orm, loader options; title: support setting load options on i...
- Review threads: thread:issue:8431
- Package receipt: f365e299b371
Bundle SIM-059: mariadb stale/low urgency
Stale issue resolution sweepstale/low urgency2 issues0 PRsmedium
Issues #7228#12561
PRs none
- Diagnosis: This is a mariadb stale issue batch, not a single code diagnosis.
- Next action: Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.
- Evidence: issue #12561: stale/low urgency; labels: bug, mysql, mariadb; title: Recover two-phase in mysql is currently unusable since it uses a legacy row index method | issue #7228: stale/low urgency; labels: feature, sqlite,...
- Short excerpt: issue #12561: stale/low urgency; labels: bug, mysql, mariadb; title: Recover two-phase in mysql is currently unusable since it uses a legacy row index method | issue #7228: stale/low urgency; labels: feature, sqlite, mariadb; title: Incorrect code for sa.values on SQLite and M...
- Package receipt: 020f8c762d4e
Bundle SIM-060: mysql stale/low urgency
Stale issue resolution sweepstale/low urgency2 issues0 PRsmedium
Issues #1909#4272
PRs none
- Diagnosis: This is a mysql stale issue batch, not a single code diagnosis.
- Next action: Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.
- Evidence: issue #4272: stale/low urgency; labels: feature, schema, mysql; title: suport MySQL inline indexes e.g. KEY(col) in DDL | issue #1909: stale/low urgency; labels: bug, mysql, reflection, quagmire; title: reflection iss...
- Short excerpt: issue #4272: stale/low urgency; labels: feature, schema, mysql; title: suport MySQL inline indexes e.g. KEY(col) in DDL | issue #1909: stale/low urgency; labels: bug, mysql, reflection, quagmire; title: reflection issue with mysql, url with no schema failure
- Package receipt: 0cf509038913
Bundle SIM-061: #7718 create oracle_dblink table option
Stale issue resolution sweepstale/low urgency2 issues0 PRsmedium
Issues #7718#12341
PRs none
Context issues #4379
- Diagnosis: This is a oracle stale issue batch, not a single code diagnosis.
- Next action: Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.
- Evidence: scussed in https://github.com/sqlalchemy/sqlalchemy/discussions/7717 this is very trivial and I think we will be able to make use of it for #4379 in any case: ```py from sqlalchemy import Column from sqlalchemy import...
- Short excerpt: scussed in https://github.com/sqlalchemy/sqlalchemy/discussions/7717 this is very trivial and I think we will be able to make use of it for #4379 in any case: ```py from sqlalchemy import Column from sqlalchemy import DateTime from sqlalchemy import MetaData from sqlalchemy im...
- Review threads: thread:issue:7718
- Package receipt: b5132f02baca
Bundle SIM-062: orm stale/low urgency queue (2 issues)
Stale issue resolution sweepstale/low urgency31 issues0 PRsmedium
Issues #1063#1140#2501#2792#3458#4641#5005#5541#6080#6137#6860#6997+19
PRs none
Context issues #3496#3990#4640#5068#6550#8285#8889
- Diagnosis: This is a orm stale issue batch, not a single code diagnosis.
- Next action: Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.
- Evidence: issues #8070 and #8311 share title/component terms: add, method | issue #9197: stale/low urgency; labels: orm, use case, dataclasses; title: Support for mapping frozen dataclasses | issue #12575: stale/low urgency; la...
- Short excerpt: issues #8070 and #8311 share title/component terms: add, method | issue #9197: stale/low urgency; labels: orm, use case, dataclasses; title: Support for mapping frozen dataclasses | issue #12575: stale/low urgency; labels: orm, use case; title: prefixing Composite Column Types...
- Review threads: thread:issue:10859:issue:4641, thread:issue:1063:issue:10936, thread:issue:9690, +3
- Package receipt: c5d222d0b9db
Bundle SIM-063: #4855 instance_state can't raise an informative exception due to performance concerns. write C function?
Stale issue resolution sweepstale/low urgency1 issue0 PRsmedium
- Diagnosis: This is a performance stale issue batch, not a single code diagnosis.
- Next action: Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.
- Evidence: issue #4855: stale/low urgency; labels: bug, performance, quagmire; title: instance_state can't raise an informative exception due to performance concerns. write C function?
- Short excerpt: issue #4855: stale/low urgency; labels: bug, performance, quagmire; title: instance_state can't raise an informative exception due to performance concerns. write C function?
- Package receipt: 1cde772c8fcb
Bundle SIM-064: Review thread: 2 issues - Issue #4289 - support None for index name
Stale issue resolution sweepstale/low urgency5 issues0 PRsmedium
Issues #4289#5350#6612#7475#9944
PRs none
Context issues #3566#3989#5256#7706#8574
- Diagnosis: This is a postgresql stale issue batch, not a single code diagnosis.
- Next action: Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.
- Evidence: **Michael Bayer ([@zzzeek](https://github.com/zzzeek)) wrote:** we *do* truncate specifically for indexes, see #4289. | the `ForeignKeyConstraint` separately via `__table_args__` works like a charm. I'd note that, whe...
- Short excerpt: **Michael Bayer ([@zzzeek](https://github.com/zzzeek)) wrote:** we *do* truncate specifically for indexes, see #4289. | the `ForeignKeyConstraint` separately via `__table_args__` works like a charm. I'd note that, when I saw this, I though that it could solve #7706. But, I sti...
- Review threads: thread:issue:4289:issue:5350, thread:issue:7475, thread:issue:6612
- Package receipt: b7c864daad38
Bundle SIM-065: #8680 Better organize pep 484 types in the packages
Stale issue resolution sweepstale/low urgency1 issue0 PRsmedium
- Diagnosis: This is a public api stale issue batch, not a single code diagnosis.
- Next action: Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.
- Evidence: issue #8680: stale/low urgency; labels: public api, typing; title: Better organize pep 484 types in the packages
- Short excerpt: issue #8680: stale/low urgency; labels: public api, typing; title: Better organize pep 484 types in the packages
- Package receipt: c226ff2d33ce
Bundle SIM-066: reflection stale/low urgency
Stale issue resolution sweepstale/low urgency4 issues0 PRsmedium
Issues #10435#10742#11385#11677
PRs none
Context PRs PR #11678
- Diagnosis: This is a reflection stale issue batch, not a single code diagnosis.
- Next action: Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.
- Evidence: issue #11385: stale/low urgency; labels: reflection, use case; title: Add additional information to the `ReflectedColumn` | issue #10742: stale/low urgency; labels: bug, SQL Server, reflection; title: Bad PrimaryKeyCo...
- Short excerpt: issue #11385: stale/low urgency; labels: reflection, use case; title: Add additional information to the `ReflectedColumn` | issue #10742: stale/low urgency; labels: bug, SQL Server, reflection; title: Bad PrimaryKeyConstraint metadata for MSSQL temporary table | issue #10435:...
- Review threads: thread:issue:11677
- Package receipt: fea0d98e77a8
Bundle SIM-067: #13007 Change the default to False of addconstraint / dropconstraint isolate_from_table
Stale issue resolution sweepstale/low urgency2 issues0 PRsmedium
Issues #9233#13007
PRs none
Context issues #13006
- Diagnosis: This is a schema stale issue batch, not a single code diagnosis.
- Next action: Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.
- Evidence: Follow up of #13006 Set to False the default value and remove the warning | issue #9233: stale/low urgency; labels: bug, schema; title: Expression index does not list all the columns
- Short excerpt: Follow up of #13006 Set to False the default value and remove the warning | issue #9233: stale/low urgency; labels: bug, schema; title: Expression index does not list all the columns
- Review threads: thread:issue:13007
- Package receipt: 38a09d5ac86e
Bundle SIM-068: sql stale/low urgency
Stale issue resolution sweepstale/low urgency8 issues0 PRsmedium
Issues #1452#6040#6336#6700#7113#9425#10326#10780
PRs none
Context issues #4797
- Diagnosis: This is a sql stale issue batch, not a single code diagnosis.
- Next action: Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.
- Evidence: issue #10780: stale/low urgency; labels: sql, use case; title: name with flat for aliased() | issue #10326: stale/low urgency; labels: sql, use case; title: Allow InstrumentedAttribute in corresponding_column | issue...
- Short excerpt: issue #10780: stale/low urgency; labels: sql, use case; title: name with flat for aliased() | issue #10326: stale/low urgency; labels: sql, use case; title: Allow InstrumentedAttribute in corresponding_column | issue #9425: stale/low urgency; labels: bug, sql; title: tighten u...
- Review threads: thread:issue:6040:issue:7113
- Package receipt: 91d7e1837feb
Bundle SIM-069: #5352 Can not select negated boolean column in MS SQL Server
Stale issue resolution sweepstale/low urgency1 issue0 PRsmedium
Issues #5352
PRs none
Context issues #4250
- Diagnosis: This is a sql server stale issue batch, not a single code diagnosis.
- Next action: Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.
- Evidence: hi there - how interesting that the exact test case from #4250 is still failing though I would assume in a different way from what was fixed there. this limitation has more to do with SQL Server not bei | ` operator i...
- Short excerpt: hi there - how interesting that the exact test case from #4250 is still failing though I would assume in a different way from what was fixed there. this limitation has more to do with SQL Server not bei | ` operator is supported in SQLAlchemy. So the statement `SELECT ~a.flag...
- Review threads: thread:issue:5352
- Package receipt: 3793ed0c2863
Bundle SIM-070: #10544 pysqlcipher open fail with err: TypeError: function takes at most 3 arguments (4 given) in dbapi_connection.create_function
Stale issue resolution sweepstale/low urgency1 issue0 PRsmedium
Issues #10544
PRs none
Context PRs PR #10545
- Diagnosis: This is a sqlite stale issue batch, not a single code diagnosis.
- Next action: Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.
- Evidence: pr #10545 declares a closing reference to issue #10544. | <!-- Provide a general summary of your proposed changes in the Title field above --> to fix the pysqlcipher broken usage in 2.0.22 with pysqlcipher3 new master...
- Short excerpt: pr #10545 declares a closing reference to issue #10544. | <!-- Provide a general summary of your proposed changes in the Title field above --> to fix the pysqlcipher broken usage in 2.0.22 with pysqlcipher3 new master ### Description issue fix : https://github.com/sqlalchemy/s...
- Review threads: thread:issue:10544
- Package receipt: 096520524394
Bundle SIM-071: tests stale/low urgency
Stale issue resolution sweepstale/low urgency7 issues0 PRsmedium
Issues #5174#6468#6505#7035#7135#8805#9370
PRs none
Context PRs PR #7009
- Diagnosis: This is a tests stale issue batch, not a single code diagnosis.
- Next action: Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.
- Evidence: issue #9370: stale/low urgency; labels: bug, tests; title: Create a way to run all the examples in the pipeline | issue #7135: stale/low urgency; labels: bug, tests; title: mysql/test_for_update is very slow on ci | i...
- Short excerpt: issue #9370: stale/low urgency; labels: bug, tests; title: Create a way to run all the examples in the pipeline | issue #7135: stale/low urgency; labels: bug, tests; title: mysql/test_for_update is very slow on ci | issue #6505: stale/low urgency; labels: tests, use case; titl...
- Review threads: thread:issue:7035
- Package receipt: 85e248abcfd6
Bundle SIM-072: typing stale/low urgency
Stale issue resolution sweepstale/low urgency2 issues0 PRsmedium
Issues #8909#10417
PRs none
- Diagnosis: This is a typing stale issue batch, not a single code diagnosis.
- Next action: Apply one sweep policy: close with rationale when no live reproducer exists, mark canonical duplicates, or promote still-reproducible failures into a local PR draft package.
- Evidence: issue #10417: stale/low urgency; labels: wontfix / out of scope, expected behavior, typing; title: mypy: coerced legacy syntax with subquery can not be typed | issue #8909: stale/low urgency; labels: help wanted, quag...
- Short excerpt: issue #10417: stale/low urgency; labels: wontfix / out of scope, expected behavior, typing; title: mypy: coerced legacy syntax with subquery can not be typed | issue #8909: stale/low urgency; labels: help wanted, quagmire, typing; title: using @declared_attr does not recognize...
- Package receipt: cafa886f4a7b