[
https://issues.apache.org/jira/browse/IGNITE-26242?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Konstantin Orlov reassigned IGNITE-26242:
-----------------------------------------
Assignee: Konstantin Orlov
> Sql. Time. Removal of intermediate CAST operation leads to unexpected result
> ----------------------------------------------------------------------------
>
> Key: IGNITE-26242
> URL: https://issues.apache.org/jira/browse/IGNITE-26242
> Project: Ignite
> Issue Type: Bug
> Components: sql ai3
> Affects Versions: 3.0
> Reporter: Maksim Zhuravkov
> Assignee: Konstantin Orlov
> Priority: Major
> Labels: ignite-3
>
> {noformat}
> rs = executeQuery("SELECT '00:00:00.1'::TIME(3),
> '00:00:00.1'::TIME(3)::VARCHAR");
> // The second expression should produce '00:00:00.100' but it produces
> '00:00:00.1'
> {noformat}
> Query plan:
> {noformat}
> [[Values
> fieldNames: [EXPR$0, EXPR$1]
> tuples: [[00:00:00.1:TIME(3), _UTF-8'00:00:00.1':VARCHAR CHARACTER SET
> "UTF-8"]]
> est: (rows=1)
> ]]
> {noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
