4 Replies Latest reply on Feb 18, 2013 7:59 PM by Rajasekhar Kota

    Continuous queries with Group by clause returns incorrect results when it points to Tables

    Madhu Garimilla Newbie

      Hi,

       

      I am using  teiid 8.1 with Dynamic vdbs approach. I am trying to retreive the grouping counts using continuous queries. This is returning incorrect results when query is referencing tables. Count is always returned as 1 though there are more than 1 record in the table matching this criteria. I have prepared a sample test case using h2 tables depicting the scenario and here is the query which returns count as 1 for all the matching items. Here

       

      SELECT CHORUS_B.NAME, COUNT(CHORUS_B.NAME) AS CHORUS_GROUPING_COUNT

      FROM (SELECT CHORUS_B.* FROM (SELECT * FROM TEST) AS CHORUS_B,

      (CALL chorus_time.timetable(10000)) AS chorus_refresh_expression) AS CHORUS_B GROUP BY CHORUS_B.NAME

       

      Here chorus_time is a translator and timetable is a stored procedure and TEST is a h2 table. Could you please check what is going wrong here.