diff options
author | Mike Bayer <mike_mp@zzzcomputing.com> | 2016-10-04 16:46:08 -0400 |
---|---|---|
committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2016-10-04 17:31:40 -0400 |
commit | 20384e894577bc6cd7e686a71e6e859207565d00 (patch) | |
tree | e4695f067ce8586070e5e3a40aec57f646dc022f /lib/sqlalchemy/engine | |
parent | e5a5a72e175d7c6a70d5b2a0399377c7a133cced (diff) | |
download | sqlalchemy-20384e894577bc6cd7e686a71e6e859207565d00.tar.gz |
Check row for None with implicit returning PK to accommodate ON CONFLICT
An adjustment to ON CONFLICT such that the "inserted_primary_key"
logic is able to accommodate the case where there's no INSERT or
UPDATE and there's no net change. The value comes out as None
in this case, rather than failing on an exception.
Change-Id: I0794e95c3ca262cb1ab2387167d96b8984225fce
Fixes: #3813
Diffstat (limited to 'lib/sqlalchemy/engine')
-rw-r--r-- | lib/sqlalchemy/engine/default.py | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/lib/sqlalchemy/engine/default.py b/lib/sqlalchemy/engine/default.py index 733a89076..891103ee0 100644 --- a/lib/sqlalchemy/engine/default.py +++ b/lib/sqlalchemy/engine/default.py @@ -502,6 +502,7 @@ class DefaultExecutionContext(interfaces.ExecutionContext): compiled = None statement = None result_column_struct = None + returned_defaults = None _is_implicit_returning = False _is_explicit_returning = False @@ -917,10 +918,13 @@ class DefaultExecutionContext(interfaces.ExecutionContext): ] def _setup_ins_pk_from_implicit_returning(self, row): + if row is None: + self.inserted_primary_key = None + return + key_getter = self.compiled._key_getters_for_crud_column[2] table = self.compiled.statement.table compiled_params = self.compiled_parameters[0] - self.inserted_primary_key = [ row[col] if value is None else value for col, value in [ |