General error: "java.lang.ArrayIndexOutOfBoundsException: 1";

[icode]

test ignite version: 8.7.15 ~ 8.7.27

enable sqlOffloadingEnabled has this error

select avg(DATEDIFF('MILLISECOND', STARTTIME, ENDTIME)) from SYNCTASK where ENDTIME IS NOT NULL

Failed to run reduce query locally. General error: "java.lang.ArrayIndexOutOfBoundsException: 1"; SQL statement:
SELECT
CAST((CAST(SUM(("__C0_0" * "__C0_1")) AS BIGINT) / CAST(SUM("__C0_1") AS BIGINT)) AS BIGINT) AS "__C0_0"
FROM "PUBLIC"."__T0" [50000-199]
javax.cache.CacheException: Failed to run reduce query locally. General error: "java.lang.ArrayIndexOutOfBoundsException: 1"; SQL statement:
SELECT
CAST((CAST(SUM(("__C0_0" * "__C0_1")) AS BIGINT) / CAST(SUM("__C0_1") AS BIGINT)) AS BIGINT) AS "__C0_0"
FROM "PUBLIC"."__T0" [50000-199]
	at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.query(GridReduceQueryExecutor.java:582)
	at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$7.iterator(IgniteH2Indexing.java:1797)
	at org.apache.ignite.internal.processors.cache.QueryCursorImpl.iter(QueryCursorImpl.java:101)
	at org.apache.ignite.internal.processors.cache.query.RegisteredQueryCursor.iter(RegisteredQueryCursor.java:73)
	at org.apache.ignite.internal.processors.cache.QueryCursorImpl.iterator(QueryCursorImpl.java:91)
	at com.xxxx.data.api.persistence.CacheQueryKt.firstRow(CacheQuery.kt:400)
	at com.xxxx.data.api.persistence.CacheQueryKt.firstLongValue(CacheQuery.kt:405)
	at com.xxxx.data.sync.persistence.Syncing$Companion.summary(Syncing.kt:111)
	at com.xxxx.data.server.web.routing.SyncRoutingKt$sync$13.invokeSuspend(SyncRouting.kt:213)
	at com.xxxx.data.server.web.routing.SyncRoutingKt$sync$13.invoke(SyncRouting.kt)
	at io.ktor.util.pipeline.SuspendFunctionGun.loop(PipelineContext.kt:323)
	at io.ktor.util.pipeline.SuspendFunctionGun.proceed(PipelineContext.kt:168)
	at io.ktor.util.pipeline.SuspendFunctionGun.execute(PipelineContext.kt:188)
	at io.ktor.util.pipeline.Pipeline.execute(Pipeline.kt:31)
	at io.ktor.routing.Routing.executeResult(Routing.kt:147)
	at io.ktor.routing.Routing.interceptor(Routing.kt:34)
	at io.ktor.routing.Routing$Feature$install$1.invokeSuspend(Routing.kt:99)
	at io.ktor.routing.Routing$Feature$install$1.invoke(Routing.kt)
	at io.ktor.util.pipeline.SuspendFunctionGun.loop(PipelineContext.kt:323)
	at io.ktor.util.pipeline.SuspendFunctionGun.proceed(PipelineContext.kt:168)
	at io.ktor.features.ContentNegotiation$Feature$install$1.invokeSuspend(ContentNegotiation.kt:107)
	at io.ktor.features.ContentNegotiation$Feature$install$1.invoke(ContentNegotiation.kt)
	at io.ktor.util.pipeline.SuspendFunctionGun.loop(PipelineContext.kt:323)
	at io.ktor.util.pipeline.SuspendFunctionGun.proceed(PipelineContext.kt:168)
	at io.ktor.features.StatusPages$interceptCall$2.invokeSuspend(StatusPages.kt:101)
	at io.ktor.features.StatusPages$interceptCall$2.invoke(StatusPages.kt)
	at kotlinx.coroutines.intrinsics.UndispatchedKt.startUndispatchedOrReturn(Undispatched.kt:91)
	at kotlinx.coroutines.CoroutineScopeKt.coroutineScope(CoroutineScope.kt:194)
	at io.ktor.features.StatusPages.interceptCall(StatusPages.kt:100)
	at io.ktor.features.StatusPages$Feature$install$2.invokeSuspend(StatusPages.kt:140)
	at io.ktor.features.StatusPages$Feature$install$2.invoke(StatusPages.kt)
	at io.ktor.util.pipeline.SuspendFunctionGun.loop(PipelineContext.kt:323)
	at io.ktor.util.pipeline.SuspendFunctionGun.proceed(PipelineContext.kt:168)
	at io.ktor.features.CallLogging$Feature$install$2.invokeSuspend(CallLogging.kt:139)
	at io.ktor.features.CallLogging$Feature$install$2.invoke(CallLogging.kt)
	at io.ktor.util.pipeline.SuspendFunctionGun.loop(PipelineContext.kt:323)
	at io.ktor.util.pipeline.SuspendFunctionGun.proceed(PipelineContext.kt:168)
	at io.ktor.util.pipeline.SuspendFunctionGun.execute(PipelineContext.kt:188)
	at io.ktor.util.pipeline.Pipeline.execute(Pipeline.kt:31)
	at io.ktor.server.engine.DefaultEnginePipelineKt$defaultEnginePipeline$2.invokeSuspend(DefaultEnginePipeline.kt:121)
	at io.ktor.server.engine.DefaultEnginePipelineKt$defaultEnginePipeline$2.invoke(DefaultEnginePipeline.kt)
	at io.ktor.util.pipeline.SuspendFunctionGun.loop(PipelineContext.kt:323)
	at io.ktor.util.pipeline.SuspendFunctionGun.proceed(PipelineContext.kt:168)
	at io.ktor.util.pipeline.SuspendFunctionGun.execute(PipelineContext.kt:188)
	at io.ktor.util.pipeline.Pipeline.execute(Pipeline.kt:31)
	at io.ktor.server.netty.NettyApplicationCallHandler$handleRequest$1.invokeSuspend(NettyApplicationCallHandler.kt:40)
	at io.ktor.server.netty.NettyApplicationCallHandler$handleRequest$1.invoke(NettyApplicationCallHandler.kt)
	at kotlinx.coroutines.intrinsics.UndispatchedKt.startCoroutineUndispatched(Undispatched.kt:55)
	at kotlinx.coroutines.BuildersKt__Builders_commonKt.startCoroutineImpl(Builders.common.kt:190)
	at kotlinx.coroutines.BuildersKt.startCoroutineImpl(Unknown Source)
	at kotlinx.coroutines.AbstractCoroutine.start(AbstractCoroutine.kt:145)
	at kotlinx.coroutines.BuildersKt__Builders_commonKt.launch(Builders.common.kt:56)
	at kotlinx.coroutines.BuildersKt.launch(Unknown Source)
	at io.ktor.server.netty.NettyApplicationCallHandler.handleRequest(NettyApplicationCallHandler.kt:30)
	at io.ktor.server.netty.NettyApplicationCallHandler.channelRead(NettyApplicationCallHandler.kt:24)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:377)
	at io.netty.channel.AbstractChannelHandlerContext.access$600(AbstractChannelHandlerContext.java:59)
	at io.netty.channel.AbstractChannelHandlerContext$7.run(AbstractChannelHandlerContext.java:368)
	at io.netty.util.concurrent.AbstractEventExecutor.safeExecute$$$capture(AbstractEventExecutor.java:164)
	at io.netty.util.concurrent.AbstractEventExecutor.safeExecute(AbstractEventExecutor.java)
	at io.netty.util.concurrent.SingleThreadEventExecutor.runAllTasks(SingleThreadEventExecutor.java:472)
	at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:500)
	at io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989)
	at io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74)
	at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)
	at java.lang.Thread.run(Thread.java:748)
