[
https://issues.apache.org/jira/browse/IGNITE-18559?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17848154#comment-17848154
]
Evgeny Stanilovsky commented on IGNITE-18559:
---------------------------------------------
type is derived here: AbstractTypeCoercion#commonTypeForBinaryComparison
> Sql. The least restrictive type between VARCHAR and DECIMAL is
> DECIMAL(precision=32767, scale=16383)
> ----------------------------------------------------------------------------------------------------
>
> Key: IGNITE-18559
> URL: https://issues.apache.org/jira/browse/IGNITE-18559
> Project: Ignite
> Issue Type: Improvement
> Components: sql
> Reporter: Maksim Zhuravkov
> Assignee: Evgeny Stanilovsky
> Priority: Minor
> Labels: ignite-3
> Fix For: 3.0.0-beta1
>
>
> At the moment the least restrictive type between VARCHAR and DECIMAL is
> DECIMAL(precision=32767, scale=16383). See TypeCoercionTest
> testVarCharToNumeric.
> Investigate why that happens and whether it is a problem or not.
> Test query:
> {code:java}
> SELECT NULLIF(12.2, 'b') -- Should fail since types do not match {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
