DV source pushdown function runs separate source query

Solution Verified - Updated -

Issue

  • If source function is used multiple times in a single query that it's run multiple times on the datasource but should be once.

Environment

  • Red Hat JBoss Data Virtualization (DV) 6.3
  • Source pushdown function
  • User query:select test_pl.getname(id1) as test1, test_pl.getname(id2) as test2 , test_pl.getname(id3) as test3
  • Source queries:
select test_pl.getname(id1) 
select test_pl.getname(id2)
select test_pl.getname(id3

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