[
https://issues.apache.org/jira/browse/IGNITE-25783?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vladimir Dmitrienko updated IGNITE-25783:
-----------------------------------------
Description:
*Steps to reproduce:*
{code:java}
select '13:44:56.123'::time;
select '13:44:56.123'::time(1);
select '13:44:56.123'::time(2);
select '13:44:56.123'::time(2);{code}
*Actual result:*
{code:java}
13:44:56{code}
*Expected result:*
{code:java}
13:44:56.123
13:44:56.1
13:44:56.12
13:44:56.123{code}
Caused by: https://github.com/apache/ignite-3/pull/6057
was:
*Steps to reproduce:*
{code:java}
select '13:44:56.123'::time;
select '13:44:56.123'::time(1);
select '13:44:56.123'::time(2);
select '13:44:56.123'::time(2);{code}
*Actual result:*
{code:java}
13:44:56{code}
*Expected result:*
{code:java}
13:44:56.123
13:44:56.1
13:44:56.12
13:44:56.123{code}
> TIME cast truncates fractional seconds
> --------------------------------------
>
> Key: IGNITE-25783
> URL: https://issues.apache.org/jira/browse/IGNITE-25783
> Project: Ignite
> Issue Type: Bug
> Components: sql ai3
> Affects Versions: 3.1
> Reporter: Vladimir Dmitrienko
> Priority: Major
>
> *Steps to reproduce:*
> {code:java}
> select '13:44:56.123'::time;
> select '13:44:56.123'::time(1);
> select '13:44:56.123'::time(2);
> select '13:44:56.123'::time(2);{code}
> *Actual result:*
> {code:java}
> 13:44:56{code}
> *Expected result:*
> {code:java}
> 13:44:56.123
> 13:44:56.1
> 13:44:56.12
> 13:44:56.123{code}
> Caused by: https://github.com/apache/ignite-3/pull/6057
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
