0

We have a framework that used In statement in several sections and also in core of it's code and developers did NOT know or forgot to keep in their mind this limitation, Now by adding offices in out program this ERROR appear in logs. I want to know that is possible to disable this limitation? or Increase it's value to for example 10000? I know this limitation in for performance but our priority in this case is running our query without error.

EDIT:I CAN'T EDIT QUERIES RIGHT NOW.

Sincerely

Mojtaba
  • 41
  • 1
  • 1
  • 8
  • Why don't you just load those 1000 values into a temporary table or CTE, and use that instead? – Tim Biegeleisen May 07 '18 at 06:31
  • I don't know if it's configurable. Probably not. The developers will probably need to change their code, for example by following the advice in these answers: https://stackoverflow.com/questions/4722220/sql-in-clause-1000-item-limit – Klas Lindbäck May 07 '18 at 06:33
  • The codes are in framework and developed by another company. – Mojtaba May 07 '18 at 06:33
  • @Klas Lindbäck I read it ago, I can't change queries right now. – Mojtaba May 07 '18 at 06:34
  • @Klas Lindbäck So if we have a program that it's source can't be change, we can't use it? – Mojtaba May 07 '18 at 06:38
  • 2
    *"is possible to disable this limitation?"* Nope, this limitation is [hard baked into the SQL engine](https://docs.oracle.com/database/121/SQLRF/expressions016.htm#SQLRF52099). I would guess it's related to the 1000 column limit for tables. So, this seems like a bug in the framework. Throw it back to the developers to fix. An `IN` clause with 1000 expressions is Teh Suck! anyway. – APC May 07 '18 at 07:48
  • @mojtabadddd If you (or rather, the owners of the data) can remove entries so there are under 1000 items, then it can be used for now. The long term solution is to fix the bug/limitation in the framework code. – Klas Lindbäck May 07 '18 at 09:03
  • @APC Thanks you, I'm wonder why developers did not mention this limitation when developing system. – Mojtaba May 07 '18 at 09:54
  • @Klas Lindbäck This is accessible offices of a user, so there is no way to reduce them. – Mojtaba May 07 '18 at 09:55

0 Answers0