]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
projects / thirdparty / sqlalchemy / sqlalchemy.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: de7f141) | patch
Support DEFAULT VALUES and VALUES(DEFAULT) individually
authorMike Bayer <mike_mp@zzzcomputing.com>
Tue, 13 Apr 2021 14:52:00 +0000 (10:52 -0400)
committerMike Bayer <mike_mp@zzzcomputing.com>
Wed, 14 Apr 2021 16:51:58 +0000 (12:51 -0400)
commit94a1c523984e2082bb16d784cf8615061ba9d49a
tree73892187edabbfa4a371631c3407510cfdea9313tree | snapshot
parentde7f14104d5278987fa72d6866fa39569e56077ecommit | diff
Support DEFAULT VALUES and VALUES(DEFAULT) individually

Fixed regression where the introduction of the INSERT syntax "INSERT...
VALUES (DEFAULT)" was not supported on some backends that do however
support "INSERT..DEFAULT VALUES", including SQLite. The two syntaxes are
now each individually supported or non-supported for each dialect, for
example MySQL supports "VALUES (DEFAULT)" but not "DEFAULT VALUES".
Support for Oracle is still not enabled as there are unresolved issues
in using RETURNING at the same time.

Fixes: #6254
Change-Id: I47959bc826e3d9d2396ccfa290eb084841b02e77
17 files changed:
doc/build/changelog/unreleased_14/6254.rst [new file with mode: 0644] blob
lib/sqlalchemy/dialects/mysql/base.py diff | blob | blame | history
lib/sqlalchemy/dialects/oracle/base.py diff | blob | blame | history
lib/sqlalchemy/dialects/postgresql/base.py diff | blob | blame | history
lib/sqlalchemy/dialects/sqlite/base.py diff | blob | blame | history
lib/sqlalchemy/engine/default.py diff | blob | blame | history
lib/sqlalchemy/sql/compiler.py diff | blob | blame | history
lib/sqlalchemy/sql/crud.py diff | blob | blame | history
lib/sqlalchemy/testing/assertions.py diff | blob | blame | history
lib/sqlalchemy/testing/assertsql.py diff | blob | blame | history
lib/sqlalchemy/testing/requirements.py diff | blob | blame | history
lib/sqlalchemy/testing/suite/test_insert.py diff | blob | blame | history
test/engine/test_deprecations.py diff | blob | blame | history
test/orm/inheritance/test_basic.py diff | blob | blame | history
test/requirements.py diff | blob | blame | history
test/sql/test_defaults.py diff | blob | blame | history
test/sql/test_insert.py diff | blob | blame | history
Mirror of https://github.com/sqlalchemy/sqlalchemy.git