github.com/matrixorigin/matrixone@v0.7.0/test/distributed/cases/query_result/query_result.sql (about)

     1  set global save_query_result = on;
     2  drop table if exists tt;
     3  create table tt (a int);
     4  insert into tt values(1), (2);
     5  select * from tt;
     6  select * from result_scan(last_query_id()) as u;
     7  select * from tt;
     8  select count(*) from meta_scan(last_query_id()) as u;
     9  set global save_query_result = off;
    10  
    11  select * from tt;
    12  select * from result_scan(last_query_id()) as u;
    13  set global save_query_result = on;
    14  drop table if exists t2;
    15  create table t2 (a int, b int, c int);
    16  insert into t2 values(1, 2, 3), (1, 2, 3);
    17  select c from tt, t2 where tt.a = t2.a;
    18  select * from result_scan(last_query_id()) as u;
    19  select c from tt, t2 where tt.a = t2.a;
    20  select t2.b from result_scan(last_query_id()) as u, t2 where u.c = t2.c;
    21  select * from result_scan(last_query_id()) as u;
    22  select c from tt, t2 where tt.a = t2.a;
    23  select * from result_scan(last_query_id()) as u, result_scan(last_query_id()) as v limit 1;
    24  set global save_query_result = off;
    25  
    26  set global save_query_result = on;
    27  select tt.a from tt, t2;
    28  select tables from meta_scan(last_query_id()) as u;
    29  set global query_result_maxsize = 0;
    30  select tt.a from tt, t2;
    31  select char_length(result_path) from meta_scan(last_query_id()) as u;
    32  select tt.a from tt, t2;
    33  select result_size = 0 from meta_scan(last_query_id()) as u;
    34  set global save_query_result = off;
    35  
    36  set global save_query_result = on;
    37  set global query_result_maxsize = 100;
    38  create role rrrqqq;
    39  grant rrrqqq to dump;
    40  select * from tt;
    41  set role rrrqqq;
    42  select * from meta_scan(last_query_id(-2)) as u;
    43  set role moadmin;
    44  create database db111;
    45  create table db111.tt1 (a int);
    46  insert into db111.tt1 values(1), (2);
    47  create table db111.tt2 (a int);
    48  insert into db111.tt2 values(1), (2);
    49  grant select on table db111.tt1 to rrrqqq;
    50  select * from db111.tt1;
    51  select * from db111.tt2;
    52  set role rrrqqq;
    53  select * from result_scan(last_query_id(-3)) as u;
    54  select * from meta_scan(last_query_id(-3)) as u;
    55  set role moadmin;
    56  drop role rrrqqq;
    57  set global save_query_result = off;