v.23.12Improvement
Forbid CREATE TABLE AS SELECT for Replicated table engines in experimental Replicated database
ForbidCREATE TABLE ... AS SELECTqueries forReplicatedtable engines in the experimentalReplicateddatabase because they are not supported. Reference #35408. #57796 (Nikolay Degterinsky).
Why it matters
This feature prevents users from executing unsupportedCREATE TABLE ... AS SELECT queries on Replicated tables within the experimental Replicated database engine. It helps avoid potential inconsistencies or unexpected behavior by enforcing proper table creation methods for replicated tables.How to use it
Users simply need to avoid usingCREATE TABLE ... AS SELECT syntax with Replicated engines. If attempted, the query will be forbidden to ensure stability and correctness of replicated tables.