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

     1  create snapshot snapshot_01 for cluster;
     2  create account default_1 ADMIN_NAME admin IDENTIFIED BY '111111';
     3  create snapshot snapshot_02 for account default_1;
     4  select sleep(1);
     5  sleep(1)
     6  0
     7  create snapshot snapshot_03 for account default_1;
     8  select sleep(1);
     9  sleep(1)
    10  0
    11  create snapshot snapshot_04 for account default_1;
    12  show snapshots;
    13  SNAPSHOT_NAME    TIMESTAMP    SNAPSHOT_LEVEL    ACCOUNT_NAME    DATABASE_NAME    TABLE_NAME
    14  snapshot_04    2024-03-06 15:09:15    account    default_1        
    15  snapshot_03    2024-03-06 15:09:14    account    default_1        
    16  snapshot_01    2024-03-06 15:09:13    cluster            
    17  snapshot_02    2024-03-06 15:09:13    account    default_1        
    18  show snapshots where SNAPSHOT_NAME = 'snapshot_01';
    19  snapshot_name    timestamp    snapshot_level    account_name    database_name    table_name
    20  snapshot_01    2024-03-06 15:09:13    cluster            
    21  show snapshots where SNAPSHOT_LEVEL = 'cluster';
    22  snapshot_name    timestamp    snapshot_level    account_name    database_name    table_name
    23  snapshot_01    2024-03-06 15:09:13    cluster            
    24  show snapshots where ACCOUNT_NAME = 'default_1';
    25  snapshot_name    timestamp    snapshot_level    account_name    database_name    table_name
    26  snapshot_04    2024-03-06 15:09:15    account    default_1        
    27  snapshot_03    2024-03-06 15:09:14    account    default_1        
    28  snapshot_02    2024-03-06 15:09:13    account    default_1        
    29  DROP SNAPSHOT snapshot_01;
    30  DROP SNAPSHOT snapshot_02;
    31  DROP SNAPSHOT snapshot_03;
    32  DROP SNAPSHOT snapshot_04;
    33  create snapshot snapshot_05 for account default_1;
    34  select sleep(1);
    35  sleep(1)
    36  0
    37  create snapshot snapshot_06 for account default_1;
    38  select sleep(1);
    39  sleep(1)
    40  0
    41  create snapshot snapshot_07 for account default_1;
    42  show snapshots;
    43  SNAPSHOT_NAME    TIMESTAMP    SNAPSHOT_LEVEL    ACCOUNT_NAME    DATABASE_NAME    TABLE_NAME
    44  snapshot_07    2024-03-06 15:09:18    account    default_1        
    45  snapshot_06    2024-03-06 15:09:17    account    default_1        
    46  snapshot_05    2024-03-06 15:09:16    account    default_1        
    47  show snapshots where SNAPSHOT_NAME = 'snapshot_07';
    48  snapshot_name    timestamp    snapshot_level    account_name    database_name    table_name
    49  snapshot_07    2024-03-06 15:09:18    account    default_1        
    50  show snapshots where SNAPSHOT_LEVEL = 'account';
    51  snapshot_name    timestamp    snapshot_level    account_name    database_name    table_name
    52  snapshot_07    2024-03-06 15:09:18    account    default_1        
    53  snapshot_06    2024-03-06 15:09:17    account    default_1        
    54  snapshot_05    2024-03-06 15:09:16    account    default_1        
    55  show snapshots where ACCOUNT_NAME = 'default_1';
    56  snapshot_name    timestamp    snapshot_level    account_name    database_name    table_name
    57  snapshot_07    2024-03-06 15:09:18    account    default_1        
    58  snapshot_06    2024-03-06 15:09:17    account    default_1        
    59  snapshot_05    2024-03-06 15:09:16    account    default_1        
    60  drop account default_1;
    61  create snapshot snapshot_08 for account default_1;
    62  internal error: account default_1 does not exist
    63  create account default_1 ADMIN_NAME admin IDENTIFIED BY '111111';
    64  create snapshot snapshot_09 for account default_1;
    65  select sleep(1);
    66  sleep(1)
    67  0
    68  create snapshot snapshot_09 for account default_1;
    69  internal error: snapshot snapshot_09 already exists
    70  create account default_2 ADMIN_NAME admin IDENTIFIED BY '111111';
    71  create snapshot snapshot_10 for account default_2;
    72  show snapshots;
    73  SNAPSHOT_NAME    TIMESTAMP    SNAPSHOT_LEVEL    ACCOUNT_NAME    DATABASE_NAME    TABLE_NAME
    74  snapshot_10    2024-03-06 15:09:20    account    default_2        
    75  snapshot_09    2024-03-06 15:09:18    account    default_1        
    76  create snapshot snapshot_11 for account default_1;
    77  create snapshot snapshot_12 for account default_2;
    78  internal error: only sys tenant can create tenant level snapshot for other tenant
    79  create snapshot snapshot_13 for cluster;
    80  internal error: only sys tenant can create cluster level snapshot
    81  show snapshots;
    82  SNAPSHOT_NAME    TIMESTAMP    SNAPSHOT_LEVEL    ACCOUNT_NAME    DATABASE_NAME    TABLE_NAME
    83  snapshot_11    2024-03-06 15:09:20    account    default_1        
    84  create user  efg identified by '111';
    85  create snapshot snapshot_14 for account default_1;
    86  internal error: do not have privilege to execute the statement
    87  create snapshot snapshot_15 for account default_2;
    88  internal error: do not have privilege to execute the statement
    89  drop snapshot if exists snapshot_09;
    90  drop snapshot if exists snapshot_10;
    91  drop account default_1;
    92  drop account default_2;