-
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
-
Component/s: Environments, Environments > Databases, ~[Archived] WCM
-
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.
-
Epic/Theme:
-
Business Value:5
-
Git Pull Request:
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 ...)