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

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

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 4.2.M1, 4.2.M2
    • 4.2.M3
    • Core Library
    • 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

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

            Dates

              Created:
              Updated:
              Resolved: