Package: python3-sqlalchemy Version: 1.4.46+ds1-1 Severity: normal Tags: upstream patch X-Debbugs-Cc: dalg...@gmail.com
Dear Maintainer, Using sqlalchemy's reflection feature will result in an incomplete definition of computed/generated columns (those using "GENERATED ALWAYS AS") in sqlite if the expression includes a function call (e.g., INSTR()). I reported this to sqlalchemy thinking is was a user error, but ended up being a bug. A fix has been developed, but not yet released for either 1.4 or 2.0. If the patch could be brought in for either, I would be appreciative, but understand if not. At the least, it would be good for 2.0 I think. Upstream report: https://github.com/sqlalchemy/sqlalchemy/discussions/11580 Upstream bug: https://github.com/sqlalchemy/sqlalchemy/issues/11582 Upstream patch: https://github.com/sqlalchemy/sqlalchemy/issues/11582#issuecomment-2212392525 Hmm... I just noticed that the submitted patch for the 2_0 branch has the changelog entry in the "unreleased_14" directory. I suppose you all are the experts are sqlalchemy stuff and would know if this is working-as-intended or not. (I suppose I cheated in "including a patch" by pointing to an existing one.) Thanks, mrc -- System Information: Debian Release: 12.6 APT prefers stable-updates APT policy: (500, 'stable-updates'), (500, 'stable-security'), (500, 'stable') Architecture: amd64 (x86_64) Kernel: Linux 6.1.0-21-amd64 (SMP w/12 CPU threads; PREEMPT) Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8), LANGUAGE not set Shell: /bin/sh linked to /usr/bin/dash Init: systemd (via /run/systemd/system) LSM: AppArmor: enabled Versions of packages python3-sqlalchemy depends on: ii python3 3.11.2-1+b1 ii python3-greenlet 2.0.2-1 ii python3-importlib-metadata 4.12.0-1 Versions of packages python3-sqlalchemy recommends: ii python3-sqlalchemy-ext 1.4.46+ds1-1+b1 Versions of packages python3-sqlalchemy suggests: pn python-sqlalchemy-doc <none> pn python3-aiosqlite <none> pn python3-asyncpg <none> pn python3-fdb <none> pn python3-mysqldb <none> pn python3-psycopg2 <none> pn python3-pymssql <none> -- no debconf information
