You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Maksim Zhuravkov (Jira)" <ji...@apache.org> on 2024/12/11 08:33:00 UTC
[jira] [Updated] (IGNITE-23945) Sql. Query calling system range fails with unexpected operator: name: $SCALAR_QUERY, kind: SCALAR_QUERY, syntax: INTERNAL
[ https://issues.apache.org/jira/browse/IGNITE-23945?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Maksim Zhuravkov updated IGNITE-23945:
--------------------------------------
Summary: Sql. Query calling system range fails with unexpected operator: name: $SCALAR_QUERY, kind: SCALAR_QUERY, syntax: INTERNAL (was: Sql. Query calling system range fails with UndeclaredThrowableException)
> Sql. Query calling system range fails with unexpected operator: name: $SCALAR_QUERY, kind: SCALAR_QUERY, syntax: INTERNAL
> -------------------------------------------------------------------------------------------------------------------------
>
> Key: IGNITE-23945
> URL: https://issues.apache.org/jira/browse/IGNITE-23945
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Reporter: Maksim Zhuravkov
> Priority: Major
> Labels: ignite-3
>
> Query: SELECT * FROM system_range(1,(SELECT 1))
> Error:
> {code:java}
> ndingAssignmentsSize=0].
> 2024-12-11 10:28:44:397 +0200 [INFO][%node1%sql-execution-pool-0][JdbcQueryEventHandlerImpl] Exception while executing query [query=SELECT * FROM system_range(1,(SELECT 1));]
> java.lang.reflect.UndeclaredThrowableException
> at com.sun.proxy.$Proxy80.getExpression(Unknown Source)
> at org.apache.calcite.rel.core.TableFunctionScan.<init>(TableFunctionScan.java:135)
> at org.apache.ignite.internal.sql.engine.rel.IgniteTableFunctionScan.<init>(IgniteTableFunctionScan.java:90)
> at SC.apply(Unknown Source)
> at org.apache.ignite.internal.sql.engine.externalize.RelJson$RelFactory.apply(RelJson.java:129)
> at org.apache.ignite.internal.sql.engine.externalize.RelJsonReader.readRel(RelJsonReader.java:140)
> at org.apache.ignite.internal.sql.engine.externalize.RelJsonReader.readRels(RelJsonReader.java:132)
> at org.apache.ignite.internal.sql.engine.externalize.RelJsonReader.read(RelJsonReader.java:123)
> at org.apache.ignite.internal.sql.engine.externalize.RelJsonReader.fromJson(RelJsonReader.java:86)
> at org.apache.ignite.internal.sql.engine.exec.ExecutionServiceImpl.lambda$relationalTreeFromJsonString$9(ExecutionServiceImpl.java:366)
> at com.github.benmanes.caffeine.cache.BoundedLocalCache.lambda$doComputeIfAbsent$13(BoundedLocalCache.java:2457)
> at java.base/java.util.concurrent.ConcurrentHashMap.compute(ConcurrentHashMap.java:1908)
> at com.github.benmanes.caffeine.cache.BoundedLocalCache.doComputeIfAbsent(BoundedLocalCache.java:2455)
> at com.github.benmanes.caffeine.cache.BoundedLocalCache.computeIfAbsent(BoundedLocalCache.java:2438)
> at com.github.benmanes.caffeine.cache.LocalCache.computeIfAbsent(LocalCache.java:107)
> at org.apache.ignite.internal.sql.engine.exec.ExecutionServiceImpl.relationalTreeFromJsonString(ExecutionServiceImpl.java:364)
> at org.apache.ignite.internal.sql.engine.exec.ExecutionServiceImpl$DistributedQueryManager.submitFragment(ExecutionServiceImpl.java:921)
> at org.apache.ignite.internal.sql.engine.exec.ExecutionServiceImpl.submitFragment(ExecutionServiceImpl.java:594)
> at org.apache.ignite.internal.sql.engine.exec.ExecutionServiceImpl.onMessage(ExecutionServiceImpl.java:495)
> at org.apache.ignite.internal.sql.engine.exec.ExecutionServiceImpl.lambda$start$1(ExecutionServiceImpl.java:276)
> at org.apache.ignite.internal.sql.engine.message.MessageServiceImpl.onMessageInternal(MessageServiceImpl.java:162)
> at org.apache.ignite.internal.sql.engine.message.MessageServiceImpl.lambda$onMessage$1(MessageServiceImpl.java:126)
> at org.apache.ignite.internal.sql.engine.exec.QueryTaskExecutorImpl.lambda$execute$0(QueryTaskExecutorImpl.java:86)
> at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
> at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
> at java.base/java.lang.Thread.run(Thread.java:829)
> Caused by: java.lang.reflect.InvocationTargetException
> at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.base/java.lang.reflect.Method.invoke(Method.java:566)
> at org.apache.ignite.internal.sql.engine.trait.TraitUtils.lambda$changeTraits$0(TraitUtils.java:265)
> ... 26 more
> Caused by: java.lang.IllegalStateException: Unknown or unexpected operator: name: $SCALAR_QUERY, kind: SCALAR_QUERY, syntax: INTERNAL
> at org.apache.ignite.internal.sql.engine.externalize.RelJson.toOp(RelJson.java:944)
> at org.apache.ignite.internal.sql.engine.externalize.RelJson.toRex(RelJson.java:818)
> at org.apache.ignite.internal.sql.engine.externalize.RelJson.toRexList(RelJson.java:1042)
> at org.apache.ignite.internal.sql.engine.externalize.RelJson.toRex(RelJson.java:784)
> at org.apache.ignite.internal.sql.engine.externalize.RelJsonReader$RelInputImpl.getExpression(RelJsonReader.java:200)
> ... 31 more
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)