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
Attachments
Issue Links
- Dependency
-
IGNITE-23141 Sql. Add execution test to verify numeric type coercion in binary comparison and arithmetic
-
- Resolved
-
- is blocked by
-
IGNITE-23183 Sql. Assertion error when validating an UPDATE query with a subquery expression
-
- Open
-
- relates to
-
-
- Open
-
- links to
