summaryrefslogtreecommitdiff
path: root/mysql-test/main
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/main
parentda03d8d99f7ff441cc1079dc074fde204751ef63 (diff)
downloadmariadb-git-bbabdaef31cc9286a35ae5b0aa9e53fe6d262cb7.tar.gz
increase max field name
Signed-off-by: Weijun-H <huangweijun1001@gmail.com>
Diffstat (limited to 'mysql-test/main')
-rw-r--r--mysql-test/main/period_name.result9
-rw-r--r--mysql-test/main/period_name.test11
2 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/main/period_name.result b/mysql-test/main/period_name.result
new file mode 100644
index 00000000000..85004469cd1
--- /dev/null
+++ b/mysql-test/main/period_name.result
@@ -0,0 +1,9 @@
+#
+# 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/main/period_name.test b/mysql-test/main/period_name.test
new file mode 100644
index 00000000000..bc9178350be
--- /dev/null
+++ b/mysql-test/main/period_name.test
@@ -0,0 +1,11 @@
+--echo #
+--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;