USACE / USACE/cwms-data-api

Standard Text Data DELETE not completely deleting the data

Open
#847 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
Java
Stars
28
Forks
25
Avg merge
4d 22h
Merged PRs (30d)
20

Description

Standard text data deleted with the standard text endpoint is still visible in the CLOB endpoint. To replicate:

  1. Enter a key/value with the standard text endpoint. Retrieve w/ standard text endpoint to confirm store.
  2. Delete the key/value with the standard text endpoint. Retrieve w/ standard text endpoint to confirm delete.
  3. Query the the CLOB endpoint with a the key you entered with a wildcard and the key/value still shows it's stored in the standard text table.

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Reproduce the sequence using the standard text endpoint, then query the CLOB endpoint with a wildcard for the same key. Trace the standard text DELETE handling and its persistence behavior. Done means deleting standard text data also removes it from CLOB endpoint results.

Written by the indexing model from the issue text.

Assessment

Tech stack
java
Domain
api, database
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.