[
https://issues.apache.org/jira/browse/IGNITE-22358?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Maksim Zhuravkov updated IGNITE-22358:
--------------------------------------
Summary: Sql. Results of TypeFactory::leastRestrictiveType are incompatible
with legal type transformations (was: Sql. Results of
TypeFactory::leastRestrictiveType are compatible with legal type
transformations)
> Sql. Results of TypeFactory::leastRestrictiveType are incompatible 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)
