Why searching by custom field's value is not returning all issues it should

N_o0x48p

Hello everyone

I added an custom text field and I did reindex.  JIRA's version 7.1.2 (server). Then I try search issues when custom field's value ~"334" and I get 4 issues.

 

Project A Issue C
Broject B Issue F
Broject B Issue G
Broject B Issue H

 

But when I did request to database

select j.project, j.issuenum, j.summary, cf.stringvalue from customfieldvalue cf, jiraissue j
where cf.customfield=14402
and cf.issue(+)=j.id and cf.stringvalue='334'

I get 8 issues.

Project A Issue C
Project A Issue D
Project A Issue E
Broject B Issue F
Broject B Issue G
Broject B Issue H
Broject B Issue J
Broject B Issue K

 

Why I can't get 8 issues via jql?

N_o0x48p

I found the reason. I updated customfield's value by using JAVA API and I forget to re-index issue.