create or replace sequence s1 cache 3;
select next value for s1, minimum_value from s1 where maximum_value> 1;
next value for s1	minimum_value
1	1
select next value for s1, minimum_value from s1 where maximum_value> 2;
next value for s1	minimum_value
2	1
select next value for s1, minimum_value from s1 where maximum_value> 3;
next value for s1	minimum_value
3	1
select next value for s1, minimum_value from s1 where maximum_value> 4;
next value for s1	minimum_value
4	1
alter sequence s1 maxvalue 1000;
drop sequence s1;
include/show_binlog_events.inc
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	#	Gtid	#	#	GTID #-#-#
master-bin.000001	#	Query	#	#	use `test`; create or replace sequence s1 cache 3
master-bin.000001	#	Gtid	#	#	BEGIN GTID #-#-#
master-bin.000001	#	Annotate_rows	#	#	select next value for s1, minimum_value from s1 where maximum_value> 1
master-bin.000001	#	Table_map	#	#	table_id: # (test.s1)
master-bin.000001	#	Write_rows_v1	#	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	#	#	COMMIT
master-bin.000001	#	Gtid	#	#	BEGIN GTID #-#-#
master-bin.000001	#	Annotate_rows	#	#	select next value for s1, minimum_value from s1 where maximum_value> 4
master-bin.000001	#	Table_map	#	#	table_id: # (test.s1)
master-bin.000001	#	Write_rows_v1	#	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	#	#	COMMIT
master-bin.000001	#	Gtid	#	#	GTID #-#-#
master-bin.000001	#	Query	#	#	use `test`; alter sequence s1 maxvalue 1000
master-bin.000001	#	Gtid	#	#	GTID #-#-#
master-bin.000001	#	Query	#	#	use `test`; DROP SEQUENCE `s1` /* generated by server */