Fix `FLOAT` -> `DOUBLE` cast. by Yury-Fridlyand · Pull Request #1025 · opensearch-project/sql · GitHub
Skip to content

Fix FLOAT -> DOUBLE cast.#1025

Merged
penghuo merged 2 commits into
opensearch-project:2.xfrom
Bit-Quill:integ-fix-cast-to-double
Nov 7, 2022
Merged

Fix FLOAT -> DOUBLE cast.#1025
penghuo merged 2 commits into
opensearch-project:2.xfrom
Bit-Quill:integ-fix-cast-to-double

Conversation

@Yury-Fridlyand

Copy link
Copy Markdown
Collaborator

Signed-off-by: Yury-Fridlyand yuryf@bitquilltech.com

Please, see team review & discussion in Bit-Quill#151.

Description

  • Fix FLOAT -> DOUBLE cast.
  • Update tests.
  • Update numeric -> BOOLEAN cast in LuceneQuery to comply with TypeCastOperator.

Issues Resolved

Fixes #998

Check List

  • New functionality includes testing.
    • All tests pass, including unit test, integration test and doctest
  • New functionality has been documented.
    • New functionality has javadoc added
    • New functionality has user manual doc added
  • Commits are signed per the DCO using --signoff

By submitting this pull request, I confirm that my contribution is made under the terms of the Apache 2.0 license.
For more information on following Developer Certificate of Origin and signing off your commits, please check here.

* Update tests.
* Update numeric -> `BOOLEAN` cast in `LuceneQuery` to comply with `TypeCastOperator`.

Signed-off-by: Yury-Fridlyand <yuryf@bitquilltech.com>
@Yury-Fridlyand Yury-Fridlyand requested a review from a team as a code owner November 3, 2022 22:43
@Yury-Fridlyand Yury-Fridlyand changed the title Integ fix cast to double Fix FLOAT -> DOUBLE cast. Nov 3, 2022
@codecov-commenter

codecov-commenter commented Nov 3, 2022

Copy link
Copy Markdown

@dai-chen dai-chen added the bug Something isn't working label Nov 4, 2022

@dai-chen dai-chen left a comment

Copy link
Copy Markdown
Collaborator

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Thanks for the fix!

@penghuo penghuo merged commit 0a4d92d into opensearch-project:2.x Nov 7, 2022
@Yury-Fridlyand Yury-Fridlyand deleted the integ-fix-cast-to-double branch November 7, 2022 17:52
dai-chen added a commit that referenced this pull request Nov 9, 2022
* Fix `FLOAT` -> `DOUBLE` cast. (#1025)

Signed-off-by: Yury-Fridlyand <yuryf@bitquilltech.com>

* Fix error messaging from prometheus. (#1029) (#1037)

Signed-off-by: vamsi-amazon <reddyvam@amazon.com>
(cherry picked from commit 4a9cef3)

Co-authored-by: vamsi-amazon <reddyvam@amazon.com>

* Add `query` function as alternate syntax to `query_string` function (#1010)

This maintains backwards compatibility with the v1 engine.

* Update DATE and TIME functions to parse string input as datetime (#991)

Add option to accept datetime like string in both TIME and DATE (eg. accept "1999-01-02 12:12:12" for both TIME and DATE.

Strict check on date for testing for valid dates (eg. Don't accept Feb 30th as a valid date) and throws a SemanticCheckException.

Co-authored-by: Yury-Fridlyand <yuryf@bitquilltech.com>
Signed-off-by: MitchellGale-BitQuill <mitchellg@bitquilltech.com>

* back quote fix (#1041) (#1050)

Signed-off-by: vamsi-amazon <reddyvam@amazon.com>
(cherry picked from commit d3bb902)

Co-authored-by: vamsi-amazon <reddyvam@amazon.com>

* Catalog to Datasource changes (#1027) (#1049)

Signed-off-by: vamsi-amazon <reddyvam@amazon.com>
(cherry picked from commit 3e30379)

* Bump jackson to 2.14.0 (#1058)

Signed-off-by: Joshua Li <joshuali925@gmail.com>
(cherry picked from commit 5a1adb2)

* Add valueOf() to Expression (#1055)

Signed-off-by: Joshua Li <joshuali925@gmail.com>

Signed-off-by: Yury-Fridlyand <yuryf@bitquilltech.com>
Signed-off-by: MitchellGale-BitQuill <mitchellg@bitquilltech.com>
Signed-off-by: Joshua Li <joshuali925@gmail.com>
Signed-off-by: Chen Dai <daichen@amazon.com>
Co-authored-by: Yury-Fridlyand <yuryf@bitquilltech.com>
Co-authored-by: opensearch-trigger-bot[bot] <98922864+opensearch-trigger-bot[bot]@users.noreply.github.com>
Co-authored-by: vamsi-amazon <reddyvam@amazon.com>
Co-authored-by: GabeFernandez310 <64448015+GabeFernandez310@users.noreply.github.com>
Co-authored-by: MitchellGale-BitQuill <104795536+MitchellGale-BitQuill@users.noreply.github.com>
Co-authored-by: Joshua Li <joshuali925@gmail.com>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

bug Something isn't working

Projects

None yet

Development

Successfully merging this pull request may close these issues.

[BUG] Casting a DOUBLE as a FLOAT truncates all decimal digits

5 participants