Summary

JQL will search by last text field value even when field value was set to empty.

Step to Replicate

1. Create a ticket with a custom text field in it. Populate the field with 'ToDo'.
2. Edit the ticket and remove the text field value.
3. Go to the issue navigator and run the query below.

   field1 ~ "ToDo"
   

4. The issue will be returned despite it being empty. The JQL is also checking the issue history.
5. Go back to the issue and change the text field value to 'Test'.
6. Run the JQL query again from the issue navigator again.
7. This time the issue will not be returned.

Expected Result

Jira should not be querying against last non empty field value when the field that is specified in the clause is empty.

Current Result

Jira is querying against issue last non empty field value when the field that is specified in the clause is empty.