[jira] [Created] (IGNITE-28469) Sql. Partition pruning doesn't work for temporal types and dynamic params

[Konstantin Orlov (Jira)]

Konstantin Orlov created IGNITE-28469:
-----------------------------------------

             Summary: 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


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)