From d5bb919aa6d5b9961f85987dfaa58d5999910d15 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Wed, 21 Dec 2016 13:39:56 -0500 Subject: Call nextval() on sequence when doing INSERT from SELECT Fixed bug where an INSERT from SELECT where the source table contains an autoincrementing Sequence would fail to compile correctly. Change-Id: I41eb9f65789a4007712ae61ed5fa23a9839a5128 Fixes: #3877 --- lib/sqlalchemy/sql/crud.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'lib/sqlalchemy/sql/crud.py') diff --git a/lib/sqlalchemy/sql/crud.py b/lib/sqlalchemy/sql/crud.py index 9d10fbefc..9808b7d90 100644 --- a/lib/sqlalchemy/sql/crud.py +++ b/lib/sqlalchemy/sql/crud.py @@ -505,7 +505,7 @@ def _append_param_insert_select_hasdefault( (not c.default.optional or not compiler.dialect.sequences_optional): proc = c.default - values.append((c, proc)) + values.append((c, proc.next_value())) elif c.default.is_clause_element: proc = c.default.arg.self_group() values.append((c, proc)) -- cgit v1.2.1