[jira] [Created] (IGNITE-22576) Calcite engine. Cast varchar to timestamp truncates millis

[Aleksey Plekhanov (Jira)]

Aleksey Plekhanov created IGNITE-22576:
------------------------------------------

             Summary: Calcite engine. Cast varchar to timestamp truncates millis
                 Key: IGNITE-22576
                 URL: https://issues.apache.org/jira/browse/IGNITE-22576
             Project: Ignite
          Issue Type: Bug
            Reporter: Aleksey Plekhanov
            Assignee: Aleksey Plekhanov


Reproducer:

{noformat}
SELECT CAST('2021-01-01 01:02:03.456' AS TIMESTAMP)
{noformat}
Returns "2021-01-01 01:02:03.000"
Root cause: default precision for {{TIMESTAMP}} in Calcite is 0, so 
{{TIMESTAMP}} threated as {{TIMESTAMP(0)}}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)