July 21, 2021 – Alert: Incorrect Query Results with Non-Standard ‘GROUP BY’ Query
InterSystems has corrected a defect that can cause incorrect query results. This defect affects:
- All major releases and maintenance versions of InterSystems IRIS and InterSystems IRIS for Health, starting with 2019.1.0
A query block may encounter the defect only if it meets all the following conditions:
- The query block contains a GROUP BY clause but does not include any aggregates, such as COUNT(*).