Describe SQL CASE operation

[xuniq]

dev issue/commit: tarantool/tarantool@5585825

Product: Tarantool
Root document: https://www.tarantool.io/en/doc/latest/reference/reference_sql/sql-features/#f261-case-expression
https://www.tarantool.io/en/doc/latest/reference/reference_sql/sql_statements_and_clauses
SME: @ ImeevMA
Estimation:

Connected with #2825

Details

TBD

Update from #3184

New rules are applied to determine the type of the CASE operation. If
all values are NULL with no type, or if a bind variable exists among
the possible results, then the type of CASE is ANY. Otherwise, all NULL
values with no type are ignored, and the type of CASE is determined
using the following rules:

1. if all values of the same type, then type of CASE is this type;
2. otherwise, if any of the possible results is of one of the
   incomparable types, then the type of CASE is ANY;
3. otherwise, if any of the possible results is of one of the
   non-numeric types, then the type of CASE is SCALAR;
4. otherwise, if any of the possible results is of type NUMBER, then the
   type of CASE is NUMBER;
5. otherwise, if any of the possible results is of type DECIMAL, then
   the type of CASE is DECIMAL;
6. otherwise, if any of the possible results is of type DOUBLE, then the
   type of CASE is DOUBLE;
7. otherwise the type of CASE is INTEGER.
   Requested by @ ImeevMA in tarantool/tarantool@90f6446.