Skip to content
Pesquise para saber mais sobre produtos e soluções da InterSystems, oportunidades de carreira e muito mais.

Advisory: Incomplete Query Results with ‘ORDER BY DESC’ – HealthShare

February 11, 2021 – Advisory: Incomplete Query Results with ‘ORDER BY DESC’ – HealthShare

InterSystems has corrected a defect that can cause incomplete query results.  This defect affects the platforms underlying HealthShare and HealthShare Health Connect:

Customers using HealthShare Personal Community should evaluate the number of proxy relationships they have established or removed. Customers that have established or removed proxy relationships more than 64,000 times are at risk for this defect.

Other than Personal Community, this defect does not affect query logic in the HealthShare or HealthShare Health Connect software.  However, Customers that have developed custom queries using the functions provided by InterSystems IRIS for Health, could be affected if they have the following HealthShare products and versions:

  • HealthShare 2019.2, 2020.1 and 2020.2
  • Health Connect 2019.1.0, 2019.1.1, 2020.1.0

A query can trigger the defect only if it meets all of the following conditions:

  • The query contains an ORDER BY clause sorting in descending (DESC) order.
  • The field used for that sorting is the table’s row ID.
  • The query contains conditions on multiple indexed fields.
  • The query selects data from only one table.
Users can modify an individual query to ensure correct results by replacing:
ORDER BY

DESC

with


ORDER BY

+0 DESC

The corrections for this defect are identified as DP-402745 and DP-403046 and will be included in all future product releases. They are also available via Ad hoc distribution from the InterSystems Worldwide Response Center (WRC).

If you have any questions regarding this Advisory, please contact the Worldwide Response Center.
RELATED TOPICS

Latest Alerts & Advisories

Oct 07, 2025
Risk Category & Score Explicit Requirements DP-442892 InterSystems IRIS® data platform InterSystems IRIS® for Health HealthShare® Health Connect versions 2023.3.0, 2024.1.0 – 2024.1.3, 2024.2.0, 2024.3.0, and 2025.1.0 HealthShare® Unified Care Record versions 2024.2 and 2025.1 Wrong Results: High Risk Specific use of OUTER JOIN when the inner leg has an index on the join fields In InterSystems IRIS versions 2023.3.0, 2024.1.0 – 2024.1.3, 2024.2.0, 2024.3.0, and 2025.1.0, for queries that use an OUTER JOIN and where InterSystems IRIS performs parallel execution, the query may silently return wrong results.
Oct 07, 2025
Risk Category & Score Explicit Requirements HSHC-5268 HealthShare® Health Connect and InterSystems IRIS® for Health versions 2025.1.1 Functional: Medium Risk Occurs when performing SDA3 -> FHIR transformations involving the Encounter resource.
Oct 07, 2025
Risk Category & Score Explicit Requirements DP-443396 InterSystems IRIS® data platform InterSystems IRIS® for Health HealthShare® Health Connect versions 2024.1.0 – 2024.1.4, 2024.2.0, 2024.3.0, and 2025.1.0, and 2025.1.1 HealthShare® Unified Care Record versions 2024.2 and 2025.1 Wrong Results: Low Risk Using Common Table Expressions in Dynamic SQL
Sep 30, 2025
In InterSystems IRIS, InterSystems IRIS for Health, and HealthShare Health Connect, versions 2025.1.1 and 2025.2.0, the new “ Mirror Database Download” functionality does not include certain globals.
Sep 24, 2025
Risk Category & Score Explicit Requirements DP-444551 InterSystems IRIS® data platform InterSystems IRIS® for Health HealthShare® Health Connect versions 2025.1.0, 2025.1.1, and 2025.2
Sep 03, 2025
Risk Category & Score Explicit Requirements DP-442440 InterSystems IRIS ® data platform 2025.1.1.308.0 InterSystems IRIS for Health HealthShare® Health Connect Operational:
Jul 23, 2025
InterSystems IRIS 2025.2 introduces the IRISSECURITY database, the new home for security data. Unlike IRISSYS, the previous home for security data, IRISSECURITY can be encrypted, which secures your sensitive data at rest. In a future version, IRISSECURITY will be mirrorable.
Jul 23, 2025
InterSystems is pleased to announce the General Availability (GA) of the 2025.2 release of InterSystems IRIS® data platform. This is a Continuous Delivery (CD) release. Please note that the GA versions of InterSystems IRIS for Health™ and HealthShare® Health Connect™ 2025.2 are currently withheld due to mirroring limitations introduced by security updates (details below).
Jun 10, 2025
Advisory ID Product & Versions Affected Risk Category & Score Explicit Requirements DP-439649 Products:
May 20, 2025
This issue affects all versions of HealthShare®: