Re: DATABASE SERVER TERMINATED UNEXPECTEDLY

I think your answer lies in the use of varchars with indexes. I attended an Informix training class and I inquired about problems with indexed varchar columns. The instructor said that this version of Informix had problems with indexed varchars. Innar Vainre wrote: > > 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 > E-Mail: ivainre@epbe.ee -- Jay Engel AG Communication Systems, Phoenix, Arizona G10 Internet: engelj@agcs.com Phone: (602) 582-7324