github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/view/replace_view.result (about)

     1  drop table if exists t1;
     2  create table t1 (a int, b int);
     3  insert into t1 values (1, 11), (2, 22), (3, 33);
     4  insert into t2 values (1, "aa"), (2, "bb");
     5  no such table replace_view.t2
     6  create view v1 as select * from t1;
     7  select * from v1;
     8  a    b
     9  1    11
    10  2    22
    11  3    33
    12  select * from v1 where a > 1;
    13  a    b
    14  2    22
    15  3    33
    16  create view v1 as select * from t1 where a > 1;
    17  table v1 already exists
    18  select * from v1;
    19  a    b
    20  1    11
    21  2    22
    22  3    33
    23  create or replace view v1 as select * from t1 where a > 1;
    24  select * from v1;
    25  a    b
    26  2    22
    27  3    33
    28  drop table t1;
    29  drop view v1;