[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
To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information