The SQL query hash has been including parameter values when it shouldn't, which is causing custom queries to be parameter value specific. This is undesired as custom queries should apply regardless of parameter values. This PR changes the way query hashes are generated to remove parameter values.
Related issues
Addresses Bug 131113: SQL query hashes have parameter value hashes included
Testing
Describe how this change was tested.
FHIR Team Checklist
Update the title of the PR to be succinct and less than 65 characters
Add a milestone to the PR for the sprint that it is merged (i.e. add S47)
Tag the PR with the type of update: Bug, Build, Dependencies, Enhancement, New-Feature or Documentation
Tag the PR with Open source, Azure API for FHIR (CosmosDB or common code) or Azure Healthcare APIs (SQL or common code) to specify where this change is intended to be released.
Tag the PR with Schema Version backward compatible or Schema Version backward incompatible or Schema Version unchanged if this adds or updates Sql script which is/is not backward compatible with the code.
Description
The SQL query hash has been including parameter values when it shouldn't, which is causing custom queries to be parameter value specific. This is undesired as custom queries should apply regardless of parameter values. This PR changes the way query hashes are generated to remove parameter values.
Related issues
Addresses Bug 131113: SQL query hashes have parameter value hashes included
Testing
Describe how this change was tested.
FHIR Team Checklist
Semver Change (docs)
Patch|Skip|Feature|Breaking (reason)