[#CORE-1930] Possible AV in engine if procedure was altered to have no outputs and dependent procedures was not recompiled

Firebird Core

Possible AV in engine if procedure was altered to have no outputs and dependent procedures was not recompiled

Created: 10/Jun/08 06:03 AM Updated: 26/Jan/09 08:27 AM

Component/s:

Engine

Affects Version/s:

2.0.4, 2.1.0, 2.5 Initial, 2.0.3, 2.0.2, 2.0.1, 2.0.0, 2.1.1

Fix Version/s:

2.5 Alpha 1, 2.1.2, 2.0.5

Original Estimate:

Unknown

Remaining Estimate:

Unknown

Time Spent:

Unknown

Issue Links:

Relate

This issue is related to:
	QA-217 Test for CORE-1930

Resolution Date:	10/Jun/08
Planning Status:	Unspecified

All

Comments

Work Log

Change History

Version Control

Subversion Commits

Sort Order:

[ Permlink | « Hide ]

Vlad Khorsun - [10/Jun/08 06:07 AM ]

Test case :

create or alter procedure sp1 returns (x int)
as
begin
  suspend;
end

create or alter procedure sp2
as
declare x int;
begin
  select x from sp1 into :x;
end

create or alter procedure sp3
as
begin
  execute procedure sp2;
end

commit

-- this is wrong but engine still didn't track procedure's fields dependencies
create or alter procedure sp1
as
begin
  exit;
end

commit

-- disconnect and connect again

create or alter procedure sp3
as
begin
  execute procedure sp2;
end

commit

[ Permlink | « Hide ]

Vlad Khorsun - [10/Jun/08 06:10 AM ]

FB 2.1 on ODS 11.1 and higher raised error on commit :

Invalid token.
invalid request BLR at offset 32.
Procedure SP1 is not selectable (it does not contain a SUSPEND statement).

but on older ODS it crashes