testing_project

Documentation: reference/reference_lua/box_schema_sequence/create_index

Russian

Translate

Zen

Translation

English

Russian

Needs editing

Skip

	English	Russian	Actions
	specifying a sequence in create_index()	использование последовательностей в create_index()
	You can use the :samp:`sequence={sequence-name}` (or :samp:`sequence={sequence-id}` or :samp:`sequence=true`) option when :ref:`creating <box_space-create_index>` or :doc:`altering </reference/reference_lua/box_index/alter>` a primary-key index. The sequence becomes associated with the index, so that the next ``insert()`` will put the next generated number into the primary-key field, if the field would otherwise be nil.	Можно использовать опцию :samp:`sequence={имя-последовательности}` (или :samp:`sequence={id-последовательности}`, или :samp:`sequence=true`) при :ref:`создании <box_space-create_index>` или :doc:`изменении </reference/reference_lua/box_index/alter>` первичного индекса. Происходит ассоциация последовательности с индексом, так что следующий вызов ``insert()`` поместит следующее сгенерированное число в поле первичного ключа, если в противном случае поле было бы nil.
	The syntax may be any of: \|br\| :samp:`sequence = {sequence identifier}` \|br\| or :code:`sequence = {id =` :samp:`{sequence identifier}` :code:`}` \|br\| or :code:`sequence = {field =` :samp:`{field number}` :code:`}` \|br\| or :code:`sequence = {id =` :samp:`{sequence identifier}` :code:`, field =` :samp:`{field number}` :code:`}` \|br\| or :code:`sequence = true` \|br\| or :code:`sequence = {}`. \|br\| The sequence identifier may be either a number (the sequence id) or a string (the sequence name). The field number may be the ordinal number of any field in the index; default = 1. Examples of all possibilities: ``sequence = 1`` or ``sequence = 'sequence_name'`` or ``sequence = {id = 1}`` or ``sequence = {id = 'sequence_name'}`` or ``sequence = {id = 1, field = 1}`` or ``sequence = {id = 'sequence_name', field = 1}`` or ``sequence = {field = 1}`` or ``sequence = true`` or ``sequence = {}``. Notice that the sequence identifier can be omitted, if it is omitted then a new sequence is created automatically with default name = :samp:`{space-name}_seq`. Notice that the field number does not have to be 1, that is, the sequence can be associated with any field in the primary-key index.
	For example, if 'Q' is a sequence and 'T' is a new space, then this will work:	Например, если 'Q' -- это последовательность, а 'T' -- это новый спейс, то сработает:
	tarantool> box.space.T:create_index('Q',{sequence='Q'}) --- - unique: true parts: - type: unsigned is_nullable: false fieldno: 1 sequence_id: 8 id: 0 space_id: 514 name: Q type: TREE ...	tarantool> box.space.T:create_index('Q',{sequence='Q'}) --- - unique: true parts: - type: unsigned is_nullable: false fieldno: 1 sequence_id: 8 id: 0 space_id: 514 name: Q type: TREE ...
	(Notice that the index now has a ``sequence_id`` field.)	(Обратите внимание, что теперь в индексе есть поле идентификатора последовательности ``sequence_id``.)
	And this will work:	И сработает:
	tarantool> box.space.T:insert{box.NULL,0} --- - [1, 0] ...	tarantool> box.space.T:insert{box.NULL,0} --- - [1, 0] ...
	The index key type may be either 'integer' or 'unsigned'. If any of the sequence options is a negative number, then the index key type should be 'integer'.
	Users should not insert a value greater than 9223372036854775807, which is 2^63 - 1, in the indexed field. The sequence generator will ignore it.
	A sequence cannot be dropped if it is associated with an index. However, :ref:`index_object:alter() <box_index-alter>` can be used to say that a sequence is not associated with an index, for example ``box.space.T.index.I:alter({sequence=false})``.	Последовательность нельзя удалить, если она связана с индексом. Тем не менее, можно использовать :ref:`index_object:alter() <box_index-alter>`, чтобы показать, что последовательность не связана с индексом, например так ``box.space.T.index.I:alter({sequence=false})``.
	If a sequence was created automatically because the sequence identifier was omitted, then it will be dropped automatically if the index is altered so that ``sequence=false``, or if the index is dropped.
	``index_object:alter()`` can also be used to associate a sequence with an existing index, with the same syntax for options.
	When a sequence is used with an index based on a JSON path, inserted tuples must have all components of the path preceding the autoincrement field, and the autoincrement field. To achieve that use ``box.NULL`` rather than ``nil``. Example:
	s = box.schema.space.create('test') s:create_index('pk', {parts = {{'[1].a.b[1]', 'unsigned'}}, sequence = true}) s:replace{} -- error s:replace{{c = {}}} -- error s:replace{{a = {c = {}}}} -- error s:replace{{a = {b = {}}}} -- error s:replace{{a = {b = {nil}}}} -- error s:replace{{a = {b = {box.NULL}}}} -- ok

Loading…

None

String updated in the repository

testing_project / Documentation: reference/reference_lua/box_schema_sequence/create_index — Russian

English

Russian 208 characters edited Current translation Translated

a year ago

Browse all string changes

Things to check

Unchanged translation

Source and translation are identical

Glossary

English	Russian
No related strings found in the glossary.

String information

String age

a year ago

Last updated

a year ago

Source string age

a year ago

Translation file

locale/ru/LC_MESSAGES/reference/reference_lua/box_schema_sequence/create_index.po, string 5