[jira] [Commented] (IGNITE-26491) Inconsistent behavior of thin/embedded client when reading tuple value

["Pavel Tupitsyn (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/IGNITE-26491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18023748#comment-18023748 ] 

Pavel Tupitsyn commented on IGNITE-26491:
-----------------------------------------

More notes:
* The validation does not exist at all in embedded mode (*MutableRowTupleAdapter*). I can also do *embeddedReturnedVal.stringValue("VAL")* and it gives back some garbage string.
* Thin client validation is probably too strict (*MutableTupleBinaryTupleAdapter#validateSchemaColumnType*), we can easily allow reading int as long, long as int etc

> Inconsistent behavior of thin/embedded client when reading tuple value
> ----------------------------------------------------------------------
>
>                 Key: IGNITE-26491
>                 URL: https://issues.apache.org/jira/browse/IGNITE-26491
>             Project: Ignite
>          Issue Type: Bug
>          Components: sql ai3
>            Reporter: Pavel Pereslegin
>            Priority: Major
>              Labels: ignite-3
>
> The behavior of the embedded client is inconsistent with the thin client when trying to read a narrower integer type from tuple that contains long value.
> For example, when we have table with bigint column val.
> {code:sql}
> create table test_int (id bigint primary key, val bigint not null)
> {code}
> Getting existing row from view
> {code:java}
> tuple = kvVIew.get(null, key);
> {code}
> the next
> {code:java}
> tuple.intValue("VAL") 
> {code}
> in thin client produces
> {noformat}
> ClassCastException: Column with name 'VAL' has type INT64 but INT32 was requested
> {noformat}
> but does not produces any errors in embedded client.
> (need to check the same case with record view also)
> Full reproducer
> {code:java}
>         sql("create table test_int (id bigint primary key, val bigint)");
>         KeyValueView<Tuple, Tuple> kvVIew = client.tables().table("test_int").keyValueView();
>         KeyValueView<Tuple, Tuple> kvVIewEmbedded = CLUSTER.aliveNode().tables().table("test_int").keyValueView();
>         Tuple key = Tuple.create().set("id", 1L);
>         Tuple val = Tuple.create().set("val", 1L);
>         kvVIew.put(null, key, val);
>         Tuple thinReturnedVal = kvVIew.get(null, key);
>         Tuple embeddedReturnedVal = kvVIewEmbedded.get(null, key);
>         assertEquals(1, embeddedReturnedVal.longValue(0));
>         assertEquals(1, thinReturnedVal.longValue(0));
>         // The following statement should fail, but does not fail.
>         assertEquals(1, embeddedReturnedVal.intValue("VAL"));
>         // The following statement fails with ClassCastException.
>         assertEquals(1, thinReturnedVal.intValue("VAL"));
> {code}
> Exception stacktrace:
> {noformat}
> java.lang.ClassCastException: Column with name 'VAL' has type INT64 but INT32 was requested
> 	at org.apache.ignite.internal.client.table.MutableTupleBinaryTupleAdapter.binaryTupleIndex(MutableTupleBinaryTupleAdapter.java:468)
> 	at org.apache.ignite.internal.client.table.MutableTupleBinaryTupleAdapter.validateSchemaColumnType(MutableTupleBinaryTupleAdapter.java:477)
> 	at org.apache.ignite.internal.client.table.MutableTupleBinaryTupleAdapter.intValue(MutableTupleBinaryTupleAdapter.java:202)
> {noformat}
> It is necessary to determine which behavior is correct and eliminate inconsistencies.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)