InterSystems has corrected an issue that can cause a small number of SQL queries to return incorrect results. See below for the specifics on impacted queries.
This issue exists in the listed versions of the following products:
- InterSystems IRIS® data platform
- InterSystems IRIS for Health™
- HealthShare® Health Connect
As well as:
- Other InterSystems products based on the above products.
Impacted versions:
- 2021.1.3, 2021.1.4
- 2022.1.3, 2022.1.4
- 2023.1.0, 2023.1.1, 2023.1.2, 2023.1.3
- 2024.1.0
Only queries with the following conditions could return wrong results:
- The WHERE clause contains a NOT %INLIST
- There is a NULL value in the list
The correction for this defect is identified as DP-430793 and will be included in all future product releases beginning with: 2022.1.5, 2023.1.4, and 2024.0.267.2. It is also available via ad hoc distribution.
If you have any questions regarding this alert, please contact the Worldwide Response Center.