field default value in SQL

[TarantoolBot]

Product: Tarantool
Since: 3.0
Root document: https://www.tarantool.io/en/doc/latest/reference/reference_sql/sql_statements_and_clauses/
SME: @ ImeevMA

Details

SQL now uses the default mechanism for BOX fields. The main difference
visible to the user is that now all NULL values explicitly inserted into
a field with a default value will be replaced with a default value,
which is different from the original SQL behavior. Additionally, default
values are now inserted instead of NULL after the SQL BEFORE INSERT
trigger but before the BOX BEFORE INSERT trigger. Previously,
SQL default values were inserted before the SQL BEFORE INSERT trigger.
Requested by @ImeevMA in tarantool/tarantool@6cb86dc.