Skip to content

[3pt] SCALAR and NUMBER values in SQL #2295

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.

Sign up for GitHub

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

Jump to bottom
Closed
TarantoolBot opened this issue Aug 18, 2021 · 1 comment · Fixed by #2350
Closed

[3pt] SCALAR and NUMBER values in SQL #2295

TarantoolBot opened this issue Aug 18, 2021 · 1 comment · Fixed by #2350
Assignees
@pgulutzan
Labels
feature A new functionality reference [location] Tarantool manual, Reference part server [area] Task relates to Tarantool's server (core) functionality

Comments

@TarantoolBot
Copy link
Collaborator

TarantoolBot commented Aug 18, 2021 •
edited by xuniq
Loading

Scalar and number values in SQL

Product: Tarantool
Since: 2.10.0-beta1
Root document: ? https://www.tarantool.io/en/doc/latest/reference/reference_sql/
SME: @ ImeevMA
Peer reviewer: @

Details

SCALAR values can now be compared with values of any other scalar type,
but cannot be implicitly cast to any other scalar type. This means that
SCALAR values cannot participate in arithmetic, bitwise operations,
concatenation, or functions that, by definition, do not accept SCALAR
values.

NUMBER values now also cannot be implicitly cast to any other numeric
type, which means that NUMBER values cannot participate in arithmetic
and bitwise operations, or in functions that, by definition, do not
accept NUMBER values.
Requested by @ImeevMA in tarantool/tarantool@bd320d3.
@pgulutzan
Copy link
Contributor

This is one of many changes from @ImeevMA that affect SQL.
I think they should be done together.
See new doc issue: #2296 Behavior Changes In SQL.

@xuniq xuniq added this to the Estimate [@xuniq] milestone Sep 1, 2021
@xuniq xuniq added feature A new functionality reference [location] Tarantool manual, Reference part need feedback [special status] On hold, awaiting feedback and removed reference [location] Tarantool manual, Reference part labels Sep 3, 2021
@xuniq xuniq added reference [location] Tarantool manual, Reference part server [area] Task relates to Tarantool's server (core) functionality and removed need feedback [special status] On hold, awaiting feedback labels Sep 29, 2021
@xuniq xuniq changed the title SCALAR and NUMBER values in SQL [3pt?] SCALAR and NUMBER values in SQL Sep 29, 2021
@xuniq xuniq changed the title [3pt?] SCALAR and NUMBER values in SQL [3pt] SCALAR and NUMBER values in SQL Sep 29, 2021
@xuniq xuniq removed this from the Estimate [@xuniq] milestone Sep 29, 2021
@pgulutzan pgulutzan mentioned this issue Oct 21, 2021
Merged
patiencedaur added a commit that referenced this issue Dec 22, 2021
@pgulutzan @alexandra-mara @patiencedaur
Fixes gh-2206 Behavior changes in SQL (#2350)
cfb2984 
Resolves #2295, #2296, #2298

Written by Peter Gulutzan
Translated by Alexandra Mirzuitova, translation reviewed by Patience Daur

Co-authored-by: Peter Gulutzan <[email protected]>
Co-authored-by: Alexandra Mirzuitova <[email protected]>
Co-authored-by: Patience Daur <[email protected]>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@pgulutzan pgulutzan

Labels
feature A new functionality reference [location] Tarantool manual, Reference part server [area] Task relates to Tarantool's server (core) functionality
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Fixes gh-2206 Behavior changes in SQL tarantool/doc
3 participants
@pgulutzan @TarantoolBot @xuniq