[
https://issues.apache.org/jira/browse/IGNITE-27718?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Konstantin Orlov updated IGNITE-27718:
--------------------------------------
Labels: ignite-3 (was: )
> Sql. ClassCastException when table level hint is used in UPDATE
> ---------------------------------------------------------------
>
> Key: IGNITE-27718
> URL: https://issues.apache.org/jira/browse/IGNITE-27718
> Project: Ignite
> Issue Type: Bug
> Components: sql ai3
> Affects Versions: 3.1
> Reporter: Konstantin Orlov
> Priority: Major
> Labels: ignite-3
>
> If table-level hint is specified in UPDATE statement like this:
> {code}
> UPDATE my_table /*+ force_index(my_table_idx) */ SET val = ?
> {code}
> then cClassCastException is thrown:
> {code}
> Caused by: java.lang.ClassCastException: class
> org.apache.calcite.sql.SqlTableRef cannot be cast to class
> org.apache.calcite.sql.SqlIdentifier (org.apache.calcite.sql.SqlTableRef and
> org.apache.calcite.sql.SqlIdentifier are in unnamed module of loader 'app')
> at
> org.apache.ignite.internal.sql.engine.prepare.IgniteSqlValidator.createSourceSelectForUpdate(IgniteSqlValidator.java:583)
> at
> org.apache.calcite.sql.validate.SqlValidatorImpl.performUnconditionalRewrites(SqlValidatorImpl.java:1600)
> at
> org.apache.ignite.internal.sql.engine.prepare.IgniteSqlValidator.performUnconditionalRewrites(IgniteSqlValidator.java:1031)
> at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:1108)
> at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:821)
> at
> org.apache.ignite.internal.sql.engine.prepare.IgniteSqlValidator.validate(IgniteSqlValidator.java:192)
> at
> org.apache.ignite.internal.sql.engine.prepare.IgnitePlanner.validate(IgnitePlanner.java:202)
> at
> org.apache.ignite.internal.sql.engine.prepare.PrepareServiceImpl.lambda$validateDml$30(PrepareServiceImpl.java:897)
> at
> java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run$$$capture(CompletableFuture.java:1768)
> ... 22 more
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
