[GitHub] [shardingsphere] strongduanmu edited a comment on issue #12535: NPE in FederateEnumerator.class

[GitBox <gi...@apache.org>]

strongduanmu edited a comment on issue #12535:
URL: https://github.com/apache/shardingsphere/issues/12535#issuecomment-977673014


   init table:
   
   ```sql
   CREATE TABLE "act_re_procdef"
     "ID_" varchar(64) COLLATE utf8_bin NOT NULL,
     "REV_" int(11) DEFAULT NULL,
     "CATEGORY" varchar(255) COLLATE utf8_bin DEFAULT NULL,
     "NAME_" varchar(255) COLLATE utf8_bin DEFAULT NULL,
     "KEY_" varchar(255) COLLATE utf8_bin NOT NULL,
     "VERSION_" int(11) NOT NULL,
     "DEPLOYMENT_ID_" varchar(64) COLLATE utf8_bin DEFAULT NULL,
     "RESOURCE_NAME_" varchar(4000) COLLATE utf8_bin DEFAULT NULL,
     "DGRM_RESOURCE_NAME_" varchar(4000) COLLATE utf8_bin DEFAULT NULL,
     "DESCRIPTION_" varchar(4000) COLLATE utf8_bin DEFAULT NULL,
     "HAS_START_FORM_KEY_" tinyint(4) DEFAULT NULL,
     "HAS_GRAPHICAL_NOTATION_" tinyint(4) DEFAULT NULL,
     "SUSPENSION_STATE_" int(11) DEFAULT NULL,
     "TENANT_ID_" varchar(255) COLLATE utf8_bin DEFAULT '',
     PRIMARY KEY("ID_")
   )ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
   ```
   
   execute sql:
   
   ```sql
   select * from ACT_RE_PROCDEF
   where KEY_ = ? and TENANT_ID_ = ? and 
   VERSION_ = (select max(VERSION_) from ACT_RE_PROCDEF where KEY =? and TENANT_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.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org