Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-77702

Searching a words that contains more than 255 characters in a text return wrong results

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Low
    • None
    • 8.22.6, 9.2.1, 8.20.30, 9.4.18
    • JQL Search
    • None

    Description

      Issue Summary

      This is reproducible on Data Center: (yes)

      Steps to Reproduce

      1. Add a new Text Field (multi-line) custom field.
      2. Add to any projects.
      3. Search a words that contains more than 255 characters combination with special characters and numerical characters. For example, ABC-123 or ABC123

      When searching a whole word, the search works (more than 255 characters):

      text ~ "hello"

      hello,hello,hello,hello,hello,hello,hello,hello,hello,hello,hello,hello,hello,hello,hello,hello,hello,hello,hello,hello,hello,hello,hello,hello,hello,hello,hello,hello,hello,hello,hello,hello,hello,hello,hello,hello,hello,hello,hello,hello,hello,hello,hello,hello,hello,hello,hello,hello,hello,hello

      When combining a special character or numerical characters in the searching words, the search breaks when exceeded 255 characters:

      text ~ "ABC-123"

      ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123

      text ~ "ABC123"

      ABC123,ABC123,ABC123,ABC123,ABC123,ABC123,ABC123,ABC123,ABC123,ABC123,ABC123,ABC123,ABC123,ABC123,ABC123,ABC123,ABC123,ABC123,ABC123,ABC123,ABC123,ABC123,ABC123,ABC123,ABC123,ABC123,ABC123,ABC123,ABC123,ABC123,ABC123,ABC123,ABC123,ABC123,ABC123,ABC123,ABC123

      or

      ABC123ABC123ABC123ABC123ABC123ABC123ABC123ABC123ABC123ABC123ABC123ABC123ABC123ABC123ABC123ABC123ABC123ABC123ABC123ABC123ABC123ABC123ABC123ABC123ABC123ABC123ABC123ABC123ABC123ABC123ABC123ABC123ABC123ABC123ABC123ABC123ABC123ABC123ABC123ABC123ABC123ABC123ABC123ABC123

      Expected Results

      Jira should allow the search returns if more than 255 characters in a text search.

      Actual Results

      There isn't any results return.

      Workaround

      Putting a space in between the words such as:

      ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123, ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123,ABC-123

      Notes

      The problem affected to all the "text" search

      Attachments

        Activity

          People

            Unassigned Unassigned
            ckimloong John Chin
            Votes:
            2 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated: