create & alter inconsistency with "on cluster" for ENGINE = Distributed

[den-crane]

<vscluster>
   <shard>
       <internal_replication>true</internal_replication>
       <replica><host>node1</host></replica>
       <replica><host>node2</host></replica>
   </shard>
</vscluster>

CREATE works! And creates Distributed table on both replicas.
CREATE TABLE vs.t1_distrib ON CLUSTER vscluster (ts DATETIME,c1 VARCHAR) ENGINE=Distributed('vscluster','vs','t1')

ALTER does not work!
ALTER TABLE vs.t1_distrib ON CLUSTER vscluster ADD COLUMN c2 VARCHAR

Code: 371, e.displayText() = DB::Exception: Table t1_distrib isn't replicated, but shard #1 is replicated according to its cluster definition, e.what() = DB::Exception.

https://groups.google.com/forum/?utm_medium=email&utm_source=footer#!msg/clickhouse/BmsOrL2AMN4/eQnjeC1CAQAJ

[c3mb0]

Is this ever going to be fixed?

[cw9]

Hi, I'm hitting this issue as well, any plan to get this fixed?

[den-crane]

BTW I always used a workaround.
One more cluster with all nodes as dedicated shards (internal_replication=false).
So for this cluster any DDL just works at all nodes.

[alexey-milovidov]

Our internal users also have faced this issue.

It should be trivial to fix: just skip the check for Distributed tables.

[nvartolomei]

Shouldn't we do the same for Null tables? Or just remove the check altogether?