Deleting an Issue Does not Remove Associated Labels

Issue Summary

When deleting an issue, the issue it's data should be removed. But labels do not get removed, leaving an orphaned entry in the labels table.

Steps to Reproduce

1. Create an issue and add a label. In this example I'll add "testlabel"
2. Delete this newly created issue

Expected Results

The issue is deleted, as well as the "testlabel" association.

Actual Results

The issue is deleted, but an entry remains in the database:

jira851test=# select * from label where issue not in (select id from jiraissue );
  id   | fieldid | issue |   label
-------+---------+-------+-----------
 10201 |         | 10300 | testlabel
(1 row)

• issue 10300 does not exist as it was deleted, but we still see this entry associating the "testlabel" to this non-existent issue.

Workaround

Currently there is no known workaround for this behavior. A workaround will be added here when available