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

SQL: incorrect fractional value in duration expression #41635

Closed
bpintea opened this issue Apr 29, 2019 · 1 comment · Fixed by #51675
Closed

SQL: incorrect fractional value in duration expression #41635

bpintea opened this issue Apr 29, 2019 · 1 comment · Fixed by #51675
Labels

Comments

@bpintea
Copy link
Contributor

bpintea commented Apr 29, 2019

The following query:

POST /_xpack/sql
{
  "query": "SELECT INTERVAL '0.23' SECOND"
}

will yield the following result:

{"columns":[{"name":"INTERVAL '0.23' SECOND","type":"interval_second"}],"rows":[["PT0.023S"]]}

which contains the incorrect fractional digits value .023 instead of expected .230/.23.

The protocol tests also accommodate this error and should be corrected.

@elasticmachine
Copy link
Collaborator

Pinging @elastic/es-search

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants