RE: INFORMIX 7.1 COUNT(*) QUESTION

Posted in 1995

CRAIG@CHEMISTRY.CHEM.UTAH.EDU — 1 Dec 1995 11:08:05 -0500 — source: Informix-list mailing list archive (1991-1998)

Connie, Check your release notes. Your observation is true beginning, I believe, in version 7.10. With the emphasis lately on database warehousing an integer count(*) is no longer big enough. I believe the release notes provide some tips though - I just don't have them handy right now. --Craig (craig@chemistry.utah.edu) >My project has just begun testing our application with INFORMIX 7.1 on Pyramid. >We are experiencing a problem with dynamically executed statements >of the form "SELECT COUNT(*) FROM tablename". It appears that the data type of >the returned count value has changed from INTEGER in INFORMIX 6 to DECIMAL >in INFORMIX 7.1. Has anyone else witnessed this change? We can find no documentation >that lists such a change. I have contacted INFORMXIX customer support but have >not yet had a response.