Does JQL text search has a length limitation?

[ji tang]

I'm using below JQL to do the query:

"Script Name" ~ "VM_SNAPSHOT_BASIC" works

but "Script Name" ~ "VM_SNAPSHOT_BASIC_OPS" not work.

Why?

[Chung Park Chan]

JQL queries are stored in TEXT data type in PostgreSQL and LONGTEXT data type in MySQL, which means they have unlimited length

[Suren Raj]

Hi, Ji.

Does this issue happen in all or specific browser? The JQL should work.

At the same time, we would like to know you using JIRA server or cloud?

Cheers

[Alana Fernando]

hi @ji tang,

May I ask you what is the error you are getting when executing the second query? 

[ji tang]

Hi, there's no error messages, just get nothing by using second query.

[Alana Fernando]

If there is no error occurred, probably there are no tickets available where Script Name contain VM_SNAPSHOT_BASIC_OPS. 

have you noticed any available issues that should filter out in "Script Name" ~ "VM_SNAPSHOT_BASIC_OPS" query? 

if so i suggest you to contact Atlassian support regarding this. they should be able to support you further on this :-) 

[ji tang]

There does couples of issues where script name contains VM_SNAPSHOT_BASIC_OPS.  But the problem is I can query with "VM_SNAPSHOT_BASIC" or "VM_SNAPSHOT_BASIC_".   But cannot do it with even one character longer.  That's interesting.

[Alana Fernando]

I suggest you to contact  Atlassian support, they should be able to guide you @ji tang :-) 

[ji tang]

Good suggestions, thanks Alana.