Bug 36634

Bug: 36634

Impact:

Informational

Product:

GemConnect

Versions:

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

Platform:

All

Fixed In:

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.