Empty resultlist, query process definitions includes both tenant_id_ IN and tenant_id_ is null

Camunda 7 Topics Discussion & Questions
1

Hi all,

I’m trying to query process definitions from a tenant. The processDefinitionQuery looks as follows:

33
33739×758 35.6 KB

As you can see the tenantIds is a list of Strings with one element, ‘tenant-1’. However, the sql query that is executed is this:

select distinct
   RES.* 
from
   ACT_RE_PROCDEF RES 
   inner join
      (
         select
            KEY_,
            TENANT_ID_,
            max(VERSION_) as MAX_VERSION 
         from
            ACT_RE_PROCDEF 
         group by
            TENANT_ID_,
            KEY_
      )
      VER 
      on RES.KEY_ = VER.KEY_ 
WHERE
   RES.VERSION_ = VER.MAX_VERSION 
   and 
   (
      RES.TENANT_ID_ = VER.TENANT_ID_ 
      or 
      (
         RES.TENANT_ID_ is null 
         and VER.TENANT_ID_ is null
      )
   )
   and 
   (
      RES.SUSPENSION_STATE_ = ? 
   )
   and 
   (
      RES.TENANT_ID_ in 
      (
         ? 
      )
   )
   and 
   (
      RES.TENANT_ID_ is null 
   )
order by
   RES.ID_ asc LIMIT ? OFFSET ?

As you can see the RES.TENANT_ID_ is both used in a IN statement, AND in a is null statement, resulting in an empty result. I’m not sure how I can debug this any further. Hope someone can give me a hint!

Thanks in advance,
Thomas

2

Reply because I’m only allowed one image per post:

Batis file:
51

3

I guess this is solved, I didn’t see the separate “queryTenantCheck” which is including the “is null” part.