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

     1  create snapshot snapshot_01 for account sys;
     2  create database if not exists snapshot_read;
     3  use snapshot_read;
     4  create snapshot snapshot_02 for account sys;
     5  create table test_snapshot_read (a int);
     6  INSERT INTO test_snapshot_read (a) VALUES(1), (2), (3), (4), (5),(6), (7), (8), (9), (10), (11), (12),(13), (14), (15), (16), (17), (18), (19), (20),(21), (22), (23), (24), (25), (26), (27), (28), (29), (30),(31), (32), (33), (34), (35), (36), (37), (38), (39), (40),(41), (42), (43), (44), (45), (46), (47), (48), (49), (50),(51), (52), (53), (54), (55), (56), (57), (58), (59), (60),(61), (62), (63), (64), (65), (66), (67), (68), (69), (70),(71), (72), (73), (74), (75), (76), (77), (78), (79), (80), (81), (82), (83), (84), (85), (86), (87), (88), (89), (90),(91), (92), (93), (94), (95), (96), (97), (98), (99), (100);
     7  select count(*) from snapshot_read.test_snapshot_read;
     8  count(*)
     9  100
    10  select count(*) from snapshot_read.test_snapshot_read{snapshot = 'snapshot_01'};
    11  invalid database snapshot_read
    12  select count(*) from snapshot_read.test_snapshot_read{snapshot = 'snapshot_02'};
    13  SQL parser error: table "test_snapshot_read" does not exist
    14  drop snapshot snapshot_01;
    15  drop snapshot snapshot_02;
    16  drop database snapshot_read;
    17  drop account if exists test_account;
    18  create account test_account admin_name = 'test_user' identified by '111';
    19  create snapshot snapshot_01 for account test_account;
    20  create database if not exists snapshot_read;
    21  use snapshot_read;
    22  create snapshot snapshot_02 for account test_account;
    23  create table test_snapshot_read (a int);
    24  INSERT INTO test_snapshot_read (a) VALUES(1), (2), (3), (4), (5),(6), (7), (8), (9), (10), (11), (12),(13), (14), (15), (16), (17), (18), (19), (20),(21), (22), (23), (24), (25), (26), (27), (28), (29), (30),(31), (32), (33), (34), (35), (36), (37), (38), (39), (40),(41), (42), (43), (44), (45), (46), (47), (48), (49), (50),(51), (52), (53), (54), (55), (56), (57), (58), (59), (60),(61), (62), (63), (64), (65), (66), (67), (68), (69), (70),(71), (72), (73), (74), (75), (76), (77), (78), (79), (80), (81), (82), (83), (84), (85), (86), (87), (88), (89), (90),(91), (92), (93), (94), (95), (96), (97), (98), (99), (100);
    25  select count(*) from snapshot_read.test_snapshot_read;
    26  count(*)
    27  100
    28  select count(*) from snapshot_read.test_snapshot_read{snapshot = 'snapshot_01'};
    29  invalid database snapshot_read
    30  select count(*) from snapshot_read.test_snapshot_read{snapshot = 'snapshot_02'};
    31  SQL parser error: table "test_snapshot_read" does not exist
    32  drop snapshot snapshot_01;
    33  drop snapshot snapshot_02;
    34  drop database snapshot_read;
    35  drop account if exists test_account;
    36  create database if not exists snapshot_read;
    37  use snapshot_read;
    38  create table test_snapshot_read (a int);
    39  INSERT INTO test_snapshot_read (a) VALUES(1), (2), (3), (4), (5),(6), (7), (8), (9), (10), (11), (12),(13), (14), (15), (16), (17), (18), (19), (20),(21), (22), (23), (24), (25), (26), (27), (28), (29), (30),(31), (32), (33), (34), (35), (36), (37), (38), (39), (40),(41), (42), (43), (44), (45), (46), (47), (48), (49), (50),(51), (52), (53), (54), (55), (56), (57), (58), (59), (60),(61), (62), (63), (64), (65), (66), (67), (68), (69), (70),(71), (72), (73), (74), (75), (76), (77), (78), (79), (80), (81), (82), (83), (84), (85), (86), (87), (88), (89), (90),(91), (92), (93), (94), (95), (96), (97), (98), (99), (100);
    40  select count(*) from test_snapshot_read;
    41  count(*)
    42  100
    43  create snapshot snapshot_01 for account sys;
    44  drop table test_snapshot_read;
    45  select count(*) from snapshot_read.test_snapshot_read{snapshot = 'snapshot_01'};
    46  count(*)
    47  100
    48  drop database if exists snapshot_read;
    49  drop snapshot snapshot_01;
    50  create database if not exists snapshot_read;
    51  use snapshot_read;
    52  create table test_snapshot_read (a int);
    53  INSERT INTO test_snapshot_read (a) VALUES(1), (2), (3), (4), (5),(6), (7), (8), (9), (10), (11), (12),(13), (14), (15), (16), (17), (18), (19), (20),(21), (22), (23), (24), (25), (26), (27), (28), (29), (30),(31), (32), (33), (34), (35), (36), (37), (38), (39), (40),(41), (42), (43), (44), (45), (46), (47), (48), (49), (50),(51), (52), (53), (54), (55), (56), (57), (58), (59), (60),(61), (62), (63), (64), (65), (66), (67), (68), (69), (70),(71), (72), (73), (74), (75), (76), (77), (78), (79), (80), (81), (82), (83), (84), (85), (86), (87), (88), (89), (90),(91), (92), (93), (94), (95), (96), (97), (98), (99), (100);
    54  select count(*) from test_snapshot_read;
    55  count(*)
    56  100
    57  create snapshot snapshot_01 for account sys;
    58  drop database snapshot_read;
    59  select count(*) from snapshot_read.test_snapshot_read{snapshot = 'snapshot_01'};
    60  count(*)
    61  100
    62  drop database if exists snapshot_read;
    63  drop snapshot snapshot_01;