DV "WITH table.." query returns NullPointerException

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