Path: utzoo!utgpu!water!watmath!clyde!att!osu-cis!tut.cis.ohio-state.edu!rutgers!apple!voder!pyramid!infmx!aland
From: aland@infmx.UUCP (Dr. Scump)
Newsgroups: comp.databases
Subject: Re: Informix 4gl bug
Summary: known problem
Message-ID: <405@infmx.UUCP>
Date: 3 Sep 88 01:21:31 GMT
References: <463@pan.UUCP>
Organization: Informix Software Inc., Menlo Park, CA.
Lines: 29

In article <463@pan.UUCP>, jw@pan.UUCP (Jamie Watson) writes:
| 
| Given the following trivial 4gl program,
| 
| [program which sends exactly 1 row to a report and sorts it]
| 
| The output produced, believe it or not, is this:
|      Before           1
|      Every           1
|      After           1
|      After           0
| 
| The problem does not appear in any of these cases:
| - Change the 'order by bar' to 'order external by bar'
| - Get rid of the 'order by bar' statement
| - Feed two values to the report.  It doesn't have to be two different values.
| jw

This is a known problem (Problem #1668, for reference).  It happens
only under these exact circumstances (report on a single row, sort
in the report rather than the select, using AFTER GROUP OF control
blocks).  Such an AFTER block executes twice in this case.
It is scheduled to be fixed in the next 4GL release.

-- 
 Alan S. Denney  |  Informix Software, Inc.  |  {pyramid|uunet}!infmx!aland
 Disclaimer: These opinions are mine alone.  If I am caught or killed,
             the secretary will disavow any knowledge of my actions.
 Santos' 4th Law: "Anything worth fighting for is worth fighting *dirty* for"