[IGNITE-23192] Sql. Arithmetic operations failed with "out of range" exception.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 3.0.0-beta1
• Fix Version/s: 3.0
• Component/s: sql
• Labels: ignite-3
• Assignee: Evgeny Stanilovsky
• Reporter: Evgeny Stanilovsky
• Created: 11/Sep/24 13:11
• Updated: 03/Oct/24 16:57
• Resolved: 03/Oct/24 16:56

Description

        sql("CREATE TABLE t(key int primary key, c1 tinyint, c2 tinyint)");
        sql("INSERT INTO t VALUES(1, 100, 100)");
        sql("SELECT c1 + c2 from t");
// the same:
        sql("SELECT c1 * c2 from t");
// will fail but need different insertion: INSERT INTO t VALUES(1, -100, 100)
        sql("SELECT c1 - c2 from t");

Failed with :
"TINYINT out of range" exception, seems the same for int16 and int 32 types

Issue Links

• Dependency: IGNITE-23141 Sql. Add execution test to verify numeric type coercion in binary comparison and arithmetic
• is blocked by: IGNITE-23183 Sql. Assertion error when validating an UPDATE query with a subquery expression
• relates to: IGNITE-23243 .NET: LINQ: Value was either too large or too small for a Decimal
• links to: GitHub Pull Request #4422