You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Yury Gerzhedovich (Jira)" <ji...@apache.org> on 2023/04/10 12:11:00 UTC
[jira] [Commented] (IGNITE-18311) AssertionError in SQL on subquery with offset and limit
[ https://issues.apache.org/jira/browse/IGNITE-18311?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17710125#comment-17710125 ]
Yury Gerzhedovich commented on IGNITE-18311:
--------------------------------------------
After upgrading Calcite to ver 1.34 the issue is dissappear
> AssertionError in SQL on subquery with offset and limit
> -------------------------------------------------------
>
> Key: IGNITE-18311
> URL: https://issues.apache.org/jira/browse/IGNITE-18311
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Reporter: Pavel Tupitsyn
> Assignee: Yury Gerzhedovich
> Priority: Major
> Labels: calcite, calcite2-required, calcite3-required, ignite-3
> Fix For: 3.0.0-beta2
>
>
> *Query*
> {code}
> select _T0.KEY from (select _T1.KEY, _T1.VAL from PUBLIC.TBL1 as _T1 order by (_T1.KEY) desc limit ? offset ?) as _T0
> {code}
> *Error*
> {code}
> java.lang.AssertionError: rowType: RecordType(BIGINT KEY, VARCHAR(65536) VAL), mapping: [size=1, sourceCount=2, targetCount=1, elements=[0:0]]
> at org.apache.calcite.sql2rel.RelFieldTrimmer$TrimResult.<init>(RelFieldTrimmer.java:1342)
> at org.apache.calcite.sql2rel.RelFieldTrimmer.result(RelFieldTrimmer.java:337)
> at org.apache.calcite.sql2rel.RelFieldTrimmer.trimFields(RelFieldTrimmer.java:672)
> 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.calcite.util.ReflectUtil$2.invoke(ReflectUtil.java:531)
> at org.apache.calcite.sql2rel.RelFieldTrimmer.dispatchTrimFields(RelFieldTrimmer.java:284)
> at org.apache.calcite.sql2rel.RelFieldTrimmer.trimChild(RelFieldTrimmer.java:226)
> at org.apache.calcite.sql2rel.RelFieldTrimmer.trimFields(RelFieldTrimmer.java:498)
> at jdk.internal.reflect.GeneratedMethodAccessor47.invoke(Unknown Source)
> 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.calcite.util.ReflectUtil$2.invoke(ReflectUtil.java:531)
> at org.apache.calcite.sql2rel.RelFieldTrimmer.dispatchTrimFields(RelFieldTrimmer.java:284)
> at org.apache.calcite.sql2rel.RelFieldTrimmer.trim(RelFieldTrimmer.java:171)
> at org.apache.calcite.sql2rel.SqlToRelConverter.trimUnusedFields(SqlToRelConverter.java:549)
> at org.apache.ignite.internal.sql.engine.prepare.IgnitePlanner.trimUnusedFields(IgnitePlanner.java:351)
> at org.apache.ignite.internal.sql.engine.prepare.PlannerHelper.optimize(PlannerHelper.java:76)
> at org.apache.ignite.internal.sql.engine.prepare.PrepareServiceImpl.lambda$prepareQuery$1(PrepareServiceImpl.java:231)
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)