tarantool / tarantool/doc

column default value in SQL

Open
#5,705 1 comment 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
CSS
Stars
15
Forks
49
Avg merge
1d 13h
Merged PRs (30d)
3

Description

The default value for a column in SQL is set using the DEFAULT keyword.
The expression following this keyword will be evaluated as the default
value or a function that evaluates to that value. If the expression is
a literal, it will be evaluated as a value. Also, if the expression is
a unary + or - and the following literal is of type INTEGER,
DOUBLE, or DECIMAL, it will also be evaluated as a value.
Otherwise, it will be evaluated as a function.
Requested by @ImeevMA in https://github.com/tarantool/tarantool/commit/78e0faa1bdc2e014a73550cac32ae0a4c46f1a37.

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by reviewing the documentation repository and the linked Tarantool commit 78e0faa1bdc2e014a73550cac32ae0a4c46f1a37 to locate the relevant SQL documentation entry point. Done means documenting how DEFAULT expressions are evaluated for literals, unary numeric literals, and functions.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
Domain
databases, documentation
Issue type
Documentation
Difficulty
2/5
Estimated time
1-3 hours
Activity status
Quiet
Clarity
Needs clarification
Newbie friendliness
52/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.