The translation is temporarily closed for contributions due to maintenance, please come back later.
The translation was automatically locked due to following alerts: Could not merge the repository.
Zen

Source string Source string

177/10000 · 177
English Actions
false
cycle=true
**cache**
Integer. The number of values to store in a cache
0
cache=0
**step**
Integer. What to add to the previous generated value, when generating a new value
step=-1
**if_not_exists**
Boolean. If this is true and a sequence with this name exists already, ignore other options and use the existing values
if_not_exists=true
Once a sequence exists, it can be altered, dropped, reset, forced to generate the next value, or associated with an index.
Associating a sequence with an index
For an initial example, we generate a sequence named 'S'.
tarantool> box.schema.sequence.create('S',{min=5, start=5})
---
- step: 1
id: 5
min: 5
cache: 0
uid: 1
max: 9223372036854775807
cycle: false
name: S
start: 5
...
The result shows that the new sequence has all default values, except for the two that were specified, ``min`` and ``start``.
Then we get the next value, with the ``next()`` function.
tarantool> box.sequence.S:next()
---
- 5
...
The result is the same as the start value. If we called ``next()`` again, we would get 6 (because the previous value plus the step value is 6), and so on.
Then we create a new table and specify that its primary key should be generated from the sequence.
tarantool> s=box.schema.space.create('T')
---
...
tarantool> s:create_index('I',{sequence='S'})
---
- parts:
- type: unsigned
is_nullable: false
fieldno: 1
sequence_id: 1
id: 0
space_id: 520
unique: true
type: TREE
sequence_fieldno: 1
name: I
...
---
...
Then we insert a tuple without specifying a value for the primary key.
tarantool> box.space.T:insert{nil,'other stuff'}
---
- [6, 'other stuff']
...
The result is a new tuple where the first field has a value of 6. This arrangement, where the system automatically generates the values for a primary key, is sometimes called "auto-incrementing" or "identity".
For syntax and implementation details, see the reference for :doc:`box.schema.sequence </reference/reference_lua/box_schema_sequence>`.

Loading…

User avatar None

New source string

testing_project / Documentation: how-to/other/sequences — English

tarantool> box.schema.sequence.create('S',{min=5, start=5})
---
- step: 1
id: 5
min: 5
cache: 0
uid: 1
max: 9223372036854775807
cycle: false
name: S
start: 5
...
2 years ago
Browse all string changes

Things to check

Ellipsis

The string uses three dots (...) instead of an ellipsis character (…)

Reset

Glossary

English English
No related strings found in the glossary.

String information

Flags
read-only
String age
2 years ago
Last updated
2 years ago
Source string age
2 years ago
Translation file
string 38