Caused by: org.apache.ignite.internal.processors.query.IgniteSQLException: General error: "java.lang.ArrayIndexOutOfBoundsException: 1"; SQL statement:
SELECT
CAST((CAST(SUM(("__C0_0" * "__C0_1")) AS BIGINT) / CAST(SUM("__C0_1") AS BIGINT)) AS BIGINT) AS "__C0_0"
FROM "PUBLIC"."__T0" [50000-199]
	at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQuery(IgniteH2Indexing.java:833)
	at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQueryWithTimer(IgniteH2Indexing.java:924)
	at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.query(GridReduceQueryExecutor.java:542)
	... 65 common frames omitted
Caused by: org.gridgain.internal.h2.jdbc.JdbcSQLNonTransientException: General error: "java.lang.ArrayIndexOutOfBoundsException: 1"; SQL statement:
SELECT
CAST((CAST(SUM(("__C0_0" * "__C0_1")) AS BIGINT) / CAST(SUM("__C0_1") AS BIGINT)) AS BIGINT) AS "__C0_0"
FROM "PUBLIC"."__T0" [50000-199]
	at org.gridgain.internal.h2.message.DbException.getJdbcSQLException(DbException.java:503)
	at org.gridgain.internal.h2.message.DbException.getJdbcSQLException(DbException.java:427)
	at org.gridgain.internal.h2.message.DbException.get(DbException.java:194)
	at org.gridgain.internal.h2.message.DbException.convert(DbException.java:347)
	at org.gridgain.internal.h2.command.Command.executeQuery(Command.java:219)
	at org.gridgain.internal.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:115)
	at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQuery(IgniteH2Indexing.java:817)
	... 67 common frames omitted
