topic Re: 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/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 jbarrez 2012-01-31T17:04:15Z 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