[IGNITE-19456] Dropping one column of the composite index makes impossible queries to other columns in the index

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Cannot Reproduce
• Component/s: jdbc, sql, thin client
• Labels: ignite-3
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Unassigned
• Reporter: Igor
• Created: 11/May/23 12:02
• Updated: 15/May/23 09:14
• Resolved: 15/May/23 09:12

Description

Steps to reproduce:

1. Create table.

CREATE TABLE index_test_table_5(id INT PRIMARY KEY, field_1 TINYINT, field_2 SMALLINT, field_3 INT, field_4 FLOAT, field_5 VARCHAR)

2. Create composite index:

CREATE INDEX index_test_index_5_1 ON index_test_table_5(field_2, field_3, field_5)

3. Insert some rows.

4. Drop one column of composite index:

ALTER TABLE index_test_table_5 DROP COLUMN field_5

5. Execute select filtering 2 other columns

SELECT * FROM index_test_table_5 WHERE field_2 = 50 AND field_3 = 50

Expected result:

The filtered row is returned.

Actual result:

An exception:

Exception while executing query [query=SELECT * FROM index_test_table_5 WHERE field_2 = 50 AND field_3 = 50]. Error message:Error while applying rule ExposeIndexRule, args [rel#9120:IgniteLogicalTableScan.NONE.[].any(table=[PUBLIC, INDEX_TEST_TABLE_5],filters=AND(=(CAST($t2):INTEGER, 50), =($t3, 50)),requiredColumns={0, 1, 2, 3, 4})]
java.sql.SQLException: Exception while executing query [query=SELECT * FROM index_test_table_5 WHERE field_2 = 50 AND field_3 = 50]. Error message:Error while applying rule ExposeIndexRule, args [rel#9120:IgniteLogicalTableScan.NONE.[].any(table=[PUBLIC, INDEX_TEST_TABLE_5],filters=AND(=(CAST($t2):INTEGER, 50), =($t3, 50)),requiredColumns={0, 1, 2, 3, 4})]
    at org.apache.ignite.internal.jdbc.proto.IgniteQueryErrorCode.createJdbcSqlException(IgniteQueryErrorCode.java:57)
    at org.apache.ignite.internal.jdbc.JdbcStatement.execute0(JdbcStatement.java:148)
    at org.apache.ignite.internal.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:108) 

 

Issue Links

• relates to: IGNITE-19305 Index alive after drop indexed column