[ https://issues.apache.org/jira/browse/IGNITE-16077?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17457115#comment-17457115 ]
Taras Ledkov commented on IGNITE-16077: --------------------------------------- [~alex_pl], OK with me. > Calcite engine. Index on DATE/TIME/TIMESTAMP fields cannot be used > ------------------------------------------------------------------ > > Key: IGNITE-16077 > URL: https://issues.apache.org/jira/browse/IGNITE-16077 > Project: Ignite > Issue Type: Bug > Reporter: Aleksey Plekhanov > Assignee: Aleksey Plekhanov > Priority: Major > Labels: calcite2-required, calcite3-required > Time Spent: 10m > Remaining Estimate: 0h > > For example: > {noformat} > create table t(d date) > create index my_index on t(d); > insert into t values (date '2021-01-01') > insert into t values (date '2021-01-02') > select * from t where d = date '2021-01-01' > {noformat} > Fails with: > {noformat} > Caused by: class > org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to > wrap object into H2 Value. java.lang.Integer cannot be cast to java.sql.Date > at > org.apache.ignite.internal.processors.query.h2.index.keys.H2ValueWrapperMixin.wrapToValue(H2ValueWrapperMixin.java:37) > at > org.apache.ignite.internal.processors.query.h2.index.keys.DateIndexKey.<init>(DateIndexKey.java:31) > at > org.apache.ignite.internal.cache.query.index.sorted.keys.IndexKeyFactory.wrap(IndexKeyFactory.java:95) > at > org.apache.ignite.internal.processors.query.calcite.exec.IndexScan.row2indexRow(IndexScan.java:173) > at > org.apache.ignite.internal.processors.query.calcite.exec.IndexScan.row2indexRow(IndexScan.java:58) > at > org.apache.ignite.internal.processors.query.calcite.exec.AbstractIndexScan.iterator(AbstractIndexScan.java:84) > at > org.apache.ignite.internal.processors.query.calcite.exec.IndexScan.iterator(IndexScan.java:145) > {noformat} > We should convert DATE/TIME/TIMESTAMP from internal presentation (see > {{TypeUtils.fromInternal()}}) before creating {{IndexRow}}. > -- This message was sent by Atlassian Jira (v8.20.1#820001)