summaryrefslogtreecommitdiff
path: root/sql/sql_sequence.cc
diff options
context:
space:
mode:
authorRucha Deodhar <rucha.deodhar@mariadb.com>2022-03-28 15:12:33 +0530
committerRucha Deodhar <rucha.deodhar@mariadb.com>2022-03-30 15:12:49 +0530
commitc6eeacd10f87eb437097d755d8dd29211ebdab87 (patch)
treee938184db31f23ea83d4c4171a490eeaa98e2d1e /sql/sql_sequence.cc
parent0b9842a3e766ec56ff3e14bec387dc639677c4db (diff)
downloadmariadb-git-c6eeacd10f87eb437097d755d8dd29211ebdab87.tar.gz
MDEV-13005: Fixing bugs in SEQUENCE, part 3, 3/5
Task 3: Added an additional condition for SEQUENCE option to check if cache < 0.
Diffstat (limited to 'sql/sql_sequence.cc')
-rw-r--r--sql/sql_sequence.cc2
1 files changed, 1 insertions, 1 deletions
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);