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, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content