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

              Assignee:
              sophia.zhang Sophia Zhang
              Reporter:
              laszlo.csontos Laszlo Csontos (Inactive)
              Recent user:
              Gabor Kovacs
              Participants of an Issue:
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                7 years, 37 weeks, 1 day ago

                  Packages

                  Version Package
                  6.2.0 CE M5