DV Query Plan differs between sql and prepared statement queries
Issue
- Query plan is different for the same query in sql vs prepared Statement.
Environment
- Red Hat JBoss Data Virtualization (DV) 6.4
- Prepared Statement with criteria as parameters:
sql = "select * from " +
"Inventory_Detail" +
" WHERE SEARCH = and ITEM_ID in OFFSET 0 ROWS FETCH NEXT 500 ROWS ONLY";
PreparedStatement preparedStatement = conn.prepareStatement(sql);
preparedStatement.setString(1,"FALSE");
preparedStatement.setString(2,"1005014161091");
ResultSet rs = null;
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.