[
https://issues.apache.org/jira/browse/IGNITE-20238?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Evgeny Stanilovsky updated IGNITE-20238:
----------------------------------------
Fix Version/s: 3.2
(was: 3.1)
> Sql. Conversion to VARCHAR for INTERVAL types is not correct.
> -------------------------------------------------------------
>
> Key: IGNITE-20238
> URL: https://issues.apache.org/jira/browse/IGNITE-20238
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Reporter: Maksim Zhuravkov
> Priority: Minor
> Labels: ignite-3
> Fix For: 3.2
>
>
> The following queries produce the same results:
> {code:java}
> #q1
> SELECT CAST(INTERVAL 2 MINUTES AS VARCHAR) # '+2'
> #q2
> SELECT CAST(INTERVAL 2 HOURS AS VARCHAR) # '+2'
> {code}
> Databases that support interval types return different results for both
> queries.
> Oracle:
> {code:java}
> # q1
> SELECT CAST(INTERVAL '1' YEAR AS VARCHAR2(100)) # INTERVAL'+01-00'YEAR TO
> MONTH
> # q2
> SELECT CAST(INTERVAL '1' SECOND AS VARCHAR2(100)) # INTERVAL'+00
> 00:00:01.000000'DAY TO SECOND
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
