Evgeny Stanilovsky created IGNITE-22698:
-------------------------------------------
Summary: 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
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)
