DATABASE SERVER TERMINATED UNEXPECTEDLY (2)
Hi!
Has anyone been having this problem with INFORMIX 5.01.
Query1 is always crash the INFORMIX and I get the message
ERROR -457:DATABASE SERVER TERMINATED UNEXPECTEDLY.
I checked the tables indexes (tbcheck -cI <tbl.name>) and
tblspaces (tbcheck -cd <tbl.name>) and found that index and table
self was OK.
Query1:
SELECT A.Fld3,B.Fld2, A.Fld1, A.Fld4, A.Fld5, Sum(Fld8) ,
Sum(Fld9)
FROM AAA A, BBB B
WHERE A.Fld3=B.Fld1 AND Fld4 BETWEEN 1 AND 4
GROUP BY 1,2,3,4,5
ORDER BY 1,2,3,4,5;
If I modify query:
Query2:
SELECT A.Fld1, A.Fld2, B.Fld3, A.Fld4, A.Fld5, Sum(Fld8) ,
Sum(Fld9)
FROM AAA A, BBB B
WHERE A.Fld3=B.Fld1 AND Fld4 BETWEEN 1 AND 4
GROUP BY 1,2,3,4,5
ORDER BY 1,2,3,4,5;
then query works fine.
Here is table AAA And BBB structure:
Table AAA
(
Fld1 varchar(1) not null,
Fld2 varchar(3) not null,
Fld3 varchar(2) not null,
Fld4 integer not null,
Fld5 integer not null,
Fld6 varchar(3) not null,
Fld7 varchar(1),
Fld8 integer,
Fld9 float
);
Unique index i_AAA on AAA (Fld1,Fld2,Fld3,Fld4,Fld5,Fld6,Fld7);
Table BBB
(
Fld1 varchar(2) not null,
Fld2 varchar(20) not null
);
Unique index i_BBB on BBB (Fld1);
If you know an answer then please mail me!
Any help would be very appreciated.
--
Innar Vainre
Bank of Estonia
Expert
Phone: (372) 6 310 896
Fax: (372) 6 310 899
E-Mail: ivainre@epbe.ee