[
https://issues.apache.org/jira/browse/IGNITE-25783?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pavel Pereslegin updated IGNITE-25783:
--------------------------------------
Description:
*Steps to reproduce:* (use CLI from AI3)
{code:java}
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.1
13:44:56.12
13:44:56.123{code}
Most likely caused by https://github.com/apache/ignite-3/pull/5784/files
Note: if this is expected behavior it should be documented somehow (e.g. CLI -
trims millis, JDBC getObject() - not trims)
was:
*Steps to reproduce:* (use CLI from AI3)
{code:java}
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.1
13:44:56.12
13:44:56.123{code}
Most likely caused by https://github.com/apache/ignite-3/pull/5784/files
> 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:* (use CLI from AI3)
> {code:java}
> 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.1
> 13:44:56.12
> 13:44:56.123{code}
> Most likely caused by https://github.com/apache/ignite-3/pull/5784/files
> Note: if this is expected behavior it should be documented somehow (e.g. CLI
> - trims millis, JDBC getObject() - not trims)
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
