phoema commented on issue #4810: Abount Exception [Can not find owner from 
table.]
URL: 
https://github.com/apache/incubator-shardingsphere/issues/4810#issuecomment-600554584
 
 
   SQL parse throws NullPointerException
   may be it can be a test case.
   
   SELECT
           RES.*,
           ( 
     case
          when
         RES.TASK_ID_ is not null
         and RES.EXECUTION_ID_ is not null
          then EXECUTION.ACT_INST_ID_
   
       when
         RES.CASE_EXECUTION_ID_ is not null
       then RES.CASE_EXECUTION_ID_
   
       
          when
            EXECUTION.PARENT_ID_ is null
         and RES.IS_CONCURRENT_LOCAL_ = 0
          then EXECUTION.ID_
   
       
          when
            EXECUTION.IS_SCOPE_ = 1
            and EXECUTION.PARENT_ID_ is not null
         and RES.IS_CONCURRENT_LOCAL_ = 0
          then PARENT_EXECUTION.ACT_INST_ID_
   
          else EXECUTION.ACT_INST_ID_
        end
      ) ACT_INST_ID_
       FROM
           ACT_RU_VARIABLE RES
   
       LEFT JOIN
           ACT_RU_EXECUTION EXECUTION
       ON
           RES.EXECUTION_ID_ = EXECUTION.ID_
   
       LEFT JOIN
           ACT_RU_EXECUTION PARENT_EXECUTION
       ON
           EXECUTION.PARENT_ID_ = PARENT_EXECUTION.ID_
   
       WHERE
           TASK_ID_ = ?

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
[email protected]


With regards,
Apache Git Services

Reply via email to