diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2021-08-31 10:04:56 +0300 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2021-08-31 10:04:56 +0300 |
| commit | e62120cec7aa21b9cf77773ecb0935b4b48ed26c (patch) | |
| tree | 38d057014f832f6ba55be1e720c0437f83e4a7e4 /mysql-test/suite | |
| parent | 1a69e1588b47403972a2475216e34dc3ff554eec (diff) | |
| parent | 04647611260a77041186ace12f96b05d50bed4da (diff) | |
| download | mariadb-git-e62120cec7aa21b9cf77773ecb0935b4b48ed26c.tar.gz | |
Merge 10.4 into 10.5
Diffstat (limited to 'mysql-test/suite')
| -rw-r--r-- | mysql-test/suite/sql_sequence/default.result | 10 | ||||
| -rw-r--r-- | mysql-test/suite/sql_sequence/default.test | 12 |
2 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/suite/sql_sequence/default.result b/mysql-test/suite/sql_sequence/default.result index 14abc656423..4969e832652 100644 --- a/mysql-test/suite/sql_sequence/default.result +++ b/mysql-test/suite/sql_sequence/default.result @@ -183,3 +183,13 @@ ALTER TABLE t1 add column d int default next value for s_not_exits; ERROR 42S02: Table 'test.s_not_exits' doesn't exist drop table t1; drop sequence s1; +# +# MDEV 22785 Crash with prepared statements and NEXTVAL() +# +CREATE SEQUENCE s; +CREATE TABLE t1 (id int NOT NULL DEFAULT NEXTVAL(s), PRIMARY KEY (id)); +PREPARE stmt FROM " INSERT INTO t1 () values ()"; +INSERT INTO t1 () values (); +EXECUTE stmt; +DROP TABLE t1; +DROP SEQUENCE s; diff --git a/mysql-test/suite/sql_sequence/default.test b/mysql-test/suite/sql_sequence/default.test index 017165c1a80..e7c13211013 100644 --- a/mysql-test/suite/sql_sequence/default.test +++ b/mysql-test/suite/sql_sequence/default.test @@ -123,3 +123,15 @@ ALTER TABLE t1 add column c int; ALTER TABLE t1 add column d int default next value for s_not_exits; drop table t1; drop sequence s1; + +--echo # +--echo # MDEV 22785 Crash with prepared statements and NEXTVAL() +--echo # +CREATE SEQUENCE s; +CREATE TABLE t1 (id int NOT NULL DEFAULT NEXTVAL(s), PRIMARY KEY (id)); +PREPARE stmt FROM " INSERT INTO t1 () values ()"; +INSERT INTO t1 () values (); +EXECUTE stmt; +# Cleanup +DROP TABLE t1; +DROP SEQUENCE s; |