From 82dff84438e83d87adf9015bafb5198bb1b1d257 Mon Sep 17 00:00:00 2001 From: Anel Husakovic Date: Tue, 27 Oct 2020 00:54:07 +0100 Subject: MDEV-24018: SIGSEGV in Item_func_nextval::update_table on SELECT SETVAL - Cherry-pick a6987d9fb921a6638bb1a2397b89ca606fad6f49 and add test case --- mysql-test/suite/sql_sequence/next.result | 5 +++++ mysql-test/suite/sql_sequence/next.test | 6 ++++++ 2 files changed, 11 insertions(+) diff --git a/mysql-test/suite/sql_sequence/next.result b/mysql-test/suite/sql_sequence/next.result index fe761baa032..76991fbe68c 100644 --- a/mysql-test/suite/sql_sequence/next.result +++ b/mysql-test/suite/sql_sequence/next.result @@ -541,5 +541,10 @@ CREATE VIEW v AS SELECT 1; LOCK TABLE v READ; SELECT NEXT VALUE FOR v; ERROR 42S02: 'test.v' is not a SEQUENCE +# +# MDEV-24018: SIGSEGV in Item_func_nextval::update_table on SELECT SETVAL +# +SELECT SETVAL (v,0); +ERROR 42S02: 'test.v' is not a SEQUENCE UNLOCK TABLES; DROP VIEW v; diff --git a/mysql-test/suite/sql_sequence/next.test b/mysql-test/suite/sql_sequence/next.test index 5eac3b668ba..bfa6b1ce93e 100644 --- a/mysql-test/suite/sql_sequence/next.test +++ b/mysql-test/suite/sql_sequence/next.test @@ -288,5 +288,11 @@ CREATE VIEW v AS SELECT 1; LOCK TABLE v READ; --error ER_NOT_SEQUENCE SELECT NEXT VALUE FOR v; + +--echo # +--echo # MDEV-24018: SIGSEGV in Item_func_nextval::update_table on SELECT SETVAL +--echo # +--error ER_NOT_SEQUENCE +SELECT SETVAL (v,0); UNLOCK TABLES; DROP VIEW v; -- cgit v1.2.1