You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Maksim Zhuravkov (Jira)" <ji...@apache.org> on 2023/05/16 08:32:00 UTC
[jira] [Created] (IGNITE-19481) Sql. Inconsistent behaviour of DML operations. VARCHAR column = 1
Maksim Zhuravkov created IGNITE-19481:
-----------------------------------------
Summary: Sql. Inconsistent behaviour of DML operations. VARCHAR column = 1 <lit>
Key: IGNITE-19481
URL: https://issues.apache.org/jira/browse/IGNITE-19481
Project: Ignite
Issue Type: Bug
Components: sql
Affects Versions: 3.0.0-beta1
Reporter: Maksim Zhuravkov
INSERT:
{code:java}
@Test
public void testInsertIntToStr() {
sql("CREATE TABLE t1(int_col INTEGER PRIMARY KEY, str_col VARCHAR)");
sql("INSERT INTO t1 VALUES(1, 2)");
}
{code}
Result: OK
UPDATE:
{code:java}
@Test
public void testUpdateIntToStr() {
sql("CREATE TABLE t1(int_col INTEGER PRIMARY KEY, str_col VARCHAR)");
sql("INSERT INTO t1 VALUES(1, '11111')");
sql("UPDATE t1 SET str_col=1");
}
{code}
Error:
{code:java}
TraceId:3b57d830-a327-4c77-89ec-a45a1411daf6 class java.lang.Integer cannot be cast to class java.lang.String (java.lang.Integer and java.lang.String are in module java.base of loader 'bootstrap')
{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)