You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@ignite.apache.org by "Aleksey Plekhanov (Jira)" <ji...@apache.org> on 2024/06/25 13:59:00 UTC

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

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)