Issue Details (XML | Word | Printable)

Key: CORE-3064
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: Karol Bieniaszewski
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Using both the procedure name and alias inside an explicit plan crashes the server

Created: 02/Jul/10 09:20 AM   Updated: 23/Feb/11 10:11 AM
Component/s: Engine
Affects Version/s: 2.0.0, 1.5.4, 2.0.1, 2.0.2, 2.0.3, 1.5.5, 2.1.0, 2.0.4, 2.5 Alpha 1, 2.1.1, 2.0.5, 2.1.2, 2.5 Beta 1, 2.5 Beta 2, 2.1.3, 1.5.6, 3.0 Initial, 2.5 RC1, 2.5 RC2, 2.0.6
Fix Version/s: 2.1.4, 2.5.1, 2.0.7, 3.0 Alpha 1

Time Tracking:
Not Specified

Environment: Windows XP
Issue Links:
Relate
 

Planning Status: Unspecified


 Description  « Hide
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)"

 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Dmitry Yemanov added a comment - 02/Jul/10 09:28 AM
The crash is surely a bug. The expected result is an error.