RETURNING clause is not supported in positioned (WHERE CURRENT OF) UPDATE and DELETE statements [CORE3343] #3709
Assignees
Comments
Modified by: @dyemanovVersion: 2.5.0 [ 10221 ] Version: 3.0 Initial [ 10301 ] Version: 2.1.3 [ 10302 ] Version: 2.1.2 [ 10270 ] Version: 2.1.1 [ 10223 ] Version: 2.1.0 [ 10041 ] summary: "UPDATE ... WHERE CURRENT OF ... RETURNING ..." not prepare in PSQL => RETURNING clause is not supported in positioned (WHERE CURRENT OF) UPDATE and DELETE statements Version: 2.5.1 [ 10333 ] => |
Modified by: @asfernandes |
Modified by: @asfernandesassignee: Adriano dos Santos Fernandes [ asfernandes ] |
Modified by: @asfernandesissuetype: Bug [ 1 ] => Improvement [ 4 ] |
Modified by: @asfernandesstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 3.0 Alpha 1 [ 10331 ] |
firebird-automations
added
affect-version: 2.5.0
affect-version: 3.0 Initial
affect-version: 2.1.3
affect-version: 2.1.2
affect-version: 2.1.1
affect-version: 2.1.0
fix-version: 3.0 Alpha 1
resolution: fixed
priority: major
component: engine
type: improvement
qa: done successfully
labels
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Submitted by: Denis Nosov (dens256)
Is duplicated by CORE3709
Votes: 1
Example:
create table test_a(id integer, cnt integer);
execute block
as
declare variable cnt integer;
begin
for select cnt from test_a
where id=1
into :cnt as cursor cur1
do begin
update test_a
set cnt=cnt+1
where current of cur1
returning cnt into :cnt;
end
end
Prepare error:
Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Token unknown - line 12, column 11.
returning.
Commits: 9564611
The text was updated successfully, but these errors were encountered: