Divide by zero error doesn't raise

I am connecting to informix via ODBC 2.90, the database is version 9.40. I execute this query, for example: SELECT ap_maximo/ap_minimo FROM jam_agrupapesos The table has 8 records, in one of then ap_Minimo = 0; the query just doesn't return any record, but it doesn't fail. This seems to me to be a bug, a REALLY BIG one, it's making me really scared. I tested it too with oledb and the same 'Any ideas? -- agustincb ------------------------------------------------------------------------ agustincb's Profile: http://www.dbtalk.net/m129 View this thread: http://www.dbtalk.net/t298528

What is the data defined as in table ? How is it populated initially ? Does it fail in dbaccess ? Cheers Paul Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 GO FURTHER with DB2 GET THERE FASTER with Informix. Attend the IDUG 2006 North America Conference. Tampa, Florida, USA. 7-11 May 2006. Visit http://www.iiug.org/conf for more information. > -----Original Message----- > From: agustincb > [mailto:agustincb.261ml0@no-mx.forums.yourdomain.com.au] > Posted At: Monday, April 10, 2006 4:47 AM > Posted To: comp.databases.informix > Conversation: Divide by zero error doesn't raise > Subject: Divide by zero error doesn't raise > > > > I am connecting to informix via ODBC 2.90, the database is version > 9.40. > > I execute this query, for example: > > SELECT ap_maximo/ap_minimo FROM jam_agrupapesos > > The table has 8 records, in one of then ap_Minimo = 0; the query just > doesn't return any record, but it doesn't fail. > > This seems to me to be a bug, a REALLY BIG one, it's making me really > scared. > > I tested it too with oledb and the same > > 'Any ideas? > > > -- > agustincb > -------------------------------------------------------------- > ---------- > agustincb's Profile: http://www.dbtalk.net/m129 > View this thread: http://www.dbtalk.net/t298528 >

if you believe it is a really big bug then I suggest you contact your support provider and provide them with the details