[jira] [Created] (RANGER-3929) To support batching in SQL IN clause of SQL queries used in Ranger

["Ramachandran (Jira)" <ji...@apache.org>]

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)