Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

KQL removes leading zero and breaks query #62217

Closed
cawoodm opened this issue Apr 1, 2020 · 1 comment · Fixed by #62748
Closed

KQL removes leading zero and breaks query #62217

cawoodm opened this issue Apr 1, 2020 · 1 comment · Fixed by #62748
Assignees
Labels
bug Fixes for quality problems that affect the customer experience Feature:KQL KQL

Comments

@cawoodm
Copy link

cawoodm commented Apr 1, 2020

Kibana version: 7.6.1
Elasticsearch version: 7.6.1
Server OS version: Windows 2012R2
Browser version: Chrome 80
Browser OS version: Windows 10

Original install method (e.g. download page, yum, from source, etc.): Download

Describe the bug:
KQL seems to silently remove leading zeros causing queries to fail.

When querying "customer: 00123" with Lucene we get results but KQL removes the leading zeros:
image
image

"filter":[{"bool":{"should":[{"match":{"customer":12282650}}]...

Lucene Query generates:
image

{"bool":{"must":[{"query_string":{"query":"customer: 0012282650","analyze_wildcard":true,"time_zone"...

Field type customer is keyword.

@mistic mistic added bug Fixes for quality problems that affect the customer experience Team:AppArch labels Apr 1, 2020
@elasticmachine
Copy link
Contributor

Pinging @elastic/kibana-app-arch (Team:AppArch)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Fixes for quality problems that affect the customer experience Feature:KQL KQL
Projects
None yet
Development

Successfully merging a pull request may close this issue.

6 participants