From bbabdaef31cc9286a35ae5b0aa9e53fe6d262cb7 Mon Sep 17 00:00:00 2001 From: Weijun-H Date: Wed, 23 Nov 2022 09:36:28 +0000 Subject: increase max field name Signed-off-by: Weijun-H --- mysql-test/suite/period/r/create.result | 8 ++++++++ mysql-test/suite/period/t/create.test | 11 +++++++++++ 2 files changed, 19 insertions(+) (limited to 'mysql-test/suite') 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 -- cgit v1.2.1