Different behavior for creating duplicate of report groups

[DartVerder]

Environment: CUBA Platform version: 7.2.13 Databases: HSQL, Postgres, MySQL, MSSQL, Oracle

Description of the bug

1. Create new project and add report add-on
2. Run application
3. Create new report group with title = "reports"
4. Create new report group with the same title = "reports"

Expected behavior: The title of the report group must be unique. The application behavior must be the same for different types of databases. Actual behavior:

• HSQL: User can create groups with different titles. No errors, messages
• MySQL, Oracle, MSSQL: a clear error message appears
• Postgres Unexpected error window appears

  com.haulmont.cuba.core.global.RemoteException:
  ---
  javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.3.14-cuba): org.eclipse.persistence.exceptions.DatabaseException
  Internal Exception: org.postgresql.util.PSQLException: ОШИБКА: повторяющееся значение ключа нарушает ограничение уникальности "idx_report_group_uniq_title"
  Подробности: Ключ "(title)=(rep)" уже существует.
  Error Code: 0
  Call: INSERT INTO REPORT_GROUP (ID, CODE, CREATE_TS, CREATED_BY, DELETE_TS, DELETED_BY, LOCALE_NAMES, SYS_TENANT_ID, TITLE, UPDATE_TS, UPDATED_BY, VERSION) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  bind => [c454c578-f81c-8a75-eb30-f22dee6d760a, null, 2021-03-30 16:02:41.053, admin, null, null, null, null, rep, 2021-03-30 16:02:41.053, null, 1]
  Query: InsertObjectQuery(com.haulmont.reports.entity.ReportGroup-c454c578-f81c-8a75-eb30-f22dee6d760a [new,managed])
  ---
  org.eclipse.persistence.exceptions.DatabaseException: 
  Internal Exception: org.postgresql.util.PSQLException: ОШИБКА: повторяющееся значение ключа нарушает ограничение уникальности "idx_report_group_uniq_title"
  Подробности: Ключ "(title)=(rep)" уже существует.
  Error Code: 0
  Call: INSERT INTO REPORT_GROUP (ID, CODE, CREATE_TS, CREATED_BY, DELETE_TS, DELETED_BY, LOCALE_NAMES, SYS_TENANT_ID, TITLE, UPDATE_TS, UPDATED_BY, VERSION) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  bind => [c454c578-f81c-8a75-eb30-f22dee6d760a, null, 2021-03-30 16:02:41.053, admin, null, null, null, null, rep, 2021-03-30 16:02:41.053, null, 1]
  Query: InsertObjectQuery(com.haulmont.reports.entity.ReportGroup-c454c578-f81c-8a75-eb30-f22dee6d760a [new])
  ---
  org.postgresql.util.PSQLException: ОШИБКА: повторяющееся значение ключа нарушает ограничение уникальности "idx_report_group_uniq_title"
  Подробности: Ключ "(title)=(rep)" уже существует.
  at com.haulmont.cuba.core.sys.ServiceInterceptor.aroundInvoke(ServiceInterceptor.java:96)
  at sun.reflect.GeneratedMethodAccessor124.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:498)
  at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644)
  at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633)
  at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175)
  at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:95)
  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
  at com.sun.proxy.$Proxy222.commit(Unknown Source)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:498)
  at com.haulmont.cuba.core.sys.remoting.LocalServiceInvokerImpl.invoke(LocalServiceInvokerImpl.java:94)
  at com.haulmont.cuba.web.sys.remoting.LocalServiceProxy$LocalServiceInvocationHandler.invoke(LocalServiceProxy.java:159)
  at com.sun.proxy.$Proxy34.commit(Unknown Source)
  at com.haulmont.cuba.client.sys.DataManagerClientImpl.commit(DataManagerClientImpl.java:100)
  at com.haulmont.cuba.gui.data.impl.GenericDataSupplier.commit(GenericDataSupplier.java:105)
  at com.haulmont.cuba.gui.data.impl.DsContextImpl.commit(DsContextImpl.java:140)
  at com.haulmont.cuba.gui.components.AbstractEditor.commitInternal(AbstractEditor.java:383)
  at com.haulmont.cuba.gui.components.AbstractEditor.closeWithCommit(AbstractEditor.java:430)
  at com.haulmont.cuba.gui.components.AbstractEditor.commitAndClose(AbstractEditor.java:446)
  at com.haulmont.cuba.gui.components.AbstractEditor.lambda$initCommitActions$1(AbstractEditor.java:104)
  at com.haulmont.bali.events.EventHub.publish(EventHub.java:170)
  at com.haulmont.cuba.gui.components.actions.BaseAction.actionPerform(BaseAction.java:222)
  at com.haulmont.cuba.web.gui.components.WebButton.buttonClicked(WebButton.java:67)
  at com.haulmont.cuba.web.widgets.CubaButton.fireClick(CubaButton.java:76)
  at com.vaadin.ui.Button$1.click(Button.java:57)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:498)
  at com.vaadin.server.ServerRpcManager.applyInvocation(ServerRpcManager.java:153)
  at com.vaadin.server.ServerRpcManager.applyInvocation(ServerRpcManager.java:115)
  at com.vaadin.server.communication.ServerRpcHandler.handleInvocation(ServerRpcHandler.java:431)
  at com.vaadin.server.communication.ServerRpcHandler.handleInvocations(ServerRpcHandler.java:396)
  at com.vaadin.server.communication.ServerRpcHandler.handleRpc(ServerRpcHandler.java:260)
  at com.vaadin.server.communication.UidlRequestHandler.synchronizedHandleRequest(UidlRequestHandler.java:82)
  at com.vaadin.server.SynchronizedRequestHandler.handleRequest(SynchronizedRequestHandler.java:40)
  at com.vaadin.server.VaadinService.handleRequest(VaadinService.java:1578)
  at com.vaadin.server.VaadinServlet.service(VaadinServlet.java:425)
  at com.haulmont.cuba.web.sys.CubaApplicationServlet.serviceAppRequest(CubaApplicationServlet.java:329)
  at com.haulmont.cuba.web.sys.CubaApplicationServlet.service(CubaApplicationServlet.java:215)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  at org.springframework.web.filter.CompositeFilter$VirtualFilterChain.doFilter(CompositeFilter.java:108)
  at org.springframework.web.filter.CompositeFilter.doFilter(CompositeFilter.java:74)
  at com.haulmont.cuba.web.sys.CubaHttpFilter.doFilter(CubaHttpFilter.java:93)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
  at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
  at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690)
  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
  at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:374)
  at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
  at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
  at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1590)
  at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  at java.lang.Thread.run(Thread.java:748)

[knstvk]

We don't create unique indexes for SoftDelete entities in HSQL, because it's too difficult (requires an additional column and a trigger) and we treat HSQL as prototyping-only database.