Issue

• Given the view

with tab1 as (select table1.table2_id AS table2_id, table1.id AS table1_id
from table1)
select tab1.table2_id, tab1.table1_id
from tab1,table2
Where
tab1.table2_id = table2.id

• select count(*) from view returns a different number of records than indicated by

select (*) from
from table1,table2
Where
table1.table2_id = table2.id

• actual number of records is over 100,000 but count(*) on the view returns 8192
• Is there a limit on the temporary table created in runtime when using the WITH clause?
• tested this on three different instances of EDS with the same data sources and received different results