Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Strange JQL behaviour when summary contains a number

Hi Community,

I created two issues.

The first one's summary reads:

Update myhost.example.org, 07.02.2020

The second one's summary reads:

Update myhost.1example.org, 07.02.2020

Unintentionally I queried via JQL as follows:
summary ~ "myhost.example.org,07.02.2020"
Notice the missing blank space between the comma and the date (07.02.2020).

To my surprise Issue Navigator showed my a result anyway!

I got curious and tried to query the second one by:
summary ~ "myhost.1example.org,07.02.2020"
Again, notice the missing blank space.

In this case I do not get any result. I tracked it down to the "1" in the domain (1example.org).

Although I fully understand that it is really crucial to have a correct specified JQL query here - why does one query do not consider the missing blank space but for the case there is a number in the domain it cares?

Thanks,
Birgit

 

 

3 answers

1 accepted

0 votes
Answer accepted
Ignacio Pulgar Community Leader Feb 10, 2020

Hi @bschmi 

Blankspaces are not stored at all in the Lucene index, so they cannot be considered in any ways.

Too common words, like prepositions, are not stored in the index either.

Combinations of letters plus numbers is known to cause issues:

https://jira.atlassian.com/browse/JRASERVER-31882

Just for curiosity, does this search work?

summary ~ "myhost.?example.org,07.02.2020 

And this one?

summary ~ "myhost.*example.org,07.02.2020"

Hope it helps.

0 votes
Jack Community Leader Feb 10, 2020

While I do find it odd that nothing is found in the second case, it is important to note that you are using the ‘approximate’ operator here “~”. That operator is not looking for exact match so spaces could be ignored.

Hi @Ignacio Pulgar 

Neither summary ~ "myhost.?example.org,07.02.2020" (I took the liberty to add a " at the very end) nor summary ~ "myhost.*example.org,07.02.2020" produces any output.

JRASERVER-31882 was an interesting read.

Thanks also to @Jack for your contribution.

Cheers,
Birgit

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you