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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
