[CALCITE-5439] Validation of Pivot fails after creating a deep copy of SqlNode

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.32.0
• Fix Version/s: 1.33.0
• Labels: pull-request-available
• Assignee: Vova Vysotskyi
• Reporter: Vova Vysotskyi
• Created: 17/Dec/22 09:49
• Updated: 07/Feb/23 22:33
• Resolved: 28/Dec/22 02:21

Description

When creating a deep copy of SqlNode with the Pivot operator, SqlShuttle creates SqlBasicCall instead of SqlPivot, and such SqlNode fails when validating the query:

Caused by: java.lang.ClassCastException: org.apache.calcite.sql.SqlBasicCall cannot be cast to org.apache.calcite.sql.SqlPivot
	at org.apache.calcite.sql.validate.SqlValidatorImpl.registerFrom(SqlValidatorImpl.java:2389)
	at org.apache.calcite.sql.validate.SqlValidatorImpl.registerQuery(SqlValidatorImpl.java:2757)
	at org.apache.calcite.sql.validate.SqlValidatorImpl.registerQuery(SqlValidatorImpl.java:2696)
	at org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:1074)
	at org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:782)
	at org.apache.calcite.prepare.PlannerImpl.validate(PlannerImpl.java:224)
	... 61 more

Issue Links

• links to: GitHub Pull Request #3006