[ 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)