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.