ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pavel Vinokurov (JIRA)" <j...@apache.org>
Subject [jira] [Created] (IGNITE-10291) Unable to find row by index created on partial baseline topology
Date Fri, 16 Nov 2018 08:01:00 GMT
Pavel Vinokurov created IGNITE-10291:
----------------------------------------

             Summary: Unable to find row by index created on partial baseline topology
                 Key: IGNITE-10291
                 URL: https://issues.apache.org/jira/browse/IGNITE-10291
             Project: Ignite
          Issue Type: Bug
          Components: cache, sql
    Affects Versions: 2.6, 2.5, 2.4
            Reporter: Pavel Vinokurov
         Attachments: Reproducer.java

Steps to reproduce:
1. Start two nodes cluster with persistence.
2. Create table
CREATE TABLE PERSON (
 FIRST_NAME VARCHAR,
 LAST_NAME VARCHAR,
 ADDRESS VARCHAR,
 LANG VARCHAR,
 BIRTH_DATE TIMESTAMP,
 CONSTRAINT PK_PESON PRIMARY KEY (FIRST_NAME,LAST_NAME,ADDRESS,LANG)
) WITH "key_type=PersonKeyType, CACHE_NAME=PersonCache, value_type=PersonValueType, AFFINITY_KEY=FIRST_NAME,template=PARTITIONED,backups=1"

Insert 1000 rows.
3. Stop the second node.
4. Create index
create index PERSON_FIRST_NAME_IDX on  PERSON(FIRST_NAME)
5. Start the second node
6. Perform select query for each row:
select * from PERSON use index(PERSON_FIRST_NAME_IDX) 
where 
FIRST_NAME=?
and LAST_NAME=?
and ADDRESS=?
and LANG  = ? 

Result: The select doesn't return row in half of cases.

The reproducer is attached.




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message