[#CORE-4356] Asynchronous cancellation request can be ignored in the case of EXECUTE STATEMENT and WHEN used together

Firebird Core

Asynchronous cancellation request can be ignored in the case of EXECUTE STATEMENT and WHEN used together

Created: 03/Mar/14 09:27 AM Updated: 03/Mar/14 09:45 AM

Component/s:

Engine

Affects Version/s:

2.1.0, 2.1.1, 2.1.2, 2.1.3, 2.5.0, 2.1.4, 2.5.1, 2.1.5, 2.5.2, 2.1.5 Update 1, 2.5.2 Update 1, 3.0 Alpha 1, 3.0 Alpha 2

Fix Version/s:

None

Description

« Hide

Artificial test case:

set term ^;

execute block as
  declare stt varchar(255) = 'execute block as begin while (1 = 1) do begin end end';
begin
  while(1=1) do
    begin
      execute statement stt;
      when any do begin end
    end
end^

set term ;^
commit;

Then either press Ctrl-C in the current ISQL session or issue "delete from mon$statements where mon$attachment_id <> current_connection" from a different ISQL session.

The endless loop inside EXECUTE STATEMENT really gets interrupted but isc_cancelled error gets handled by the WHEN block and the outer loop continues. This is a bug, cancellation/shutdown errors should not be processed by exception handlers.

All

Comments

Change History

Subversion Commits

Sort Order:

Dmitry Yemanov made changes - 03/Mar/14 09:28 AM

Field	Original Value	New Value
Assignee		Dmitry Yemanov [ dimitr ]
Reporter	Dmitry Yemanov [ dimitr ]	Pavel Zotov [ tabloid ]

Dmitry Yemanov made changes - 03/Mar/14 09:28 AM

Affects Version/s		3.0 Alpha 2 [ 10560 ]
Affects Version/s		3.0 Alpha 1 [ 10331 ]
Affects Version/s		2.5.2 Update 1 [ 10521 ]
Affects Version/s		2.1.5 Update 1 [ 10522 ]
Affects Version/s		2.5.2 [ 10450 ]
Affects Version/s		2.1.5 [ 10420 ]
Affects Version/s		2.5.1 [ 10333 ]

Dmitry Yemanov made changes - 03/Mar/14 09:28 AM

Status

Open [ 1 ]

In Progress [ 3 ]

Dmitry Yemanov made changes - 03/Mar/14 09:45 AM

Description

Artificial test case:

set term ^;

execute block as
  declare stt varchar(255) = 'execute block as begin while (1 = 1) do begin end end';
begin
  while(1=1) do
    begin
      execute statement stt;
      when any do begin end
    end
end^

set term ;^
commit;

Then either press Ctrl-C in the current ISQL session or issue "delete from mon$statements where mon$attachment_id <> current_connection" from a different ISQL session.

The endless loop inside EXECUTE STATEMENT really gets interrupted but isc_cancelled error gets handled by the WHEN block and the loop continues. This is a bug, cancellation/shutdown errors should not be processed by exception handlers.