Issue using the "WITH <table> AS" clause in EDS causes a change in count(*) results.

Solution Verified - Updated -

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 of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In