testing_project/Documentation: reference/reference_lua/box_index/alter — English @ Weblate: tarantool> s = box.schema.create_space('test') --- ... tarantool> i = s:create

Source string Source string

English

tarantool> s = box.schema.create_space('test')
---
...
tarantool> i = s:create_index('i', {parts = {{field = 1, type = 'unsigned'}}})
---
...
tarantool> s:insert({1, 2})
---
- [1, 2]
...
tarantool> i:select()
---
- - [1, 2]
...
tarantool> i:alter({parts = {{field = 1, type = 'unsigned'}, {field = 2, type = 'unsigned'}}})
---
...
tarantool> s:insert({1, 't'})
---
- error: 'Tuple field 2 type does not match one required by operation: expected unsigned'
...

Needs editing

Skip

	English	Actions
	index_object:alter()
	Alter an index. It is legal in some circumstances to change one or more of the index characteristics, for example its type, its sequence options, its parts, and whether it is unique. Usually this causes rebuilding of the space, except for the simple case where a part's ``is_nullable`` flag is changed from ``false`` to ``true``.
	Parameters
	an :ref:`object reference <app_server-object_reference>`.
	index options (see :ref:`index_opts <index_opts_object>`)
	return
	nil
	Possible errors:
	index does not exist
	the primary-key index cannot be changed to ``{unique = false}``
	Vinyl does not support ``alter()`` of a primary-key index unless the space is empty.
	Example 1:
	You can add and remove fields that make up a primary index:
	tarantool> s = box.schema.create_space('test') --- ... tarantool> i = s:create_index('i', {parts = {{field = 1, type = 'unsigned'}}}) --- ... tarantool> s:insert({1, 2}) --- - [1, 2] ... tarantool> i:select() --- - - [1, 2] ... tarantool> i:alter({parts = {{field = 1, type = 'unsigned'}, {field = 2, type = 'unsigned'}}}) --- ... tarantool> s:insert({1, 't'}) --- - error: 'Tuple field 2 type does not match one required by operation: expected unsigned' ...
	Example 2:
	You can change index options for both memtx and vinyl spaces:
	tarantool> box.space.space55.index.primary:alter({type = 'HASH'}) --- ... tarantool> box.space.vinyl_space.index.i:alter({page_size=4096}) --- ...

Loading…

None

New source string

testing_project / Documentation: reference/reference_lua/box_index/alter — English

a year 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

a year ago

Last updated

a year ago

Source string age

a year ago

Translation file

string 14