- 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 viewreturns 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
- Red Hat JBoss Data Services 5.3.1
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.