Average always returns real value instead of integer

rakeshsagar Aug 31, 2011 9:58 AM

Hi all,

I had added the average support in my translator. When I execute the following SQL against teiid using the database explorer eclipse plugin I always get a real number instead of an integer.

SELECT AVG(DISTINCT SPACE) FROM DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase

I always get the result as 1234.0 instead of 1234.

The translator always returns the value as 1234 in the result set.

Please let me know if I am doing anything wrong.

Thanks

Rakesh

1. Re: Average always returns real value instead of integer

shawkins Aug 31, 2011 10:21 AM (in response to rakeshsagar)

Rakesh,

Teiid uses the real/double type for the result of avg on an integral type. However you may not be expecting this as it goes against the SQL spec. My guess would be that it was done this way to avoid using a result type of decimal/bigdecimal. I'll log an issue about this descrepancy. The workaround would be to use a cast to the desired type.

Steve
Actions
2. Re: Average always returns real value instead of integer

rakeshsagar Sep 1, 2011 4:55 AM (in response to shawkins)

Thanks Steven.
Actions

Go to original post