Re: Wierd 4GL Bug

Posted in 1992

Jonathan Leffler — Fri, 29 May 92 17:42:29 GMT — source: Informix-list mailing list archive (1991-1998)

>Message-Id: <9205271301.AA27545@rmy.rmy.emory.edu> >Date: Wed, 27 May 92 12:51:23 GMT >From: "Robert F. Kane" <uunet!worms-emh2.army.mil!bob> >Subject: Wierd 4GL Bug >X-Informix-List-Id: <list.1204> > >Ok folks, here is one for the 4GL wierd bug hall of fame. I have a report >that I am working that refuses to compile cleanly. The relevent code is >below: > > ... > >Notice that in the structure above, 'p3', 'p14', and 'p15' are not defined. >These are the 'DATETIME' variables. If I take out the 'ORDER BY' clause, >the thing compiles clean. I fixed the problem by defining the 'DATETIME' >variables as 'CHAR (8)', but still, this bothers me. Does this occur in >releases other than 4.0? Any comments would be appreciated. This: report r(s, t) define s datetime year to second, t integer order by s, t format every row end report compiled cleanly under compiled I4GL version 4.10.UC1 on a Sun. I take it from this that it is a 4.00 bug -- I knew about it and the best circumvention I'd come across was the CHAR(x) variables, as you found out. Yours, Jonathan Leffler (johnl@obelix.informix.com) #include <disclaimer.h>