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

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.