[IGNITE-18311] AssertionError in SQL on subquery with offset and limit

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.0
• Component/s: sql
• Labels: calcite calcite2-required ignite-3
• Assignee: Iurii Gerzhedovich
• Reporter: Pavel Tupitsyn
• Created: 01/Dec/22 15:56
• Updated: 04/Sep/24 16:19
• Resolved: 12/Apr/23 06:30

Description

Query

select _T0.KEY from (select _T1.KEY, _T1.VAL from PUBLIC.TBL1 as _T1 order by (_T1.KEY) desc limit ? offset ?) as _T0

Error

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)

Issue Links

• duplicates: IGNITE-18664 Sql. subquery with OFFSET is not supported
• duplicates: IGNITE-18665 Sql. subquery with ORDER BY is not supported
• is related to: IGNITE-18123 .NET: Thin 3.0: LINQ: Skip and Take (offset / limit) support
• is related to: IGNITE-18298 .NET: Enable Java assertions in test Ignite nodes
• is related to: CALCITE-5377 RelFieldTrimmer support Sort with dynamic param
• links to: GitHub Pull Request #1925
• links to: PR #1925