[
https://issues.apache.org/jira/browse/IGNITE-22358?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Maksim Zhuravkov updated IGNITE-22358:
--------------------------------------
Description:
{noformat}
SELECT 1 UNION ALL SELECT '2000-01-01'::DATE
# returns: DATE, DATE
{noformat}
Although a cast from an INT to DATE should not be possible according to type
transformation rules:
{noformat}
SELECT 1::DATE
# Error: Cast function cannot convert value of type INTEGER to type DATE
{noformat}
This query should also return an error because it is not possible to convert an
INT into a DATE.
was:
{noformat}
SELECT 1 UNION ALL SELECT '2000-01-01'::DATE
# returns: DATE, DATE
{noformat}
Although a cast from an INT to DATE is not possible according to type
transformation rules:
{noformat}
SELECT 1::DATE
# Error: Cast function cannot convert value of type INTEGER to type DATE
{noformat}
This query should also return an error because it is not possible to convert an
INT into a DATE.
> Sql. Results of TypeFactory::leastRestrictiveType are compatible with legal
> type transformations
> ------------------------------------------------------------------------------------------------
>
> Key: IGNITE-22358
> URL: https://issues.apache.org/jira/browse/IGNITE-22358
> Project: Ignite
> Issue Type: Improvement
> Components: sql
> Reporter: Maksim Zhuravkov
> Priority: Major
> Labels: ignite-3
>
> {noformat}
> SELECT 1 UNION ALL SELECT '2000-01-01'::DATE
> # returns: DATE, DATE
> {noformat}
> Although a cast from an INT to DATE should not be possible according to type
> transformation rules:
> {noformat}
> SELECT 1::DATE
> # Error: Cast function cannot convert value of type INTEGER to type DATE
> {noformat}
> This query should also return an error because it is not possible to convert
> an INT into a DATE.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
