Debian Codegraph @

mysql-test/suite/sql_sequence/binlog.result

raw
1 create or replace sequence s1 cache 3;
2 select next value for s1, minimum_value from s1 where maximum_value> 1;
3 next value for s1 minimum_value
4 1 1
5 select next value for s1, minimum_value from s1 where maximum_value> 2;
6 next value for s1 minimum_value
7 2 1
8 select next value for s1, minimum_value from s1 where maximum_value> 3;
9 next value for s1 minimum_value
10 3 1
11 select next value for s1, minimum_value from s1 where maximum_value> 4;
12 next value for s1 minimum_value
13 4 1
14 alter sequence s1 maxvalue 1000;
15 optimize table s1;
16 Table Op Msg_type Msg_text
17 test.s1 optimize note The storage engine for the table doesn't support optimize
18 analyze table s1;
19 Table Op Msg_type Msg_text
20 test.s1 analyze note The storage engine for the table doesn't support analyze
21 repair table s1;
22 Table Op Msg_type Msg_text
23 test.s1 repair status OK
24 check table s1;
25 Table Op Msg_type Msg_text
26 test.s1 check note The storage engine for the table doesn't support check
27 rename table s1 to tmp_s;
28 rename table tmp_s to s1;
29 drop sequence s1;
30 include/show_binlog_events.inc
31 Log_name Pos Event_type Server_id End_log_pos Info
32 master-bin.000001 # Gtid # # GTID #-#-#
33 master-bin.000001 # Query # # use `test`; create or replace sequence s1 cache 3
34 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
35 master-bin.000001 # Annotate_rows # # select next value for s1, minimum_value from s1 where maximum_value> 1
36 master-bin.000001 # Table_map # # table_id: # (test.s1)
37 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
38 master-bin.000001 # Query # # COMMIT
39 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
40 master-bin.000001 # Annotate_rows # # select next value for s1, minimum_value from s1 where maximum_value> 4
41 master-bin.000001 # Table_map # # table_id: # (test.s1)
42 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
43 master-bin.000001 # Query # # COMMIT
44 master-bin.000001 # Gtid # # GTID #-#-#
45 master-bin.000001 # Query # # use `test`; alter sequence s1 maxvalue 1000
46 master-bin.000001 # Gtid # # GTID #-#-#
47 master-bin.000001 # Query # # use `test`; optimize table s1
48 master-bin.000001 # Gtid # # GTID #-#-#
49 master-bin.000001 # Query # # use `test`; analyze table s1
50 master-bin.000001 # Gtid # # GTID #-#-#
51 master-bin.000001 # Query # # use `test`; repair table s1
52 master-bin.000001 # Gtid # # GTID #-#-#
53 master-bin.000001 # Query # # use `test`; rename table s1 to tmp_s
54 master-bin.000001 # Gtid # # GTID #-#-#
55 master-bin.000001 # Query # # use `test`; rename table tmp_s to s1
56 master-bin.000001 # Gtid # # GTID #-#-#
57 master-bin.000001 # Query # # use `test`; DROP SEQUENCE `s1` /* generated by server */