[DERBY-4387] Infinite loop in PredicateList.joinClauseTransitiveClosure()

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.0.2.1, 10.1.3.1, 10.2.2.0, 10.3.3.0, 10.4.2.0, 10.5.3.0, 10.6.1.0
• Fix Version/s: 10.5.3.1, 10.6.1.0
• Component/s: SQL
• Issue & fix info: High Value Fix, Repro attached
• Bug behavior facts: Crash
• Assignee: Dag H. Wanvik
• Reporter: Knut Anders Hatlen
• Created: 25/Sep/09 12:34
• Updated: 20/Jan/11 21:43
• Resolved: 07/Jul/10 22:53

Description

This sequence of statements triggers an infinite loop in PredicateList.joinClauseTransitiveClosure() and never completes:

create table c (a int, b int, c int);
create table cc (aa int);

select * from cc t1, c t2, cc t3 where t3.aa = t2.a and t3.aa = t2.b and t3.aa = t2.c;

Issue Links

• is required by: DERBY-4728 10.5 backport effort tracking issue