topic Minor bug in activiti.oracle.create.engine.sql in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/minor-bug-in-activiti-oracle-create-engine-sql/m-p/93485#M63980 <HTML><HEAD></HEAD><BODY><SPAN>It seems the last statement in activiti.oracle.create.engine.sql has a misprint:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />– see <A href="http://stackoverflow.com/questions/675398/how-can-i-constrain-multiple-columns-to-prevent-duplicates-but-ignore-null-value" rel="nofollow noopener noreferrer">http://stackoverflow.com/questions/675398/how-can-i-constrain-multiple-columns-to-prevent-duplicates-but-ignore-null-value</A><BR />create unique index ACT_UNIQ_RU_BUS_KEY on ACT_RU_EXECUTION<BR />&nbsp;&nbsp; (case when BUSINESS_KEY_ is null then null else PROC_DEF_ID_ end,<BR />&nbsp;&nbsp;&nbsp; case when BUSINESS_KEY_ is null then null else BUSINESS_KEY_ end);<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>the second BUSINESS_KEY_ should be replaced with PROC_DEF_ID_</SPAN></BODY></HTML> Tue, 31 Jan 2012 13:36:41 GMT grchld 2012-01-31T13:36:41Z Minor bug in activiti.oracle.create.engine.sql https://connect.hyland.com/t5/alfresco-archive/minor-bug-in-activiti-oracle-create-engine-sql/m-p/93485#M63980 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-valuecreate unique index ACT_UNIQ_RU_BUS_KEY on ACT_RU_EXECUTION&nbsp;&nbsp; (case when BUSINESS_KEY_ is nu Tue, 31 Jan 2012 13:36:41 GMT https://connect.hyland.com/t5/alfresco-archive/minor-bug-in-activiti-oracle-create-engine-sql/m-p/93485#M63980 grchld 2012-01-31T13:36:41Z Re: Minor bug in activiti.oracle.create.engine.sql https://connect.hyland.com/t5/alfresco-archive/minor-bug-in-activiti-oracle-create-engine-sql/m-p/93486#M63981 <HTML><HEAD></HEAD><BODY><SPAN>The sql looks indeed funny, but I believe it does what it must do: the two parameters both depend on the business key</SPAN></BODY></HTML> Tue, 31 Jan 2012 17:04:15 GMT https://connect.hyland.com/t5/alfresco-archive/minor-bug-in-activiti-oracle-create-engine-sql/m-p/93486#M63981 jbarrez 2012-01-31T17:04:15Z