Derby
  1. Derby
  2. DERBY-4387

Infinite loop in PredicateList.joinClauseTransitiveClosure()

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major 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
    • Labels:
      None
    • Issue & fix info:
      High Value Fix, Repro attached
    • Bug behavior facts:
      Crash

      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;

      1. derby-4387.diff
        3 kB
        Dag H. Wanvik
      2. derby-4387.stat
        0.2 kB
        Dag H. Wanvik

        Issue Links

          Activity

          Knut Anders Hatlen created issue -
          Mike Matrigali made changes -
          Field Original Value New Value
          Issue & fix info [Repro attached] [High Value Fix, Repro attached]
          Dag H. Wanvik made changes -
          Attachment derby-4387.diff [ 12426233 ]
          Attachment derby-4387.stat [ 12426234 ]
          Dag H. Wanvik made changes -
          Assignee Dag H. Wanvik [ dagw ]
          Dag H. Wanvik made changes -
          Issue & fix info [Repro attached, High Value Fix] [High Value Fix, Patch Available, Repro attached]
          Dag H. Wanvik made changes -
          Attachment derby-4387.diff [ 12426233 ]
          Dag H. Wanvik made changes -
          Attachment derby-4387.diff [ 12426235 ]
          Dag H. Wanvik made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          Dag H. Wanvik made changes -
          Status In Progress [ 3 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          Dag H. Wanvik made changes -
          Fix Version/s 10.6.0.0 [ 12313727 ]
          Issue & fix info [Repro attached, Patch Available, High Value Fix] [High Value Fix, Repro attached]
          Knut Anders Hatlen made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Lily Wei made changes -
          Link This issue is required by DERBY-4728 [ DERBY-4728 ]
          Lily Wei made changes -
          Resolution Fixed [ 1 ]
          Status Closed [ 6 ] Reopened [ 4 ]
          Mike Matrigali made changes -
          Status Reopened [ 4 ] Resolved [ 5 ]
          Fix Version/s 10.5.3.1 [ 12314182 ]
          Resolution Fixed [ 1 ]
          Mike Matrigali made changes -
          Assignee Dag H. Wanvik [ dagw ] Mike Matrigali [ mikem ]
          Knut Anders Hatlen made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Knut Anders Hatlen made changes -
          Assignee Mike Matrigali [ mikem ] Dag H. Wanvik [ dagw ]
          Gavin made changes -
          Workflow jira [ 12477945 ] Default workflow, editable Closed status [ 12801690 ]

            People

            • Assignee:
              Dag H. Wanvik
              Reporter:
              Knut Anders Hatlen
            • Votes:
              1 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development