[CAY-1263] Oracle adapter should automatically strip IN clauses with more than 1000 elements

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0M6
• Fix Version/s: 3.0 beta 1, 3.0
• Assignee: Andrey Razumovsky
• Reporter: Andrey Razumovsky
• Created: 26/Aug/09 12:17
• Updated: 24/Jul/18 08:52
• Resolved: 10/Sep/09 15:46

Description

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

Issue Links

• is related to: CAY-2445 Oracle: Problem with ExpressionFactory.notInExp()