0 Replies Latest reply on Aug 31, 2011 9:51 AM by Rakesh Balguri

    Average always returns real value instead of integer

    Rakesh Balguri Expert

      Hi all,

       

      I had added the support for the Average for my custom translator and I am trying to execute the following SQL from the Database Perspective eclipse plugin. It always returns 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 but the translator returns the value as 1234.

       

      Teiid is some how converting the value to 1234.0

       

      Please help me in solving this.

       

      Thanks

      Rakesh