bugfix - plpgsql - statement counter is incremented 2x for FOR stmt

Started by Pavel Stehuleabout 5 years ago3 messageshackers
Jump to latest
#1Pavel Stehule
pavel.stehule@gmail.com

Hi

When I fixed one plpgsql_check issue, I found another plpgsql issue. Now we
have field nstatements that hold a number of plpgsql statements in
function. Unfortunately I made an error when I wrote this functionality and
for FOR statements, this counter is incremented 2x. Higher number than a
real number is better than a lesser number, but it can be a source of
problems too (inside plpgsql_check I iterate over 0 .. nstatements stmtid,
and due this bug I had a problem with missing statements).

Attached patch is pretty simple:

Regards

Pavel

Attachments:

plpgsql-double-increment-stmtid-fix.patchtext/x-patch; charset=US-ASCII; name=plpgsql-double-increment-stmtid-fix.patchDownload+0-2
#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Pavel Stehule (#1)
Re: bugfix - plpgsql - statement counter is incremented 2x for FOR stmt

Pavel Stehule <pavel.stehule@gmail.com> writes:

When I fixed one plpgsql_check issue, I found another plpgsql issue. Now we
have field nstatements that hold a number of plpgsql statements in
function. Unfortunately I made an error when I wrote this functionality and
for FOR statements, this counter is incremented 2x. Higher number than a
real number is better than a lesser number, but it can be a source of
problems too (inside plpgsql_check I iterate over 0 .. nstatements stmtid,
and due this bug I had a problem with missing statements).

Attached patch is pretty simple:

Right, done.

regards, tom lane

#3Pavel Stehule
pavel.stehule@gmail.com
In reply to: Tom Lane (#2)
Re: bugfix - plpgsql - statement counter is incremented 2x for FOR stmt

út 2. 2. 2021 v 20:36 odesílatel Tom Lane <tgl@sss.pgh.pa.us> napsal:

Pavel Stehule <pavel.stehule@gmail.com> writes:

When I fixed one plpgsql_check issue, I found another plpgsql issue. Now

we

have field nstatements that hold a number of plpgsql statements in
function. Unfortunately I made an error when I wrote this functionality

and

for FOR statements, this counter is incremented 2x. Higher number than a
real number is better than a lesser number, but it can be a source of
problems too (inside plpgsql_check I iterate over 0 .. nstatements

stmtid,

and due this bug I had a problem with missing statements).

Attached patch is pretty simple:

Right, done.

Thank you for commit

Regards

Pavel

Show quoted text

regards, tom lane