]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
Fix get_columns sqlite reflection rejecting tables with WITHOUT_ROWID and/or STRICT...
authorTip ten Brink <75669206+tiptenbrink@users.noreply.github.com>
Mon, 15 Sep 2025 12:58:40 +0000 (08:58 -0400)
committerMike Bayer <mike_mp@zzzcomputing.com>
Mon, 15 Sep 2025 13:50:18 +0000 (09:50 -0400)
commit8cc6280ad327c4866757c010c9ab5570436d54b3
treee11a06a41d87358a3df1a054c021c6989f013192
parent655d783031995b7c31d60812016cb692b09747dc
Fix get_columns sqlite reflection rejecting tables with WITHOUT_ROWID and/or STRICT for generated column case

Fixed issue where SQLite table reflection would fail for tables using
``WITHOUT ROWID`` and/or ``STRICT`` table options when the table contained
generated columns. The regular expression used to parse ``CREATE TABLE``
statements for generated column detection has been updated to properly
handle these SQLite table options that appear after the column definitions.
Pull request courtesy Tip ten Brink.

Fixes: #12864
Closes: #12865
Pull-request: https://github.com/sqlalchemy/sqlalchemy/pull/12865
Pull-request-sha: 833420afc72f1918a9ca315209ce6664a18ba07f

Change-Id: Ia25c05746055a66234531b4f1275bd3a2f3b44ad
(cherry picked from commit d526cedef3cd742259af51dac7a8b35e6be6c9f2)
doc/build/changelog/unreleased_20/12864.rst [new file with mode: 0644]
lib/sqlalchemy/dialects/sqlite/base.py
test/dialect/test_sqlite.py