[ https://issues.apache.org/jira/browse/IGNITE-21472?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Igor updated IGNITE-21472: -------------------------- Description: h3. Steps to reproduce: Run the next code: {code:java} try (Session session = IgniteClient.builder().addresses("localhost:10800").build().sql() .createSession();) { session.execute(null, "drop table if exists ttable"); session.execute(null, "create table ttable(" + "keyTINYINT0 TINYINT not null, " + "keySMALLINT1 SMALLINT not null, " + "keyINTEGER2 INTEGER not null, " + "keyTINYINT3 TINYINT not null, " + "val INTEGER not null, " + "primary key (keyTINYINT0, keySMALLINT1, keyINTEGER2, keyTINYINT3))"); session.execute(null, "select keyTINYINT0, keySMALLINT1, keyINTEGER2, keyTINYINT3, val from ttable " + "where keyTINYINT0 = ? AND keySMALLINT1 = ? AND keyINTEGER2 = ? AND keyTINYINT3 = ? AND val = ? ", new Object[]{(byte) -87, (short)19507, 25781820, (byte)-84, 116522}); } {code} h3. Expected: Run succesfully. *Actual:* The exception on the last statement: {code:java} org.apache.ignite.sql.SqlException: IGN-CMN-65535 TraceId:cfa96929-079c-4434-a826-1eea7d307d3f Invalid length for a tuple element: 4 at java.base/java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:710) at org.apache.ignite.internal.util.ExceptionUtils$1.copy(ExceptionUtils.java:765) at org.apache.ignite.internal.util.ExceptionUtils$ExceptionFactory.createCopy(ExceptionUtils.java:699) at org.apache.ignite.internal.util.ExceptionUtils.copyExceptionWithCause(ExceptionUtils.java:525) at org.apache.ignite.internal.util.ExceptionUtils.copyExceptionWithCauseInternal(ExceptionUtils.java:634) at org.apache.ignite.internal.util.ExceptionUtils.copyExceptionWithCause(ExceptionUtils.java:476) at org.apache.ignite.internal.sql.AbstractSession.execute(AbstractSession.java:63) at org.gridgain.ai3tests.tests.BasicAi3OperationsTest.testSaveAndGetFromCachee(BasicAi3OperationsTest.java:66) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at java.base/java.util.ArrayList.forEach(ArrayList.java:1540) at java.base/java.util.ArrayList.forEach(ArrayList.java:1540) Caused by: java.util.concurrent.CompletionException: org.apache.ignite.sql.SqlException: IGN-CMN-65535 TraceId:cfa96929-079c-4434-a826-1eea7d307d3f Invalid length for a tuple element: 4 at java.base/java.util.concurrent.CompletableFuture.encodeThrowable(CompletableFuture.java:331) at java.base/java.util.concurrent.CompletableFuture.completeThrowable(CompletableFuture.java:346) at java.base/java.util.concurrent.CompletableFuture.uniWhenComplete(CompletableFuture.java:870) at java.base/java.util.concurrent.CompletableFuture$UniWhenComplete.tryFire(CompletableFuture.java:837) at java.base/java.util.concurrent.CompletableFuture.postComplete(CompletableFuture.java:506) at java.base/java.util.concurrent.CompletableFuture.completeExceptionally(CompletableFuture.java:2088) at org.apache.ignite.internal.client.TcpClientChannel.processNextMessage(TcpClientChannel.java:419) at org.apache.ignite.internal.client.TcpClientChannel.lambda$onMessage$3(TcpClientChannel.java:238) at java.base/java.util.concurrent.ForkJoinTask$RunnableExecuteAction.exec(ForkJoinTask.java:1426) at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:290) at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1020) at java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1656) at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1594) at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:177) Caused by: org.apache.ignite.sql.SqlException: IGN-CMN-65535 TraceId:cfa96929-079c-4434-a826-1eea7d307d3f Invalid length for a tuple element: 4 at java.base/java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:710) at org.apache.ignite.internal.util.ExceptionUtils$1.copy(ExceptionUtils.java:765) at org.apache.ignite.internal.util.ExceptionUtils$ExceptionFactory.createCopy(ExceptionUtils.java:699) at org.apache.ignite.internal.util.ExceptionUtils.copyExceptionWithCause(ExceptionUtils.java:525) at org.apache.ignite.internal.client.TcpClientChannel.readError(TcpClientChannel.java:508) at org.apache.ignite.internal.client.TcpClientChannel.processNextMessage(TcpClientChannel.java:397) ... 7 more {code} was: h3. Steps to reproduce: h3. Run the next code: {code:java} try (Session session = IgniteClient.builder().addresses("localhost:10800").build().sql() .createSession();) { session.execute(null, "drop table if exists ttable"); session.execute(null, "create table ttable(" + "keyTINYINT0 TINYINT not null, " + "keySMALLINT1 SMALLINT not null, " + "keyINTEGER2 INTEGER not null, " + "keyTINYINT3 TINYINT not null, " + "val INTEGER not null, " + "primary key (keyTINYINT0, keySMALLINT1, keyINTEGER2, keyTINYINT3))"); session.execute(null, "select keyTINYINT0, keySMALLINT1, keyINTEGER2, keyTINYINT3, val from ttable " + "where keyTINYINT0 = ? AND keySMALLINT1 = ? AND keyINTEGER2 = ? AND keyTINYINT3 = ? AND val = ? ", new Object[]{(byte) -87, (short)19507, 25781820, (byte)-84, 116522}); } {code} h3. Expected: Run succesfully. *Actual:* The exception: {code:java} org.apache.ignite.sql.SqlException: IGN-CMN-65535 TraceId:cfa96929-079c-4434-a826-1eea7d307d3f Invalid length for a tuple element: 4 at java.base/java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:710) at org.apache.ignite.internal.util.ExceptionUtils$1.copy(ExceptionUtils.java:765) at org.apache.ignite.internal.util.ExceptionUtils$ExceptionFactory.createCopy(ExceptionUtils.java:699) at org.apache.ignite.internal.util.ExceptionUtils.copyExceptionWithCause(ExceptionUtils.java:525) at org.apache.ignite.internal.util.ExceptionUtils.copyExceptionWithCauseInternal(ExceptionUtils.java:634) at org.apache.ignite.internal.util.ExceptionUtils.copyExceptionWithCause(ExceptionUtils.java:476) at org.apache.ignite.internal.sql.AbstractSession.execute(AbstractSession.java:63) at org.gridgain.ai3tests.tests.BasicAi3OperationsTest.testSaveAndGetFromCachee(BasicAi3OperationsTest.java:66) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at java.base/java.util.ArrayList.forEach(ArrayList.java:1540) at java.base/java.util.ArrayList.forEach(ArrayList.java:1540) Caused by: java.util.concurrent.CompletionException: org.apache.ignite.sql.SqlException: IGN-CMN-65535 TraceId:cfa96929-079c-4434-a826-1eea7d307d3f Invalid length for a tuple element: 4 at java.base/java.util.concurrent.CompletableFuture.encodeThrowable(CompletableFuture.java:331) at java.base/java.util.concurrent.CompletableFuture.completeThrowable(CompletableFuture.java:346) at java.base/java.util.concurrent.CompletableFuture.uniWhenComplete(CompletableFuture.java:870) at java.base/java.util.concurrent.CompletableFuture$UniWhenComplete.tryFire(CompletableFuture.java:837) at java.base/java.util.concurrent.CompletableFuture.postComplete(CompletableFuture.java:506) at java.base/java.util.concurrent.CompletableFuture.completeExceptionally(CompletableFuture.java:2088) at org.apache.ignite.internal.client.TcpClientChannel.processNextMessage(TcpClientChannel.java:419) at org.apache.ignite.internal.client.TcpClientChannel.lambda$onMessage$3(TcpClientChannel.java:238) at java.base/java.util.concurrent.ForkJoinTask$RunnableExecuteAction.exec(ForkJoinTask.java:1426) at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:290) at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1020) at java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1656) at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1594) at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:177) Caused by: org.apache.ignite.sql.SqlException: IGN-CMN-65535 TraceId:cfa96929-079c-4434-a826-1eea7d307d3f Invalid length for a tuple element: 4 at java.base/java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:710) at org.apache.ignite.internal.util.ExceptionUtils$1.copy(ExceptionUtils.java:765) at org.apache.ignite.internal.util.ExceptionUtils$ExceptionFactory.createCopy(ExceptionUtils.java:699) at org.apache.ignite.internal.util.ExceptionUtils.copyExceptionWithCause(ExceptionUtils.java:525) at org.apache.ignite.internal.client.TcpClientChannel.readError(TcpClientChannel.java:508) at org.apache.ignite.internal.client.TcpClientChannel.processNextMessage(TcpClientChannel.java:397) ... 7 more {code} > Exception: Invalid length for a tuple element on prepared statement > ------------------------------------------------------------------- > > Key: IGNITE-21472 > URL: https://issues.apache.org/jira/browse/IGNITE-21472 > Project: Ignite > Issue Type: Bug > Components: sql > Affects Versions: 3.0.0-beta1 > Reporter: Igor > Priority: Major > Labels: ignite-3 > > h3. Steps to reproduce: > Run the next code: > {code:java} > try (Session session = > IgniteClient.builder().addresses("localhost:10800").build().sql() > .createSession();) { > session.execute(null, "drop table if exists ttable"); > session.execute(null, "create table ttable(" > + "keyTINYINT0 TINYINT not null, " > + "keySMALLINT1 SMALLINT not null, " > + "keyINTEGER2 INTEGER not null, " > + "keyTINYINT3 TINYINT not null, " > + "val INTEGER not null, " > + "primary key (keyTINYINT0, keySMALLINT1, keyINTEGER2, > keyTINYINT3))"); > session.execute(null, "select keyTINYINT0, keySMALLINT1, keyINTEGER2, > keyTINYINT3, val from ttable " > + "where keyTINYINT0 = ? AND keySMALLINT1 = ? AND > keyINTEGER2 = ? AND keyTINYINT3 = ? AND val = ? ", > new Object[]{(byte) -87, (short)19507, 25781820, (byte)-84, > 116522}); > } {code} > h3. Expected: > Run succesfully. > *Actual:* > The exception on the last statement: > {code:java} > org.apache.ignite.sql.SqlException: IGN-CMN-65535 > TraceId:cfa96929-079c-4434-a826-1eea7d307d3f Invalid length for a tuple > element: 4 > at > java.base/java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:710) > at > org.apache.ignite.internal.util.ExceptionUtils$1.copy(ExceptionUtils.java:765) > at > org.apache.ignite.internal.util.ExceptionUtils$ExceptionFactory.createCopy(ExceptionUtils.java:699) > at > org.apache.ignite.internal.util.ExceptionUtils.copyExceptionWithCause(ExceptionUtils.java:525) > at > org.apache.ignite.internal.util.ExceptionUtils.copyExceptionWithCauseInternal(ExceptionUtils.java:634) > at > org.apache.ignite.internal.util.ExceptionUtils.copyExceptionWithCause(ExceptionUtils.java:476) > at > org.apache.ignite.internal.sql.AbstractSession.execute(AbstractSession.java:63) > at > org.gridgain.ai3tests.tests.BasicAi3OperationsTest.testSaveAndGetFromCachee(BasicAi3OperationsTest.java:66) > at java.base/java.lang.reflect.Method.invoke(Method.java:566) > at java.base/java.util.ArrayList.forEach(ArrayList.java:1540) > at java.base/java.util.ArrayList.forEach(ArrayList.java:1540) > Caused by: java.util.concurrent.CompletionException: > org.apache.ignite.sql.SqlException: IGN-CMN-65535 > TraceId:cfa96929-079c-4434-a826-1eea7d307d3f Invalid length for a tuple > element: 4 > at > java.base/java.util.concurrent.CompletableFuture.encodeThrowable(CompletableFuture.java:331) > at > java.base/java.util.concurrent.CompletableFuture.completeThrowable(CompletableFuture.java:346) > at > java.base/java.util.concurrent.CompletableFuture.uniWhenComplete(CompletableFuture.java:870) > at > java.base/java.util.concurrent.CompletableFuture$UniWhenComplete.tryFire(CompletableFuture.java:837) > at > java.base/java.util.concurrent.CompletableFuture.postComplete(CompletableFuture.java:506) > at > java.base/java.util.concurrent.CompletableFuture.completeExceptionally(CompletableFuture.java:2088) > at > org.apache.ignite.internal.client.TcpClientChannel.processNextMessage(TcpClientChannel.java:419) > at > org.apache.ignite.internal.client.TcpClientChannel.lambda$onMessage$3(TcpClientChannel.java:238) > at > java.base/java.util.concurrent.ForkJoinTask$RunnableExecuteAction.exec(ForkJoinTask.java:1426) > at > java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:290) > at > java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1020) > at > java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1656) > at > java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1594) > at > java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:177) > Caused by: org.apache.ignite.sql.SqlException: IGN-CMN-65535 > TraceId:cfa96929-079c-4434-a826-1eea7d307d3f Invalid length for a tuple > element: 4 > at > java.base/java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:710) > at > org.apache.ignite.internal.util.ExceptionUtils$1.copy(ExceptionUtils.java:765) > at > org.apache.ignite.internal.util.ExceptionUtils$ExceptionFactory.createCopy(ExceptionUtils.java:699) > at > org.apache.ignite.internal.util.ExceptionUtils.copyExceptionWithCause(ExceptionUtils.java:525) > at > org.apache.ignite.internal.client.TcpClientChannel.readError(TcpClientChannel.java:508) > at > org.apache.ignite.internal.client.TcpClientChannel.processNextMessage(TcpClientChannel.java:397) > ... 7 more {code} -- This message was sent by Atlassian Jira (v8.20.10#820010)