From c6eeacd10f87eb437097d755d8dd29211ebdab87 Mon Sep 17 00:00:00 2001 From: Rucha Deodhar Date: Mon, 28 Mar 2022 15:12:33 +0530 Subject: MDEV-13005: Fixing bugs in SEQUENCE, part 3, 3/5 Task 3: Added an additional condition for SEQUENCE option to check if cache < 0. --- sql/sql_sequence.cc | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'sql/sql_sequence.cc') diff --git a/sql/sql_sequence.cc b/sql/sql_sequence.cc index 03f2f1b117f..367fbad144c 100644 --- a/sql/sql_sequence.cc +++ b/sql/sql_sequence.cc @@ -121,7 +121,7 @@ bool sequence_definition::check_and_adjust(bool set_reserved_until) start >= min_value && max_value != LONGLONG_MAX && min_value != LONGLONG_MIN && - cache < (LONGLONG_MAX - max_increment) / max_increment && + cache >= 0 && cache < (LONGLONG_MAX - max_increment) / max_increment && ((real_increment > 0 && reserved_until >= min_value) || (real_increment < 0 && reserved_until <= max_value))) DBUG_RETURN(FALSE); -- cgit v1.2.1