This content has been marked as final.
Show 2 replies
-
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
-
2. Re: Average always returns real value instead of integer
rakeshsagar Sep 1, 2011 4:55 AM (in response to shawkins)Thanks Steven.