]> 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:48:33 +0000 (09:48 -0400)
commitd526cedef3cd742259af51dac7a8b35e6be6c9f2
treed5fb9a39aad1299d394c4b8f95ed540310dc173b
parent13f569fd615485c50e07f211e37e45d749ccc40d
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
doc/build/changelog/unreleased_20/12864.rst [new file with mode: 0644]
lib/sqlalchemy/dialects/sqlite/base.py
test/dialect/test_sqlite.py