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)