Skip to content

[3pt] Default types of SQL built-in functions #2455

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

Closed
TarantoolBot opened this issue Nov 22, 2021 · 0 comments
Closed

[3pt] Default types of SQL built-in functions #2455

TarantoolBot opened this issue Nov 22, 2021 · 0 comments
Assignees
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 Nov 22, 2021

Can be fixed by #2350

Product: Tarantool
Since: 2.10.0-beta1-257-g14aa6a597
Audience/target: dev
Root document: https://www.tarantool.io/en/doc/latest/reference/reference_sql/
SME: @ ImeevMA


In case a function takes an argument of one of two or more types, this
function has defined the default type for this argument. This type is
used when the type of the argument cannot be determined, for example, in
the case of a bound variable.

Rules for determining default types as follows:

  1. When there is only one possible type, it is default.
  2. When possible types are INTEGER, DOUBLE or DECIMAL, DECIMAL is
    default.
  3. When possible types are STRING or VARBINARY, STRING is default.
  4. When possible data types are any other scalar data type, SCALAR is
    default.
  5. Otherwise, there is no default type.
    Requested by @ImeevMA in tarantool/tarantool@14aa6a5.
@patiencedaur patiencedaur added this to the Estimate [@patiencedaur] milestone Nov 23, 2021
@patiencedaur patiencedaur added feature A new functionality reference [location] Tarantool manual, Reference part server [area] Task relates to Tarantool's server (core) functionality labels Nov 23, 2021
@patiencedaur patiencedaur changed the title Default types of SQL built-in functions [3pt] Default types of SQL built-in functions Nov 23, 2021
@patiencedaur patiencedaur removed this from the Estimate [@patiencedaur] milestone Nov 26, 2021
@pgulutzan pgulutzan self-assigned this Dec 22, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
feature A new functionality reference [location] Tarantool manual, Reference part server [area] Task relates to Tarantool's server (core) functionality
Projects
None yet
Development

No branches or pull requests

3 participants