Re: Changes from 5.01 to 5.02? MAJOR BUG !!!!! on HP

> > Folks, > > We recently changed from OnLine 5.01.UD(3?) to 5.02.UC6 and one of my > sites has a report of different behavior in handling an SQL statement. > This statement returned multiple rows under 5.01 and only one row in 5.02UC6: > > > SELECT shift_number, > op_name, > oper_number, > count(*), > sum(total_items), > job_number, > xpt_number, > sum(xpt_oper.end_date - xpt_oper.start_date) > FROM xpt_oper, > operator > where oper_number = op_id > group by shift_number, > oper_number, > op_name, > xpt_number, > job_number > ORDER BY oper_number, > xpt_number, > job_number> > My developer said that the query worked as befor when he changed it (under > 5.02.UC6) to: > > > > SELECT shift_number, > op_name, > oper_number, > count(*), > sum(total_items), > job_number, > xpt_number, > sum(xpt_oper.end_date - xpt_oper.start_date) > FROM xpt_oper, > operator > where oper_number = op_id > group by oper_number > ORDER BY oper_number, > xpt_number, > job_number> > The only difference is in the group by. Does anyone have any possible > ideas why this should be different? (I'm investigating now the obvious... > that something **else** has changed....you know developers :) ) Are you on an HP machine? I know I received a MAJOR bug report regarding the exact sql you show above. group by has major problems in 5.02 UC6 Dont use this version. Informix begged us to upgrade to 5.03 UC1. get off of 5.02 UC6 lots of problems including index corruption memory leaks etc. Rob. 214-718-2444 -------