[
https://issues.apache.org/jira/browse/IGNITE-22698?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Evgeny Stanilovsky reassigned IGNITE-22698:
-------------------------------------------
Assignee: Evgeny Stanilovsky
> Sql. Extend test coverage for numeric comparison with literal wider than
> numeric type
> -------------------------------------------------------------------------------------
>
> Key: IGNITE-22698
> URL: https://issues.apache.org/jira/browse/IGNITE-22698
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Affects Versions: 3.0.0-beta1
> Reporter: Evgeny Stanilovsky
> Assignee: Evgeny Stanilovsky
> Priority: Major
> Labels: ignite-3
> Time Spent: 10m
> Remaining Estimate: 0h
>
> Need to cover cases where literal or numeric value, used in predicate is
> wider than column\expression type. E.g:
> {noformat}
> create table tiny(v TINYINT);
> insert into tiny values(127);
> SELECT * FROM tiny WHERE v < 300;
> SELECT * FROM tiny WHERE v NOT IN (300, 1000);
> {noformat}
> Also seems sql with mixed exact numeric and approx literal predicates need to
> fail.
> {noformat}
> create table tiny(v TINYINT);
> insert into tiny values(127);
> SELECT * FROM tiny WHERE v < '3.1'; <-- need to fail
> {noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
