[PHOENIX-5926] `ALTER TABLE tb ADD IF NOT EXISTS c2 VARCHAR,c3 VARCHAR` if c2 EXISTS. c3 not EXISTS . c3 Cannot be added

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 5.0.0
• Fix Version/s: 5.0.1
• Component/s: core

Environment

• phoenix 5.0.0 
• hbase 2.0.0

• Assignee: Unassigned
• Reporter: siaron
• Created: 28/May/20 06:00
• Updated: 28/May/20 06:00

Description

- create table

CREATE TABLE IF NOT EXISTS tb

(

    c1 VARCHAR,

    c2 VARCHAR,

    CONSTRAINT tb PRIMARY KEY (c1)

);

• alter table

ALTER TABLE tb ADD  IF NOT EXISTS c2 VARCHAR,c3 VARCHAR;

 

but c3 Cannot be added

*https://issues.apache.org/jira/browse/PHOENIX-2968*

this issue Processed on the client side IFNOTEXISTS , when APPEND_ONLY_SCHEMA=false not process