SQL: document changes in parsing rules #3243
Description
Product: Tarantool
Since: 2.11
Root document: https://www.tarantool.io/en/doc/latest/reference/reference_sql/sql_statements_and_clauses/#table-constraint-definition-for-foreign-keys
SME: @ ImeevMA
Details
Three rules related to foreign keys have been removed.
The first is the "reference trigger action" rule, which determines the
behavior when a referenced tuple is deleted. This rule has been dropped
because the new foreign keys only support RESTRICT.
The second is "constraint check time" rule, which determines when a
foreign key constraint should be validated. This rule has been dropped
because the new foreign keys only support INITIALLY IMMEDIATELY.
The third is "match type" rule, which determines how inserted values are
validated. This rule has been dropped because the new foreign keys only
support FULL.
Requested by @ImeevMA in tarantool/tarantool@5ab45ba.
- RESTRICT
- INITIALLY IMMEDIATE
- MATCH FULL