[IGNITE-22698] Sql. Extend test coverage for numeric comparison with literal wider than numeric type

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0-beta1
• Fix Version/s: 3.0
• Component/s: sql
• Labels: ignite-3
• Assignee: Evgeny Stanilovsky
• Reporter: Evgeny Stanilovsky
• Created: 09/Jul/24 14:17
• Updated: 04/Sep/24 16:08
• Resolved: 10/Jul/24 13:41

Description

Need to cover cases where literal or numeric value, used in predicate is wider than column\expression type. E.g:

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);

Also seems sql with mixed exact numeric and approx literal predicates need to fail.

create table tiny(v TINYINT);
insert into tiny values(127);
SELECT * FROM tiny WHERE v < '3.1'; <-- need to fail

Issue Links

• is related to: IGNITE-19997 Sql. Enhancing test coverage of type coercion
• links to: GitHub Pull Request #4063