github.com/matrixorigin/matrixone@v0.7.0/test/distributed/cases/query_result/query_result.result (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  a
     7  1
     8  2
     9  select * from result_scan(last_query_id()) as u;
    10  a
    11  1
    12  2
    13  select * from tt;
    14  a
    15  1
    16  2
    17  select count(*) from meta_scan(last_query_id()) as u;
    18  count(*)
    19  1
    20  set global save_query_result = off;
    21  
    22  select * from tt;
    23  a
    24  1
    25  2
    26  select * from result_scan(last_query_id()) as u;
    27  no configure: save query result
    28  set global save_query_result = on;
    29  drop table if exists t2;
    30  create table t2 (a int, b int, c int);
    31  insert into t2 values(1, 2, 3), (1, 2, 3);
    32  select c from tt, t2 where tt.a = t2.a;
    33  c
    34  3
    35  3
    36  select * from result_scan(last_query_id()) as u;
    37  c
    38  3
    39  3
    40  select c from tt, t2 where tt.a = t2.a;
    41  c
    42  3
    43  3
    44  select t2.b from result_scan(last_query_id()) as u, t2 where u.c = t2.c;
    45  b
    46  2
    47  2
    48  2
    49  2
    50  select * from result_scan(last_query_id()) as u;
    51  b
    52  2
    53  2
    54  2
    55  2
    56  select c from tt, t2 where tt.a = t2.a;
    57  c
    58  3
    59  3
    60  select * from result_scan(last_query_id()) as u, result_scan(last_query_id()) as v limit 1;
    61  c    c
    62  3    3
    63  set global save_query_result = off;
    64  
    65  set global save_query_result = on;
    66  select tt.a from tt, t2;
    67  a
    68  1
    69  1
    70  2
    71  2
    72  select tables from meta_scan(last_query_id()) as u;
    73  tables
    74  tt, t2
    75  set global query_result_maxsize = 0;
    76  select tt.a from tt, t2;
    77  a
    78  1
    79  1
    80  2
    81  2
    82  select char_length(result_path) from meta_scan(last_query_id()) as u;
    83  char_length(result_path)
    84  0
    85  select tt.a from tt, t2;
    86  a
    87  1
    88  1
    89  2
    90  2
    91  select result_size = 0 from meta_scan(last_query_id()) as u;
    92  result_size = 0
    93  true
    94  set global save_query_result = off;
    95  
    96  set global save_query_result = on;
    97  set global query_result_maxsize = 100;
    98  create role rrrqqq;
    99  grant rrrqqq to dump;
   100  select * from tt;
   101  a
   102  1
   103  2
   104  set role rrrqqq;
   105  select * from meta_scan(last_query_id(-2)) as u;
   106  internal error: do not have privilege to execute the statement
   107  set role moadmin;
   108  create database db111;
   109  create table db111.tt1 (a int);
   110  insert into db111.tt1 values(1), (2);
   111  create table db111.tt2 (a int);
   112  insert into db111.tt2 values(1), (2);
   113  grant select on table db111.tt1 to rrrqqq;
   114  select * from db111.tt1;
   115  a
   116  1
   117  2
   118  select * from db111.tt2;
   119  a
   120  1
   121  2
   122  set role rrrqqq;
   123  select * from result_scan(last_query_id(-3)) as u;
   124  a
   125  1
   126  2
   127  select * from meta_scan(last_query_id(-3)) as u;
   128  internal error: do not have privilege to execute the statement
   129  set role moadmin;
   130  drop role rrrqqq;
   131  set global save_query_result = off;