Issue using the "WITH <table> AS" clause in EDS causes a change in count(*) results.
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
Environment
- Red Hat JBoss Data Services 5.3.1
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.