[
https://issues.apache.org/jira/browse/IGNITE-28469?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Konstantin Orlov reassigned IGNITE-28469:
-----------------------------------------
Assignee: Konstantin Orlov
> Sql. Partition pruning doesn't work for temporal types and dynamic params
> -------------------------------------------------------------------------
>
> Key: IGNITE-28469
> URL: https://issues.apache.org/jira/browse/IGNITE-28469
> Project: Ignite
> Issue Type: Bug
> Components: sql ai3
> Reporter: Konstantin Orlov
> Assignee: Konstantin Orlov
> Priority: Major
> Labels: ignite-3
>
> Partition pruning doesn't work when colocation column of temporal type and
> dynamic parameters are used. For example:
> {code}
> CREATE TABLE test (id int, id_ts TIMESTAMP(3), node VARCHAR(128), PRIMARY KEY
> (id, id_ts)) COLOCATE BY (id_ts);
> SELECT node FROM test WHERE id_ts = CAST(? AS TIMESTAMP(3));
> {code}
> In the example above, both colocation column type and derived type of
> parameter are TIMESTAMP(3), therefore I would expect exactly one partition to
> be involved into query processing.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
