Uploaded image for project: 'Cayenne'
  1. Cayenne
  2. CAY-2683

Don't use DISTINCT for joins on to-one related tables

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 4.2.M1, 4.2.M2
    • Fix Version/s: 4.2.M3
    • Component/s: Core Library
    • Labels:
      None

      Description

      New SelectTranslator introduced in CAY-2465 uses DISTINCT by default for all queries that have at least one join. This could lead to some performance issues. Moreover, this logic differs from the old translator.

        Attachments

          Activity

            People

            • Assignee:
              ntimofeev Nikita Timofeev
              Reporter:
              ntimofeev Nikita Timofeev
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: