In rare situations when processing a query containing a very large number of constant entries in an IN operator, a stack overflow and a server crash were sometimes seen. The logic has been thoroughly analyzed and changes have been made to eliminate this issue.
New logic speeds up execution when the number of entries for the IN operator is large (>1000) by avoiding the use of the IN operator on indexes.