summaryrefslogtreecommitdiff
path: root/mysql-test/suite
diff options
context:
space:
mode:
authorWeijun-H <huangweijun1001@gmail.com>2022-11-23 09:36:28 +0000
committerNikita Malyavin <nikitamalyavin@gmail.com>2022-11-27 05:11:39 +1000
commitbbabdaef31cc9286a35ae5b0aa9e53fe6d262cb7 (patch)
treea5f67046742270d64bf0c8ac07db921cdcabcc9b /mysql-test/suite
parentda03d8d99f7ff441cc1079dc074fde204751ef63 (diff)
downloadmariadb-git-bbabdaef31cc9286a35ae5b0aa9e53fe6d262cb7.tar.gz
increase max field name
Signed-off-by: Weijun-H <huangweijun1001@gmail.com>
Diffstat (limited to 'mysql-test/suite')
-rw-r--r--mysql-test/suite/period/r/create.result8
-rw-r--r--mysql-test/suite/period/t/create.test11
2 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/suite/period/r/create.result b/mysql-test/suite/period/r/create.result
index 58e0b82d085..eb4e110b1b2 100644
--- a/mysql-test/suite/period/r/create.result
+++ b/mysql-test/suite/period/r/create.result
@@ -100,3 +100,11 @@ show status like "Feature_application_time_periods";
Variable_name Value
Feature_application_time_periods 6
drop table t;
+# MDEV-29387: Period name with more than 32 symbols crashes the server
+#
+# test 34 symbols
+create table t2 (s date, e date, period for `abcd123456789012345678901234567890` (s,e));
+drop table t2;
+# test 64 symbols
+create table t2 (s date, e date, period for `abcd123456789012345678901234567890123456789012345678901234567890` (s,e));
+drop table t2;
diff --git a/mysql-test/suite/period/t/create.test b/mysql-test/suite/period/t/create.test
index 49dcc6ad3c7..081c37d2e9f 100644
--- a/mysql-test/suite/period/t/create.test
+++ b/mysql-test/suite/period/t/create.test
@@ -85,3 +85,14 @@ insert t values (2, '2001-01-01', '2001-01-01');
show status like "Feature_application_time_periods";
drop table t;
+
+--echo # MDEV-29387: Period name with more than 32 symbols crashes the server
+--echo #
+
+--echo # test 34 symbols
+create table t2 (s date, e date, period for `abcd123456789012345678901234567890` (s,e));
+drop table t2;
+
+--echo # test 64 symbols
+create table t2 (s date, e date, period for `abcd123456789012345678901234567890123456789012345678901234567890` (s,e));
+drop table t2; \ No newline at end of file