AnsweredAssumed Answered

Minor bug in activiti.oracle.create.engine.sql

Question asked by grchld on Jan 31, 2012
Latest reply on Jan 31, 2012 by jbarrez
It seems the last statement in activiti.oracle.create.engine.sql has a misprint:


– see http://stackoverflow.com/questions/675398/how-can-i-constrain-multiple-columns-to-prevent-duplicates-but-ignore-null-value
create unique index ACT_UNIQ_RU_BUS_KEY on ACT_RU_EXECUTION
   (case when BUSINESS_KEY_ is null then null else PROC_DEF_ID_ end,
    case when BUSINESS_KEY_ is null then null else BUSINESS_KEY_ end);

the second BUSINESS_KEY_ should be replaced with PROC_DEF_ID_

Outcomes