Roman Khabibov
authored
Enable to add column to existing space with <ALTER TABLE ADD [COLUMN]> statement. Column definition can be supplemented with the four types of constraints, <DEFAULT>, <COLLATE> clauses and <[NOT] NULL>, AUTOINCREMENT. Closes #2349, #3075 @TarantoolBot document Title: Add columns to existing tables in SQL Now, it is possible to add columns to existing empty spaces using <ALTER TABLE table_name ADD [COLUMN] column_name column_type ...> statement. The column definition is the same as in <CREATE TABLE> statement. * Space emptiness is Tarantool's restriction. Possibilty to add column to non empty space will be implemented later. For example: ``` tarantool> box.execute("CREATE TABLE test (a INTEGER PRIMARY KEY)") --- - row_count: 1 ... tarantool> box.execute([[ALTER TABLE test ADD COLUMN b TEXT > CHECK (LENGTH(b) > 1) > NOT NULL > DEFAULT ('aa') > COLLATE "unicode_ci" > ]]) --- - row_count: 1 ... ```
Name | Last commit | Last update |
---|---|---|
.. | ||
dist | ||
dmg | ||
luarocks | ||
tf | ||
CMakeLists.txt | ||
addopcodes.sh | ||
apigen | ||
bin2c.c | ||
lemon.c | ||
lempar.c | ||
mkkeywordhash.c | ||
mkopcodec.sh | ||
mkopcodeh.sh | ||
org.tarantool.in | ||
txt2c.c |