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

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

    [ https://issues.apache.org/jira/browse/RANGER-3929 ]


    Bhavik Patel deleted comment on RANGER-3929:
    --------------------------------------

was (Author: bpatel):
Please close the review request 

> 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
>            Priority: Major
>         Attachments: 0001-RANGER-3929-To-support-batching-in-SQL-IN-clause-of-.patch
>
>
> 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)