Log-A-Bug Report on Select That Crashes 9.0.x Server

forum.gupta.bugreport (2005-2010)
Clifford Bass

Log-A-Bug Report on Select That Crashes 9.0.x Server

Post by Clifford Bass » 30 Jun 2005, 22:40

 Posted by:  Clifford W. Bass 

Hello All,

Here is a Log-A-Bug report on a problem I encountered in 9.0.x in case
it helps someone else to know about it.

Log-A-Bug has reviewed the issue listed below and determined that this is a
defect. The defect number is 83490.

Product=SQLBase
Version=9.0
PTF=none
O/S=Windows NT version 4O
ccurs=Run Time
Details=Also occurs with 9.0.1 on Windows 2000. Stored version of a select
command crashes the server.

Here is the dataless version of what I submitted to Gupta.

create table Applicants (
Application_Year smallint not null,
ID decimal(10, 0) not null,
VMCAS_ID decimal(10, 0) not null);
insert into Applicants values (2005, :1, :2)
\
[data deleted]
/
create unique index A__Primary on Applicants (Application_Year, ID);
create unique index A_AY_VI on Applicants (Application_Year, VMCAS_ID);
commit;

create table Decision_Meanings (
Application_Year smallint not null,
Decision_Code smallint not null,
VMCAS_Action_Code char(1));
insert into Decision_Meanings values (2005, :1, :2)
\
[data deleted]
/
create unique index DM__Primary on Decision_Meanings (Application_Year,
Decision_Code);
commit;

create table Apl_Decisions (
Application_Year smallint not null,
ID decimal(10, 0) not null,
Decision_Code smallint not null,
Decision_Date datetime not null);
insert into Apl_Decisions values (2005, :1, :2, :3)
\
[data deleted]
/
create unique index AD__Primary on Apl_Decisions (Application_Year, ID,
Decision_Date desc, Decision_Code);
commit;

update statistics on database;
commit;

REMARK
\
This statement executes fine. When prompted for bind data enter 2005.
/
select distinct VMCAS_ID, VMCAS_Action_Code, Decision_Date =
@datetochar(Decision_Date, 'mm/dd/yyyy')
from Apl_Decisions T1, Applicants T2, Decision_Meanings T3
where T1.Application_Year = :1 and T2.Application_Year =
T1.Application_Year and T2.ID = T1.ID and T3.Application_Year =
T1.Application_Year and T3.Decision_Code = T1.Decision_Code and VMCAS_ID
and not exists (select *
from Apl_Decisions T4, Decision_Meanings T5
where T4.Application_Year = T1.Application_Year and T4.ID = T1.ID and
T5.Application_Year = T4.Application_Year and T5.Decision_Code
= T4.Decision_Code and T4.Decision_Date > T1.Decision_Date and
T5.VMCAS_Action_Code is not null)
order by VMCAS_ID, Decision_Date, VMCAS_Action_Code;

REMARK
\
The exact same statement as a stored command.
/
store SysAdm.GetVMCASActsAplYrA
select distinct VMCAS_ID, VMCAS_Action_Code, Decision_Date =
@datetochar(Decision_Date, 'mm/dd/yyyy')
from Apl_Decisions T1, Applicants T2, Decision_Meanings T3
where T1.Application_Year = :1 and T2.Application_Year =
T1.Application_Year and T2.ID = T1.ID and T3.Application_Year =
T1.Application_Year and T3.Decision_Code = T1.Decision_Code and VMCAS_ID
and not exists (select *
from Apl_Decisions T4, Decision_Meanings T5
where T4.Application_Year = T1.Application_Year and T4.ID = T1.ID and
T5.Application_Year = T4.Application_Year and T5.Decision_Code
= T4.Decision_Code and T4.Decision_Date > T1.Decision_Date and
T5.VMCAS_Action_Code is not null)
order by VMCAS_ID, Decision_Date, VMCAS_Action_Code;
commit;

REMARK
\
Executing the stored comment causes the database server to fail. Again,
enter 2005 for the bind data.
/
execute SysAdm.GetVMCASActsAplYrA;

Clifford Bass

Return to “gupta.bugreport”

Who is online

Users browsing this forum: [Ccbot] and 0 guests