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)
