VARIABLES.ROWCOUNT returns incorrect value in the DV Virtual Procedure

Solution Verified - Updated -

Issue

  • VARIABLES.ROWCOUNT returns incorrect value in the Virtual Procedure.
  • VARIABLES.ROWCOUNT returns unexpected values.
    • In case when there is no row returned (processed) it gives 0 (ZERO)
    • In case when there is 1 row returned (processed) it gives 1 (ONE)
    • In case when the count of rows is greater than 1 - it return MINUS count of rows and also returned value is doubled (e.g. if actual number of records fetched is 491, this variable returns value as 982)

Environment

  • Red Hat JBoss Data Virtualization (DV) 6.1
  • use of the VARIABLES.ROWCOUNT in a virtual procedure

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