Re: I-STAR spawns child problem
Mike Johnson (mikehunt@algonet.se) wrote:
> Ken Miles (kenm@vcd.hp.com) wrote:
> : LUZURIAGAM@law.stmarytx.edu wrote:
> : > We're using I-NET 5.01 for Windows and Online
> : > Verion 5.02UC6, with the latest vesrion of I-STAR.
> : ^^^^^^^ I don't know if the same symptoms occurred for us on
> : this version as we were up on it for only a few short painful hours.
> : Beware of this release, it has far more serious problems than ISTAR hangs.
> Like what problems Ken? We are using just that release here and as we are
> about to take the system into production it would be nice to know what
> we might be getting ourselves into.
> Mike.
The "group by" clause of the select statement is broken. It's bug #31126.
Informix never told us whether it was specific to the HP environment but
at one point there was an indication that it was.
Below is some SQL you can use to confirm whether your release has the
problem. The 5.03 UC1 version, while not perfect is MUCH better.
Ken Miles
kenm@vcd.hp.com
-----------------------------------------------------------------
{SQL to duplicate bug #31126 in 5.02 UC6 on the stores database.
These selects should return the same rows but they do not.
}
database stores;
select distinct
customer.customer_num cus_num,
orders.customer_num ord_cus_num,
orders.order_num
from
customer,orders
where
customer.customer_num = orders.customer_num and
customer.customer_num < 110
order by
orders.customer_num;
{ Now repeat the above with a group by clause added: }
select distinct
customer.customer_num cus_num,
orders.customer_num ord_cus_num,
orders.order_num
from
customer,orders
where
customer.customer_num = orders.customer_num and
customer.customer_num < 110
group by
customer.customer_num, orders.customer_num, orders.order_num
order by
orders.customer_num;