DV "WITH table.." query returns NullPointerException

Solution In Progress - Updated -

Issue

  • Running the below "WITH" query errors with a NullPointerException:
with tmp as (SELECT material_id as dd 
             FROM "ME"."MATERIAL" 
             WHERE material_id = 'ff')
SELECT material_id 
FROM "ME"."BATCH",tmp
WHERE material_id = (SELECT material_id 
                     FROM "ME"."MATERIAL",tmp 
                     WHERE material_id = '1' 
                     and material_id > tmp.dd 
                     order by material_id asc 
                     limit 1)
limit 1

Environment

  • Red Hat JBoss Data Virtualization (DV) 6.2.6

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

New to Red Hat?

Learn more about Red Hat subscriptions

Close

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