[jira] [Created] (PHOENIX-5233) Read-your-own writes causes incorrect visibility with transactional tables.

["Lars Hofhansl (JIRA)" <ji...@apache.org>]

Lars Hofhansl created PHOENIX-5233:
--------------------------------------

             Summary: Read-your-own writes causes incorrect visibility with transactional tables.
                 Key: PHOENIX-5233
                 URL: https://issues.apache.org/jira/browse/PHOENIX-5233
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 4.14.1
            Reporter: Lars Hofhansl


(copied from my last comment on PHOENIX-5090)
Steps to reproduce:
 # {{!autocommit off}}
 # {{create table test (pk1 integer not null, pk2 integer not null, pk3 integer not null, v1 float, v2 float, v3 integer CONSTRAINT pk PRIMARY KEY (pk1, pk2, pk3)) DISABLE_WAL=true, TRANSACTIONAL=true;}}
 # {{upsert into test values(rand()*10000000, rand()*10000000, rand()*10000000, rand(), rand(), rand()*1000000);}}
 # {{upsert into test select rand()*10000000, rand()*10000000, rand()*10000000, rand(), rand(), rand()*1000000 from test;}}
 # {{select count\(*) from test; – this will cause uncommitted data to sent to the server.}}
 # Goto #4 a few time (until you inserted 131072 rows)
 # {{!commit}}

In a separate sqlline session just repeat after the commit was issued in the other session.
* {{select count\(*) from test;}}

You'll see that number will change until it finally settles.



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