Using both the procedure name and alias inside an explicit plan crashes the server [CORE3064] #3443
Labels
affect-version: 1.5.4
affect-version: 1.5.5
affect-version: 1.5.6
affect-version: 2.0.0
affect-version: 2.0.1
affect-version: 2.0.2
affect-version: 2.0.3
affect-version: 2.0.4
affect-version: 2.0.5
affect-version: 2.0.6
affect-version: 2.1.0
affect-version: 2.1.1
affect-version: 2.1.2
affect-version: 2.1.3
affect-version: 2.5 Alpha 1
affect-version: 2.5 Beta 1
affect-version: 2.5 Beta 2
affect-version: 2.5 RC1
affect-version: 2.5 RC2
affect-version: 3.0 Initial
component: engine
fix-version: 2.0.7
fix-version: 2.1.4
fix-version: 2.5.1
fix-version: 3.0 Alpha 1
priority: major
qa: done successfully
type: bug
Submitted by: @livius2
Is related to QA255
example (but for all proc this happed)
SET TERM ^ ;
CREATE PROCEDURE GET_DATES (
ADATE_FROM Date,
ADATE_TO Date )
RETURNS (
OUT_DATE Date )
AS
DECLARE VARIABLE D DATE;
BEGIN
D = ADATE_FROM;
WHILE (D<=ADATE_TO) DO
BEGIN
out_DATE = D;
SUSPEND;
D = D + 1;
END
END^
SET TERM ; ^
now do select
SELECT p.OUT_DATE
FROM GET_DATES(CAST('2010-01-01' as date), CAST('2010-06-01' as date)) p
you get plan
PLAN (GET_DATES NATURAL)
but change this plan to this and do select
SELECT p.OUT_DATE
FROM GET_DATES(CAST('2010-01-01' as date), CAST('2010-06-01' as date)) p
PLAN (P GET_DATES NATURAL)
server crash
in windows log
" Abnormal Termination: "C:\Program Files\Firebird\Firebird_2_1\bin\fbserver.exe": terminated abnormally (4294967295)268435456 ü."
in fb log
"
WCOMP1 (Client) Fri Jul 02 11:18:16 2010
"C:\Program Files\Firebird\Firebird_2_1\bin\fbserver.exe": terminated abnormally (4294967295)"
Commits: 0da0b0c 7f9f768 8fa0fad fc70141
The text was updated successfully, but these errors were encountered: