]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
Updates for MariaDB sequences
authorFederico Caselli <cfederico87@gmail.com>
Fri, 21 Aug 2020 22:30:44 +0000 (00:30 +0200)
committerMike Bayer <mike_mp@zzzcomputing.com>
Sat, 22 Aug 2020 16:46:12 +0000 (12:46 -0400)
commit9ab4da7018eae8fc86430c24a38f8ffb0a5951ab
treed6f9e401cbc24a3beb11a9fec56dd17f89cfe6fe
parent317f2e1be2b06cdc12bc84510eb743d9752763dd
Updates for MariaDB sequences

MariaDB should not run a Sequence if it has optional=True.
Additionally, rework the rules in crud.py to accommodate the
new combination MariaDB brings us, which is a dialect
that supports both cursor.lastrowid, explicit sequences,
*and* no support for returning.

Co-authored-by: Mike Bayer <mike_mp@zzzcomputing.com>
Fixes: #5528
Change-Id: I9a8ea69a34983affa95dfd22186e2908fdf0d58c
12 files changed:
lib/sqlalchemy/dialects/mysql/base.py
lib/sqlalchemy/dialects/postgresql/base.py
lib/sqlalchemy/engine/default.py
lib/sqlalchemy/sql/compiler.py
lib/sqlalchemy/sql/crud.py
lib/sqlalchemy/testing/requirements.py
test/dialect/mysql/test_on_duplicate.py
test/engine/test_execute.py
test/requirements.py
test/sql/test_insert_exec.py
test/sql/test_returning.py
test/sql/test_sequences.py