Skip to content
Effectuer une recherche pour en savoir plus sur les produits et solutions InterSystems, les offres d'emploi, etc.

Alert: Incorrect Query Results

April 4, 2023 - Alert: Incorrect Query Results

InterSystems has corrected a defect that can cause an SQL query to return incorrect results.

The defect exists in the following products and any InterSystems offerings based on them.

Impacted versions are 2021.2, 2022.1.x, 2022.2, and 2022.3:

  • InterSystems IRIS®
  • InterSystems IRIS for Health™
  • HealthShare® Health Connect

Impacted version is 2022.2:

  • InterSystems HealthShare®

The issue can be triggered when SQL Runtime Plan Choice (RTPC) is enabled (the default) and the query contains a "truth value" WHERE ? = ?. When triggered, some predicates may not be evaluated correctly; this leads to incorrect query results.

Note: It is not possible to fully assess a query's vulnerability by reviewing the SQL. This is because InterSystems SQL query optimization can add truth values to the internal representation of queries.

If your environment uses InterSystems SQL, then you can immediately remediate the issue by disabling the RTPC feature.

Note: Additional information about mitigations for InterSystems HealthShare® will be released shortly.

The correction for this defect is identified as YCL227 and will be included in all future versions of InterSystems IRIS®, InterSystems IRIS for Health™, and HealthShare® Health Connect as well as any InterSystems products based on them.

The correction is also available via Ad hoc distribution.

If you have any questions regarding this alert, please contact the Worldwide Response Center.

Latest Alerts & Advisories

15 Aug 2024
InterSystems has corrected a defect that can cause database corruption or errors with multi-volume databases under extremely rare circumstances. Only databases that have been truncated are at risk.
24 Jul 2024
There are four alerts in the HS2024-03 Alert Communication. A summary of each alert is shown below. Details for each alert are contained in the linked document.
24 Jun 2024
Broadcom recently announced a problem that can cause data consistency errors in database applications. The Broadcom article is available here:
30 May 2024
Beginning with the release of InterSystems IRIS® data platform 2022.3, InterSystems corrected the license enforcement mechanism to include REST and SOAP requests. Due to this change, environments with non-core-based licenses that use REST or SOAP may experience greater license utilization after upgrading. To determine if this advisory applies to your InterSystems license, follow the instructions in the FAQ linked below.
01 May 2024
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.
08 Apr 2024
InterSystems has encountered a defect that causes some upgrades of HealthShare® Health Connect to fail. This only affects instances that are not licensed for the use of FHIR® and that have interoperability-enabled namespaces. Under these conditions, the upgrade fails with an error.
19 Mar 2024
In evaluating an IBM Support notification, InterSystems has determined a potential impact for our customers. The notification in question is:
27 Feb 2024
There is 1 alert in the HealthShare HS2024-limited Alert communication. An alert summary for the issue is shown is in the table below. Details for the alert are contained in the attached document: HS2024 Limited Communication.
01 Feb 2024
There are 2 alerts in the HealthShare HS2024-02 Alert communication. An alert summary for each issue is shown is in the table below. Details for each alert are contained in the attached document: HS2024-02-Communication.