Ramachandran created RANGER-3929:
------------------------------------
Summary: To support batching in SQL IN clause of SQL queries used
in Ranger
Key: RANGER-3929
URL: https://issues.apache.org/jira/browse/RANGER-3929
Project: Ranger
Issue Type: Improvement
Components: admin
Affects Versions: 3.0.0
Reporter: Ramachandran
Assignee: Ramachandran
As of now, we are not handling the max values that will be passed into the IN
clause SQL queries
Most of the databases which support maximum of 1000 values in the IN clause
{code:java}
getEntityManager()
.createNamedQuery("XXPolicyRefUser.deleteByIds", tClass)
.setParameter("ids", ids).executeUpdate();
{code}
We will get the issue when the size grows more than 1000 otherwise we will not
face any issue.
We need to fix this to avoid the potential bug in the later point of time
--
This message was sent by Atlassian Jira
(v8.20.10#820010)