Inconsistent search results when using dashes.
Platform Notice: Cloud and Data Center - This article applies equally to both cloud and data center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Problem
When using dashes "-" in text-field custom fields you receive inconsistent search results in JQL.
Diagnosis
Diagnostic Steps
- Create text-field custom fields with values of test-123 test-456 test-789
- Search for "<customfield>" ~ test-*"
- After a re-index, you may or may not get all of those expected values from the query result
Cause
- Lucene indexing doesn't index dashes, so using them in your text fields will result in inconsistent results when attempting to query them. Especially when combined with the "*" operator.
- See JRASERVER-45286 - Inconsistent behavior with contains Dash operator (-) and the response that this is not a bug.
Workaround
- Replace underscores (or don't use either) for dashes for any value that you are going to be consistently searching against.