# 1088 SQL AVG Function Returning Incorrect Results for Non-Float Fields

---

Create a table "testTable" with a single field "testInt" of type integer.

Populate it with two records:

testInt
100
50


Then run the following SQL:

select avg(testInt)
from testTable

The result should be 75. Instead, the query returns 0.