[Performance | Postgres] >65,535 parameters when searching by linked requirement
Squash 6.1.1.0.Release
Unable to search from an execution plan with the "Search by linked requirements" option.
ERROR [http-nio-8080-exec-9] [] --- org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/squash].[dispatcherServlet]: Servlet.service() for servlet [dispatcherServlet] in context with path [/squash] threw exception [Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException: could not prepare statement; SQL [select distinct testcase0_.TCLN_ID as col_0_0_ from TEST_CASE testcase0_ inner join TEST_CASE_STEPS steps1_ on testcase0_.TCLN_ID=steps1_.TEST_CASE_ID inner join TEST_STEP teststep2_ on steps1_.STEP_ID=teststep2_.TEST_STEP_ID left outer join KEYWORD_TEST_STEP teststep2_1_ on teststep2_.TEST_STEP_ID=teststep2_1_.TEST_STEP_ID left outer join ACTION_TEST_STEP teststep2_2_ on teststep2_.TEST_STEP_ID=teststep2_2_.TEST_STEP_ID left outer join CALL_TEST_STEP teststep2_3_ on teststep2_.TEST_STEP_ID=teststep2_3_.TEST_STEP_ID left outer join TEST_CASE_STEPS teststep2_4_ on teststep2_.TEST_STEP_ID=teststep2_4_.STEP_ID inner join TEST_CASE testcase3_ on teststep2_3_.CALLED_TEST_CASE_ID=testcase3_.TCLN_ID where (testcase3_.TCLN_ID in (? , ? , ? , ? , ?[.....])) and case when teststep2_1_.TEST_STEP_ID is not null then 1 when teststep2_2_.TEST_STEP_ID is not null then 2 when teststep2_3_.TEST_STEP_ID is not null then 3 when teststep2_.TEST_STEP_ID is not null then 0 end=3]; nested exception is org.hibernate.exception.DataException: could not prepare statement] with root cause
org.postgresql.util.PSQLException: PreparedStatement can have at most 65,535 parameters. Please consider using arrays, or splitting the query in several ones, or using COPY. Given query has 167,018 parameters
Edited by VIGNON Séverine