[#10546] - Rewrite sql statement for sql server with more than 2100 items in list

Category:
Bug report
Priority:
Normal
Status:
Closed
Project: Severity:
Minor
Resolution:
Won't Fix
Component: Reproducibility:
Always
Assigned to:
0

A query with this statement

WHERE $X{IN, X, parameterList}

will fail on microsoft sql server when there are more than 2100 items in parameterList:

com.microsoft.sqlserver.jdbc.SQLServerException: The incoming request has too many parameters. The server supports a maximum of 2100
parameters. Reduce the number of parameters and resend the request.

I would like the query to be rewritten on the fly to

WHERE X in (first 2100 items of parameterList)
OR X in (second 2100 items of parameterList)
...
OR X in (rest items of parameterList)

v6.4
JasperFillManager
bertus.holscher's picture
Joined: Nov 16 2017 - 5:22am
Last seen: 2 weeks 4 days ago

1 Comment:

#1
  • Resolution:Open» Won't Fix
  • Status:New» Closed

HI,
besides the fact that this is not something JSS related, I'm not really sure it should be up to "us" to rewrite the original query after a "retrieve-and-count" of the original data.
You can try to open an enhancement request to the JR team and see what they say about it.

Regards,
Massimo.

Feedback