Different sorting order in SELECT statements with LIMIT clause

[art-dr]

Product: Tarantool
Since: 2.10.0
Root document: tbd
SME: @ImeevMA @ msiomkin
dev issue: tarantool/tarantool#6664

Details

tbd

[pgulutzan]

This apparently refers to the statement https://www.tarantool.io/en/doc/latest/reference/reference_sql/sql_statements_and_clauses/#sql-select
"If ORDER BY … LIMIT is used, then all order-by columns must be ASC or all must be DESC." So we can either remove that, or add "Before Tarantool version x.xx, ...". Issue 6664 has no milestone so we can't yet be sure about the version.