Caused by: java.lang.ArrayIndexOutOfBoundsException: 1
	at org.gridgain.internal.h2.command.dml.SelectGroups.getCurrentGroupExprData(SelectGroups.java:289)
	at org.gridgain.internal.h2.expression.analysis.DataAnalysisOperation.getGroupData(DataAnalysisOperation.java:332)
	at org.gridgain.internal.h2.expression.analysis.DataAnalysisOperation.getValue(DataAnalysisOperation.java:381)
	at org.gridgain.internal.h2.expression.aggregate.Aggregate.getValue(Aggregate.java:312)
	at org.gridgain.internal.h2.expression.function.Function.getNullOrValue(Function.java:1184)
	at org.gridgain.internal.h2.expression.function.Function.getValueWithArgs(Function.java:1208)
	at org.gridgain.internal.h2.expression.function.Function.getValue(Function.java:582)
	at org.gridgain.internal.h2.expression.BinaryOperation.getValue(BinaryOperation.java:103)
	at org.gridgain.internal.h2.expression.function.Function.getNullOrValue(Function.java:1184)
	at org.gridgain.internal.h2.expression.function.Function.getValueWithArgs(Function.java:1208)
	at org.gridgain.internal.h2.expression.function.Function.getValue(Function.java:582)
	at org.gridgain.internal.h2.expression.Alias.getValue(Alias.java:37)
	at org.gridgain.internal.h2.command.dml.Select.processGroupResult(Select.java:586)
	at org.gridgain.internal.h2.command.dml.Select.queryGroup(Select.java:503)
	at org.gridgain.internal.h2.command.dml.Select.queryWithoutCache(Select.java:896)
	at org.gridgain.internal.h2.command.dml.Query.queryWithoutCacheLazyCheck(Query.java:151)
	at org.gridgain.internal.h2.command.dml.Query.query(Query.java:415)
	at org.gridgain.internal.h2.command.dml.Query.query(Query.java:397)
	at org.gridgain.internal.h2.command.CommandContainer.query(CommandContainer.java:145)
	at org.gridgain.internal.h2.command.Command.executeQuery(Command.java:202)
	... 69 common frames omitted

You can do this:

create table tests(
    ID int,
    CREATETIME TIMESTAMP(29,9),
    PRIMARY KEY (ID)
) WITH "template=partitioned, CACHE_NAME=tests";

select AVG(EXTRACT(MILLISECOND from CREATETIME))
from tests;