[
https://issues.apache.org/jira/browse/IGNITE-22022?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pavel Pereslegin updated IGNITE-22022:
--------------------------------------
Ignite Flags: (was: Docs Required,Release Notes Required)
> Sql. Json object with nested object creation fails
> --------------------------------------------------
>
> Key: IGNITE-22022
> URL: https://issues.apache.org/jira/browse/IGNITE-22022
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Reporter: Pavel Pereslegin
> Priority: Major
> Labels: ignite-3
>
> {{json_object}} function fails when trying to create object with nested object
> {code:java}
> assertQuery("select json_object('name': 'Alex', 'address':
> json_object('city': 'City 17', 'street': 'Elm'))")
> .returns("{\"name\":\"Alex\",\"address\":{\"city\":\"City
> 17\",\"street\":\"Elm\"}}")
> .check();
> {code}
> {noformat}
> Caused by: java.lang.reflect.UndeclaredThrowableException
> at com.sun.proxy.$Proxy96.getExpressionList(Unknown Source)
> at org.apache.calcite.rel.core.Project.<init>(Project.java:142)
> at
> org.apache.ignite.internal.sql.engine.rel.IgniteProject.<init>(IgniteProject.java:83)
> at SC.apply(Unknown Source)
> at
> org.apache.ignite.internal.sql.engine.externalize.RelJson$RelFactory.apply(RelJson.java:128)
> 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$6(ExecutionServiceImpl.java:300)
> 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:298)
> at
> org.apache.ignite.internal.sql.engine.exec.ExecutionServiceImpl$DistributedQueryManager.submitFragment(ExecutionServiceImpl.java:833)
> at
> org.apache.ignite.internal.sql.engine.exec.ExecutionServiceImpl.submitFragment(ExecutionServiceImpl.java:514)
> at
> org.apache.ignite.internal.sql.engine.exec.ExecutionServiceImpl.onMessage(ExecutionServiceImpl.java:413)
> at
> org.apache.ignite.internal.sql.engine.exec.ExecutionServiceImpl.lambda$start$1(ExecutionServiceImpl.java:262)
> at
> org.apache.ignite.internal.sql.engine.message.MessageServiceImpl.onMessageInternal(MessageServiceImpl.java:151)
> at
> org.apache.ignite.internal.sql.engine.message.MessageServiceImpl.lambda$onMessage$0(MessageServiceImpl.java:115)
> ... 4 more
> Caused by: java.lang.reflect.InvocationTargetException
> 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.NullPointerException: operator
> at java.base/java.util.Objects.requireNonNull(Objects.java:246)
> at org.apache.calcite.rex.RexCall.<init>(RexCall.java:81)
> at org.apache.calcite.rex.RexBuilder.makeCall(RexBuilder.java:258)
> at
> org.apache.ignite.internal.sql.engine.externalize.RelJson.toRex(RelJson.java:828)
> at
> org.apache.ignite.internal.sql.engine.externalize.RelJson.toRexList(RelJson.java:1027)
> at
> org.apache.ignite.internal.sql.engine.externalize.RelJson.toRex(RelJson.java:787)
> at
> org.apache.ignite.internal.sql.engine.externalize.RelJsonReader$RelInputImpl.getExpressionList(RelJsonReader.java:303)
> ... 28 more
> {noformat}
> At first glance, this looks like a bug on the Ignite side.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
