Details

    • Type: Technical Task
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 6.1.1 CE GA2, 6.1.20 EE GA2
    • Fix Version/s: 6.2.0 CE M5
    • Labels:
    • Environment:
      Tomcat 7 + MySQL 5.5. Portal 6.2.x GIT ID: 06e81d2c98901c0ba546e9eb61b49e379d80b6a4.
      Tomcat 7 + Oracle 11g. Portal 6.2.x GIT ID: 06e81d2c98901c0ba546e9eb61b49e379d80b6a4.

      Description

      There is no need to calculate the lastest version by using the combination of GROUP BY and MAX(version), because it's enough to count each matching articleId with a COUNT(DISTINCT ...)

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  6 years, 39 weeks, 5 days ago

                  Packages

                  Version Package
                  6.2.0 CE M5