text: SET allow_experimental_live_view = 1;
  
  DROP TABLE IF EXISTS lv;
  DROP TABLE IF EXISTS mt;
  
  CREATE TABLE mt (a Int32) Engine=MergeTree order by tuple();
  CREATE LIVE VIEW lv AS SELECT * FROM (SELECT sum(a) FROM mt);
  
  INSERT INTO mt VALUES (1),(2),(3);
  
  SELECT *,_version FROM lv;
  SELECT *,_version FROM lv;
  
  INSERT INTO mt VALUES (1),(2),(3);
  
  SELECT *,_version FROM lv;
  SELECT *,_version FROM lv;
  
  DROP TABLE lv;
  DROP TABLE mt;
  