chaijunjie created PHOENIX-7358:
-----------------------------------

             Summary: Upsert select result wrong when use order by in query。
                 Key: PHOENIX-7358
                 URL: https://issues.apache.org/jira/browse/PHOENIX-7358
             Project: Phoenix
          Issue Type: Bug
          Components: core
    Affects Versions: 5.1.2
            Reporter: chaijunjie


When execute these sql, the upsert result is wrong, it is not same as order by 
result.
{code:java}
create table t1(
c1 char(1) not null primary key,
c2 char(1),
c3 char(1)
) SALT_BUCKETS=8;create table t2(
cc1 char(1) not null primary key,
cc2 char(1),
cc3 char(1)
) SALT_BUCKETS=8;upsert into t1 values('1','0','a');
upsert into t1 values('2','1','b');
upsert into t1 values('3','1','c');
upsert into t1 values('4','0','d');
upsert into t1 values('5','1','e');select c2,c1,c3 from t1 order by c3 
desc;upsert into t2(cc1,cc2,cc3) select c2,c1,c3 from t1 order by c3 desc;
select * from t2; {code}
 



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

Reply via email to