[DERBY-1818] Renable largeCodeGen test to run with 10,000 UNIONs.

• Type: Task
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 10.2.2.0, 10.3.1.4
• Component/s: Test
• Labels: derby_triage10_11
• Urgency: Normal
• Assignee: Unassigned
• Reporter: A B
• Created: 06/Sep/06 21:37
• Updated: 12/Aug/13 23:17

Description

Now that a fix for DERBY-1315 has been checked into 10.3 (and ported to 10.2) the lang/largeCodeGen.java test should be updated to run with10,000 unions. But that said, the 10,000 union test case requires 512M available memory and maxxes out my CPU for 10 minutes before completing--which begs the question of whether or not the test should be enabled as part of derbyall or as part of some other suite.

I admit that I haven't done much investigation here, but I don't know when I'll have a chance to do that investigation so I'm creating this Jira task for tracking. I separated this out from DERBY-1315 because the code-side changes for that issue have already been committed and I think it's better to mark that issue as "resolved" sooner rather than later. Also, it seems like the largeCodeGen test ties several Jira issues together so re-enabling the 10,000 union case may not be as trivial as it sounds. See esp. DERBY-759, DERBY-766.

Issue Links

• is related to: DERBY-766 Improve code generation to handle 5000 unions in a select the union test in largeCodeGen
• is related to: DERBY-759 Query with thousands of logical operators and parameters causes StackOverflowError and then ERROR 40XT0: An internal error was identified by RawStore module on next statement
• is related to: DERBY-1315 Statement optimization/compilation fails with OutOfMemoryException in largeCodeGen test with embedded and framework DerbyNetClient