Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-13059

Relationship search (from advanced search) contains server killing join

          Details

          • Type: Bug
          • Status: Done/Fixed
          • Priority: Trivial
          • Resolution: Fixed/Completed
          • Affects Version/s: 4.2.9
          • Fix Version/s: 4.4.0
          • Component/s: None
          • Labels:
            None

            Description

            When a relationship search is deemed 'reciprocal' - the relationship type could be a_b or b_a the join used includes an OR which is an indexed join.

            I have managed to get this search working using a temp table (on 4.3.5) - will attach as PR.

              Attachments

                Activity

                  People

                  • Assignee:
                    monish.deb Monish Deb
                    Reporter:
                    eileen Eileen McNaughton
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    3 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: