[IGNITE-18673] Sql. Negative column indexes in ORDER BY clause are not rejected

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: 3.0.0-beta2
• Component/s: sql
• Labels: calcite2-required calcite3-required ignite-3
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Unassigned
• Reporter: Maksim Zhuravkov
• Created: 30/Jan/23 13:07
• Updated: 08/Feb/23 06:46

Description

The simple example:

SELECT * FROM test ORDER BY -1

See test_order_by_exceptions.test.

Add statement error: <err message> to other test cases as well.

It seems that this issue is caused the current implementation of IgniteSqlValidator::validateLiteral which skips the validation entirely

@Override
public void validateLiteral(SqlLiteral literal) {
    if (literal.getTypeName() != SqlTypeName.DECIMAL) {
        super.validateLiteral(literal);
    }
}