Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Deleting emails leaves orphaned entries in the emailattachments table #394

Closed
c-w opened this issue Jul 26, 2017 · 0 comments
Closed

Deleting emails leaves orphaned entries in the emailattachments table #394

c-w opened this issue Jul 26, 2017 · 0 comments
Assignees

Comments

@c-w
Copy link
Member

c-w commented Jul 26, 2017

Repro steps:

  1. Create two accounts: userA and userB.
  2. Send an email with attachment from userA to userB.
  3. Inspect the DB echo 'SELECT id FROM email;' | sqlite3 /tmp/email.store and note the email ids.
  4. Inspect the DB echo 'SELECT id FROM attachment;' | sqlite3 /tmp/email.store and note the attachment ids.
  5. Log in as userB and delete the email in the UI.
  6. Inspect the DB echo 'SELECT email_id, attachment_id from emailattachment;' | sqlite3 /tmp/email.store and observe that:
    a) The attachment was deleted.
    b) The email was deleted.
    c) However, a row for the deleted email and its attachment remains in the association table.
@c-w c-w self-assigned this Jul 26, 2017
@c-w c-w closed this as completed in 33fac96 Jul 26, 2017
@c-w c-w transferred this issue from another repository Apr 29, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant