[jira] [Commented] (IGNITE-21662) Sql: Data may be unavailable after creation of index
[
https://issues.apache.org/jira/browse/IGNITE-21662?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17827525#comment-17827525
]
Andrey Khitrin commented on IGNITE-21662:
-
Looks like it's working now. Thank you!
> 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
>Assignee: Konstantin Orlov
>Priority: Major
> Labels: ignite-3, sql
>
> 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)
[jira] [Commented] (IGNITE-21662) Sql: Data may be unavailable after creation of index
[
https://issues.apache.org/jira/browse/IGNITE-21662?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17825955#comment-17825955
]
Maksim Zhuravkov commented on IGNITE-21662:
---
>An issue with indexes is fixed
Looks like this issue with indexes still occurs.
And the code path was fixed https://issues.apache.org/jira/browse/IGNITE-20634
fixed another problem related to indexes.
> 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
>Priority: Major
> Labels: ignite-3, sql
>
> 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)
[jira] [Commented] (IGNITE-21662) Sql: Data may be unavailable after creation of index
[
https://issues.apache.org/jira/browse/IGNITE-21662?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17824267#comment-17824267
]
Maksim Zhuravkov commented on IGNITE-21662:
---
An issue with indexes is fixed, now it triggers ClassCastException that looks
similar to IGNITE-19976 Sql: ClassCastException when trying to select from
indexed smallint column.
> 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
>Priority: Major
> Labels: ignite-3, sql
>
> 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)
