[jira] [Created] (IGNITE-20238) Sql. Conversion to VARCHAR for INTERVAL types is not correct.

["Maksim Zhuravkov (Jira)" <ji...@apache.org>]

Maksim Zhuravkov created IGNITE-20238:
-----------------------------------------

             Summary: 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
             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)