Bug 36634

Informational

GemConnect

2.4, 2.3, 2.2.3, 2.2.2, 2.2, 2.1.1, 2.1, 2.0.1, 2.0

All

n/a

Specialized Integer queries return Floats

Under certain conditions, specialized Oracle SQL queries that are
expected to return Integers will instead return Floats.  Since the
data returned from Oracle is ambiguous, GemConnect cannot convert
these values.

For example, the query:

   'select count (*) from <tablename>'

   (returns number of rows in <tablename>)

will return a Float.

Workaround

Modify application code to expect a Float and handle it accordingly.


Last updated: 6/10/08