Enterprise Data Services and DataVirtualization return different resultsets given the same user query

Solution In Progress - Updated -

Environment

  • Red Hat JBoss Data Virtualization 6
  • Enterprise Data Services 5

Issue

  • EDS and DV unexpectedly return different results

Resolution

TRACE logging for EDS and JDV needs to be obtained for comparison. Specifically around the query plan and the resulting source queries.

Comparison of TRACE logging will determine next steps for resolution.

Diagnostic Steps

find the source commands in each log
$ grep 'START DATA SRC COMMAND' .log | sed -e 's/.sql=//' > 531-src.log
$ grep 'START DATA SRC COMMAND' .log | sed -e 's/.
sql=//' > 62-src.log

compare
$ git diff 531-src.log 62-src.log

walk back to find where deviation is occurring

This solution is part of Red Hat’s fast-track publication program, providing a huge library of solutions that Red Hat engineers have created while supporting our customers. To give you the knowledge you need the instant it becomes available, these articles may be presented in a raw and unedited form.