[
https://issues.apache.org/jira/browse/IGNITE-20238?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Maksim Zhuravkov updated IGNITE-20238:
--------------------------------------
Description:
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}
was:
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}
> 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.0.0-beta2
>
>
> 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)
