You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cayenne.apache.org by "Andrey Razumovsky (JIRA)" <ji...@apache.org> on 2009/09/10 17:47:57 UTC

[jira] Closed: (CAY-1263) Oracle adapter should automatically strip IN clauses with more than 1000 elements

     [ https://issues.apache.org/jira/browse/CAY-1263?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Andrey Razumovsky closed CAY-1263.
----------------------------------

       Resolution: Fixed
    Fix Version/s: 3.0 beta 1
         Assignee: Andrey Razumovsky

> Oracle adapter should automatically strip IN clauses with more than 1000 elements
> ---------------------------------------------------------------------------------
>
>                 Key: CAY-1263
>                 URL: https://issues.apache.org/jira/browse/CAY-1263
>             Project: Cayenne
>          Issue Type: Improvement
>    Affects Versions: 3.0M6
>            Reporter: Andrey Razumovsky
>            Assignee: Andrey Razumovsky
>             Fix For: 3.0 beta 1
>
>
> Oracle (and maybe other) adapter should automatically strip IN clauses with more than 1000 elements. E.g.
> IN (1,2,...1500) ---> IN (1,2...1000) OR IN (1001,...1500)
> Otherwise SQLException occurs, because all Oracles do not support INs with more than 1000 elements

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.