You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "siaron (Jira)" <ji...@apache.org> on 2020/05/28 06:00:20 UTC

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

siaron created PHOENIX-5926:
-------------------------------

             Summary: `ALTER TABLE tb ADD  IF NOT EXISTS c2 VARCHAR,c3 VARCHAR`  if c2 EXISTS. c3 not EXISTS . c3 Cannot be added 
                 Key: PHOENIX-5926
                 URL: https://issues.apache.org/jira/browse/PHOENIX-5926
             Project: Phoenix
          Issue Type: Bug
          Components: core
    Affects Versions: 5.0.0
         Environment: * phoenix 5.0.0 
 * hbase 2.0.0
            Reporter: siaron
             Fix For: 5.0.1


h3. - 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* *IF**NOT**EXISTS , when* APPEND_ONLY_SCHEMA=false not process



--
This message was sent by Atlassian Jira
(v8.3.4#803005)