Andrey Khitrin created IGNITE-21662:
---------------------------------------

             Summary: Sql: Data may be unavailable after creation of index
                 Key: IGNITE-21662
                 URL: https://issues.apache.org/jira/browse/IGNITE-21662
             Project: Ignite
          Issue Type: Bug
    Affects Versions: 3.0.0-beta2
            Reporter: Andrey Khitrin


Steps to reproduce:

{code:sql}
create table index_test_table_2(id INTEGER not null, field_1 TINYINT not null, 
field_2 SMALLINT not null, field_3 INTEGER not null, field_4 FLOAT not null, 
field_5 VARCHAR(50) not null, primary key (id));
create index index_test_index_2_1 on index_test_table_2 using TREE (field_2, 
field_3, field_5);
insert into index_test_table_2(...)
-- try to select one of inserted values
select * from index_test_table_2 where  WHERE field_2 = .. AND field_3 = .. AND 
field_5 = '..';
{code}

Expected result: a row is selected.
Actual result: no rows are selected.

The issue is flaky and sometimes is masked by IGNITE-19976.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to