Search to learn about InterSystems products and solutions, career opportunities, and more. Results include content from our developer community, product documentation and education websites in addition to InterSystems.com.

Alert: Incorrect Query Results

February 9, 2022 – Alert: Incorrect Query Results

InterSystems has corrected a defect that can result in an SQL query returning incorrect results.

This defect exists only in the 2021.2 ( Continuous Delivery) version of:

  • InterSystems IRIS Data Platform
  • InterSystems IRIS for Health
  • HealthShare Health Connect

InterSystems has replaced existing distributions of these products with new builds that correct the defect. The corrected distributions can be identified by the build number (651) and are available via normal means. Ad Hoc corrections are not available for Continuous Delivery (CD) distributions.

This defect impacts queries that are optimized by the new 2021.2 Runtime Plan Choice (RTPC) feature. InterSystems recommends installing a corrected distribution; as an interim workaround, you can avoid the risk of incorrect results by disabling this feature.

For reference, the correction is identified as YCL092. This correction will be included in all future product distributions.

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

Sign Up Today

Receive notifications on support alerts, critical issues,
fixes, and product releases.
*Required Fields
Highlighted fields are required
*Required Fields
Highlighted fields are required
By submitting this form, you give consent to receive notifications concerning support alerts, critical issues, important updates, fixes, and product releases via email. In addition, you consent to your business contact information being entered into our CRM solution that is hosted in the United States, but maintained consistent with applicable data protection laws.
**By clicking here, you give consent to be contacted for news, updates and other marketing purposes related to existing and future InterSystems products, offerings, and events.