[IGNITE-19976] Sql: ClassCastException when trying to select from indexed smallint column

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0, 3.0.0-beta1
• Fix Version/s: 3.0
• Component/s: sql
• Labels: ignite-3 sql
• Assignee: Maksim Zhuravkov
• Reporter: Andrey Khitrin
• Created: 13/Jul/23 11:05
• Updated: 04/Sep/24 16:22
• Resolved: 14/Mar/24 07:27

Description

Steps to reproduce:

sql-cli> create table tt(id INTEGER not null, field_1 TINYINT, field_2 SMALLINT, primary key (id));
Updated 0 rows.
sql-cli> SELECT * FROM tt WHERE field_2 = 50;
╔════╤═════════╤═════════╗
║ ID │ FIELD_1 │ FIELD_2 ║
╠════╧═════════╧═════════╣
║ (empty)                ║
╚════════════════════════╝

-- select over field_2 works fine until we create an index on it!

sql-cli> CREATE INDEX tt_idx ON tt (field_2);
Updated 0 rows.
sql-cli> SELECT * FROM tt WHERE field_2 = 50;
SQL query execution error
Exception while executing query [query=SELECT * FROM tt WHERE field_2 = 50;]. Error message:Query remote fragment execution failed: nodeName=defaultNode, queryId=15a68600-41bc-46c5-b20d-7a96aad15477, fragmentId=4, originalMessage=class java.lang.Integer cannot be cast to class java.lang.Short (java.lang.Integer and java.lang.Short are in module java.base of loader 'bootstrap')

This doesn't look good. A created index must not cause casting exception.

Reproduced on commit `fef7a24c2a029cac720d2fea3815c2a70a86b72f` (2023-07-12)

Issue Links

• is caused by: IGNITE-19615 Index is not used while performing SELECT over an indexed column
• is related to: IGNITE-21662 Sql: Data may be unavailable after creation of index
• is related to: IGNITE-19997 Sql. Enhancing test coverage of type coercion
• links to: GitHub Pull Request #2315
• links to: GitHub Pull Request #3377