Skip to content

$delete-expunge more than 10k resources with the same RES_UPDATED value will only delete the first 10000 resources #5150

Closed
@lukedegruchy

Description

@lukedegruchy

Describe the bug
A $delete-expunge operation on more than 10,000 resources with the same RES_UPDATED will only delete the first 10,000 resources.

To Reproduce
Steps to reproduce the behavior:

  1. start hapi-fhir backed by any database
  2. create 10,500 patients
  3. update HFJ_RESOURCE set RES_UPDATED = '2023-07-09 19:34:45' where res_type = 'Patient';
  4. select * from HFJ_RESOURCE where res_type = 'Patient'; be sure all values updated
  5. DELETE: http://localhost:8000/Patient?_expunge=true

Expected behavior
All 10,500 patients are gone from the DB and from a GET Patients query

Environment (please complete the following information):

  • HAPI FHIR Version: 6_8

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions