[ https://issues.apache.org/jira/browse/IGNITE-20724?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Pavel Pereslegin updated IGNITE-20724: -------------------------------------- Fix Version/s: 3.0.0-beta2 > Exception "Type conversion is not supported yet" after "ALTER TABLE DROP > COLUMN" > -------------------------------------------------------------------------------- > > Key: IGNITE-20724 > URL: https://issues.apache.org/jira/browse/IGNITE-20724 > Project: Ignite > Issue Type: Bug > Components: sql > Affects Versions: 3.0.0-beta2 > Reporter: Igor > Assignee: Pavel Pereslegin > Priority: Major > Labels: ignite-3 > Fix For: 3.0.0-beta2 > > Time Spent: 10m > Remaining Estimate: 0h > > *Steps to reproduce:* > Run the next sequence of separate queries one by one (via JDBC or ODBC) > {code:java} > DROP TABLE IF EXISTS CAR; > CREATE TABLE CAR(ID INT, PARKINGID INT NOT NULL, NAME VARCHAR(255), CITY > VARCHAR(20), PRIMARY KEY (ID, PARKINGID)); > CREATE INDEX CAR_NAME_IDX ON PUBLIC.CAR(NAME); > INSERT INTO PUBLIC.CAR(ID, PARKINGID, NAME, CITY) VALUES(1, 0, 'car_1', 'New > York'); > ALTER TABLE PUBLIC.CAR ADD COLUMN MODEL_ID INT; > ALTER TABLE PUBLIC.CAR ADD COLUMN COUNTRY VARCHAR DEFAULT 'USA'; > ALTER TABLE PUBLIC.CAR DROP COLUMN MODEL_ID; > SELECT * FROM PUBLIC.CAR WHERE ID <= 10 OR ID > 1000 ORDER BY ID;{code} > *Expected result:* > Every command run successfully. > *Actual result:* > The last one throws exception > {code:java} > java.sql.SQLException: Type conversion is not supported yet. > at > org.apache.ignite.internal.jdbc.proto.IgniteQueryErrorCode.createJdbcSqlException(IgniteQueryErrorCode.java:57) > at > org.apache.ignite.internal.jdbc.JdbcStatement.execute0(JdbcStatement.java:149) > at > org.apache.ignite.internal.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:108) > ....{code} > Exceptions from servers: > Server1: > {code:java} > 2023-10-23 22:00:38:287 +0200 > [INFO][%BasicAi3OperationsTest_cluster_0%sql-execution-pool-3][JdbcQueryEventHandlerImpl] > Exception while executing query [query=SELECT * FROM PUBLIC.CAR WHERE ID <= > 10 OR ID > 1000 ORDER BY ID;] > org.apache.ignite.sql.SqlException: IGN-CMN-65535 > TraceId:034a6b87-a7b3-408d-b41f-a5914ffec30d Type conversion is not supported > yet. > at > org.apache.ignite.internal.lang.SqlExceptionMapperUtil.mapToPublicSqlException(SqlExceptionMapperUtil.java:59) > at > org.apache.ignite.internal.sql.engine.AsyncSqlCursorImpl.wrapIfNecessary(AsyncSqlCursorImpl.java:101) > at > org.apache.ignite.internal.sql.engine.AsyncSqlCursorImpl.lambda$requestNextAsync$0(AsyncSqlCursorImpl.java:77) > at > java.base/java.util.concurrent.CompletableFuture.uniHandle(CompletableFuture.java:934) > at > java.base/java.util.concurrent.CompletableFuture$UniHandle.tryFire(CompletableFuture.java:911) > at > java.base/java.util.concurrent.CompletableFuture.postComplete(CompletableFuture.java:510) > at > java.base/java.util.concurrent.CompletableFuture.completeExceptionally(CompletableFuture.java:2162) > at > org.apache.ignite.internal.sql.engine.exec.rel.AsyncRootNode.lambda$closeAsync$0(AsyncRootNode.java:160) > at > java.base/java.util.concurrent.ConcurrentLinkedQueue.forEachFrom(ConcurrentLinkedQueue.java:1037) > at > java.base/java.util.concurrent.ConcurrentLinkedQueue.forEach(ConcurrentLinkedQueue.java:1054) > at > org.apache.ignite.internal.sql.engine.exec.rel.AsyncRootNode.closeAsync(AsyncRootNode.java:160) > at > org.apache.ignite.internal.sql.engine.exec.rel.AsyncRootNode.onError(AsyncRootNode.java:115) > at > org.apache.ignite.internal.sql.engine.exec.ExecutionServiceImpl$DistributedQueryManager.lambda$onError$2(ExecutionServiceImpl.java:530) > at > java.base/java.util.concurrent.CompletableFuture.uniAcceptNow(CompletableFuture.java:757) > at > java.base/java.util.concurrent.CompletableFuture.uniAcceptStage(CompletableFuture.java:735) > at > java.base/java.util.concurrent.CompletableFuture.thenAccept(CompletableFuture.java:2182) > at > org.apache.ignite.internal.sql.engine.exec.ExecutionServiceImpl$DistributedQueryManager.onError(ExecutionServiceImpl.java:529) > at > org.apache.ignite.internal.sql.engine.exec.ExecutionServiceImpl.onMessage(ExecutionServiceImpl.java:381) > at > org.apache.ignite.internal.sql.engine.exec.ExecutionServiceImpl.lambda$start$4(ExecutionServiceImpl.java:220) > at > org.apache.ignite.internal.sql.engine.message.MessageServiceImpl.onMessageInternal(MessageServiceImpl.java:139) > at > org.apache.ignite.internal.sql.engine.message.MessageServiceImpl.lambda$onMessage$1(MessageServiceImpl.java:110) > at > org.apache.ignite.internal.sql.engine.exec.QueryTaskExecutorImpl.lambda$execute$0(QueryTaskExecutorImpl.java:81) > at > java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) > at > java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) > at java.base/java.lang.Thread.run(Thread.java:833) > Caused by: org.apache.ignite.lang.IgniteException: IGN-CMN-65535 > TraceId:034a6b87-a7b3-408d-b41f-a5914ffec30d Type conversion is not supported > yet. > at > org.apache.ignite.internal.sql.engine.util.SqlExceptionMapperProvider.lambda$mappers$1(SqlExceptionMapperProvider.java:53) > at > org.apache.ignite.internal.lang.IgniteExceptionMapper.map(IgniteExceptionMapper.java:61) > at > org.apache.ignite.internal.lang.IgniteExceptionMapperUtil.map(IgniteExceptionMapperUtil.java:149) > at > org.apache.ignite.internal.lang.IgniteExceptionMapperUtil.mapToPublicException(IgniteExceptionMapperUtil.java:103) > at > org.apache.ignite.internal.lang.SqlExceptionMapperUtil.mapToPublicSqlException(SqlExceptionMapperUtil.java:49) > ... 24 more > Caused by: > org.apache.ignite.internal.sql.engine.exec.RemoteFragmentExecutionException: > IGN-CMN-65535 TraceId:034a6b87-a7b3-408d-b41f-a5914ffec30d Type conversion is > not supported yet. > at > org.apache.ignite.internal.sql.engine.exec.ExecutionServiceImpl.onMessage(ExecutionServiceImpl.java:374) > ... 7 more{code} > Server2: > {code:java} > 2023-10-23 22:00:38:281 +0200 > [INFO][%BasicAi3OperationsTest_cluster_1%sql-execution-pool-3][ExchangeServiceImpl] > Failed to execute query fragment: > queryId=fd1b195c-35b9-4617-8dba-a24275f21a94, fragmentId=4 > org.apache.ignite.internal.schema.SchemaException: IGN-CMN-65535 > TraceId:034a6b87-a7b3-408d-b41f-a5914ffec30d Type conversion is not supported > yet. > at > org.apache.ignite.internal.schema.registry.UpgradingRowAdapter.stringValue(UpgradingRowAdapter.java:331) > at > org.apache.ignite.internal.schema.BinaryTupleSchema.value(BinaryTupleSchema.java:316) > at > org.apache.ignite.internal.sql.engine.util.FieldDeserializingProjectedTuple.normalize(FieldDeserializingProjectedTuple.java:69) > at > org.apache.ignite.internal.sql.engine.util.AbstractProjectedTuple.normalizeIfNeeded(AbstractProjectedTuple.java:223) > at > org.apache.ignite.internal.sql.engine.util.AbstractProjectedTuple.byteBuffer(AbstractProjectedTuple.java:203) > at > org.apache.ignite.internal.sql.engine.util.FieldDeserializingProjectedTuple.byteBuffer(FieldDeserializingProjectedTuple.java:38) > at > org.apache.ignite.internal.sql.engine.exec.SqlRowHandler$BinaryTupleRowWrapper.toByteBuffer(SqlRowHandler.java:378) > at > org.apache.ignite.internal.sql.engine.exec.SqlRowHandler.toByteBuffer(SqlRowHandler.java:142) > at > org.apache.ignite.internal.sql.engine.exec.SqlRowHandler.toByteBuffer(SqlRowHandler.java:65) > at > org.apache.ignite.internal.sql.engine.exec.rel.Outbox.sendBatch(Outbox.java:242) > at > org.apache.ignite.internal.sql.engine.exec.rel.Outbox$RemoteDownstream.sendBatch(Outbox.java:529) > at > org.apache.ignite.internal.sql.engine.exec.rel.Outbox$RemoteDownstream.end(Outbox.java:551) > at > org.apache.ignite.internal.sql.engine.exec.rel.Outbox.flush(Outbox.java:325) > at org.apache.ignite.internal.sql.engine.exec.rel.Outbox.end(Outbox.java:175) > at > org.apache.ignite.internal.sql.engine.exec.rel.SortNode.flush(SortNode.java:205) > at > org.apache.ignite.internal.sql.engine.exec.rel.SortNode.end(SortNode.java:154) > at > org.apache.ignite.internal.sql.engine.exec.rel.StorageScanNode.push(StorageScanNode.java:165) > at > org.apache.ignite.internal.sql.engine.exec.rel.StorageScanNode$SubscriberImpl.lambda$onComplete$2(StorageScanNode.java:246) > at > org.apache.ignite.internal.sql.engine.exec.ExecutionContext.lambda$execute$0(ExecutionContext.java:315) > at > org.apache.ignite.internal.sql.engine.exec.QueryTaskExecutorImpl.lambda$execute$0(QueryTaskExecutorImpl.java:81) > at > java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) > at > java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) > at java.base/java.lang.Thread.run(Thread.java:833){code} -- This message was sent by Atlassian Jira (v8.20.10#820010)