diff options
| author | CaselIT <cfederico87@gmail.com> | 2023-02-04 13:28:42 +0100 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2023-02-26 10:33:29 -0500 |
| commit | 5c71fd120af824d289cf72dd4b5679a4f839a1eb (patch) | |
| tree | b373439e832f57841c9f0611232e8524aca70b2d /setup.cfg | |
| parent | cbc13309a154dd59ae428f14fa2e7340a5fcb6fc (diff) | |
| download | alembic-5c71fd120af824d289cf72dd4b5679a4f839a1eb.tar.gz | |
Improved support for expression indexes
Added support for autogenerate comparison of indexes on PostgreSQL which
include SQL expressions; the previous warning that such indexes were
skipped is now removed. This functionality requires SQLAlchemy 2.0.
For older SQLAlchemy versions, these indexes are still skipped.
Fixed issue where indexes on SQLite which include SQL expressions would not
compare against themselves correctly, generating false positives.
SQLAlchemy as of version 2 has no support for reflecting expression based
indexes on SQLite; so for now, the behavior is that SQLite expression-based
indexes are ignored for autogenerate compare, in the same way that
PostgreSQL expression-based indexes were ignored for the time that
SQLAlchemy did not support reflection of such indexes (which is now
supported in SQLAlchemy 2.0 as well as this release of Alembic).
Fixed issue in index detection where autogenerate change detection would
consider indexes with the same columns but with different order as equal,
while in general they are not equivalent in how a database will use them.
Fixes: #1165
Fixes: #1166
Change-Id: I226408eed855b923172e5df0bdab005ed2cc9f53
Diffstat (limited to 'setup.cfg')
| -rw-r--r-- | setup.cfg | 2 |
1 files changed, 1 insertions, 1 deletions
@@ -114,7 +114,7 @@ oracle8=oracle://scott:tiger@127.0.0.1:1521/?use_ansi=0 [tool:pytest] -addopts= --tb native -v -r sfxX -p no:warnings -p no:logging --maxfail=25 +addopts= --tb native -v -r sfxX -p no:warnings -p no:logging --maxfail=100 python_files=tests/test_*.py markers = backend: tests that should run on all backends; typically dialect-sensitive |