Igor created IGNITE-20724:
-----------------------------
Summary: 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
*Steps to reproduce:*
Run the next sequence of separate queries one by one
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;
*Expected result:*
Every command run successfully.
*Actual result:*
The last one throws exception
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)
....Exceptions from servers:
Server1:
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 moreServer2:
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)
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
