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

Alert: Incomplete Query Results with ‘ORDER BY DESC’

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

InterSystems has corrected a defect that can cause incomplete query results. This defect affects:

  • InterSystems IRIS and InterSystems IRIS for Health 2019.1.0, 2019.1.1, 2019.2, 2019.3, 2019.4, 2020.1.0, 2020.2, and 2020.3
  • HealthShare Health Connect 2019.1.0, 2019.1.1, 2020.1.0
  • HealthShare Products 2019.2, 2020.1 and 2020.2

(In HealthShare and HealthShare Health Connect, this defect only affects Personal Community with 64,000 patient proxies and possibly customer-built custom queries. For more details on how this defect affects HealthShare, please see Advisory: Incomplete Query Results with ‘ORDER BY DESC’-HealthShare)

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

You can modify an individual query to ensure correct results by replacing

ORDER BY <row ID field> DESC

with

ORDER BY <row ID field>+0 DESC

Note that some InterSystems search utilities, including the Interoperability Message Viewer, use queries that could be affected by this defect and cannot be edited. The only way to mitigate this defect system-wide is to install a version that includes the corrections.

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 alert, please contact the Worldwide Response Center.

 

Latest Alerts & Advisories

Aug 15, 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.
Jul 24, 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.
Jun 24, 2024
Broadcom recently announced a problem that can cause data consistency errors in database applications. The Broadcom article is available here:
May 30, 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.
Apr 30, 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.
Apr 08, 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.
Mar 19, 2024
In evaluating an IBM Support notification, InterSystems has determined a potential impact for our customers. The notification in question is:
Feb 27, 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.
Feb 01, 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.