Skip to content
Search to learn about InterSystems products and solutions, career opportunities, and more.

Alert: SQL Query using “NOT %INLIST” fails to return results

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.

Latest Alerts & Advisories