Robin Arnold

Ensure lastUpdated increases with versionId in a distributed environment

4

**Describe the bug** In a highly concurrent distributed environment, resource updates may be processed on different nodes. Those nodes may suffer clock drift which could potentially cause version N+1 having...

Azure blob offload cannot connect to older instance of azurite

1

**Describe the bug** Running an older instance of azurite, after updating the Azure blob client libraries we can no longer connect: ``` Caused by: java.util.concurrent.ExecutionException: com.azure.storage.blob.models.BlobStorageException: Status code 400, "...

**Is your feature request related to a problem? Please describe.** The fhir-database-utils is supposed to be general purpose and should not contain anything specific to the FHIR schema (which is...

Add e2e test for schema tool `--grant-read-to` option

2

**Is your feature request related to a problem? Please describe.** The `--grant-read-to` option is not exercised by the e2e test suite leaving it vulnerable to regression errors. **Describe the solution...

Slow whole-system search query with _lastUpdated when _type filter is injected

6

**Describe the bug** The following query has only a single resource in scope and therefore should be very fast: ``` GET [base]/?_count=2&_lastUpdated=gt2022-08-07 ``` However, due to 4.0/4.3 type filtering, the...

**Describe the bug** In Citus we distribute resource and parameter tables using logical_resource_id. All joins between tables must therefore include logical_resource_id in the join predicate. Certain search queries which require...

Refactor parameter persistence to use fhir-remote-index backend

2

**Is your feature request related to a problem? Please describe.** fhir-remote-index uses a new implementation to collect parameter values, handle resolution of all the lookup values, and then persist the...

**Is your feature request related to a problem? Please describe.** Currently FHIROperation implementations can access the FHIRPersistence interface: ``` FHIRPersistence pl = (FHIRPersistence) operationContext.getProperty(FHIROperationContext.PROPNAME_PERSISTENCE_IMPL); ``` Using this interface, the implementations...

Improve search performance by eliminating redundant joins

3

**Is your feature request related to a problem? Please describe.** Each parameter table contains logical_resource_id which is a FK reference to the (type)_logical_resources table. This is reflected in search query...

In FHIRPersistenceJDBCImpl connect transactionDataImpl to transaction provider framework

2

Currently transactionDataImpl receives transaction event callbacks from JTA UserTransaction. However, transactions in unit tests are managed differently, and so the transaction framework needs to be updated to feed similar transaction...