diff options
| author | Mikael Ronstrom <mikael@mysql.com> | 2009-10-28 01:11:17 +0100 |
|---|---|---|
| committer | Mikael Ronstrom <mikael@mysql.com> | 2009-10-28 01:11:17 +0100 |
| commit | 10fed1aca0096acb135c2065233e84d61b00b9cf (patch) | |
| tree | 32eac76c7c0b41298c58cd40bc85138e177d8a98 /mysql-test/t/partition_column.test | |
| parent | cc43a2089cf6f45afb2cb5c15e2a077b075b80f8 (diff) | |
| download | mariadb-git-10fed1aca0096acb135c2065233e84d61b00b9cf.tar.gz | |
BUG#48165, needed to introduce length restrictions on partitioning fields to ensure that no stack overruns occur
Diffstat (limited to 'mysql-test/t/partition_column.test')
| -rw-r--r-- | mysql-test/t/partition_column.test | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/t/partition_column.test b/mysql-test/t/partition_column.test index 16f12bfad04..1c5b859a211 100644 --- a/mysql-test/t/partition_column.test +++ b/mysql-test/t/partition_column.test @@ -9,6 +9,23 @@ drop table if exists t1; --enable_warnings # +# BUG#48164, too long partition fields causes crash +# +--error ER_PARTITION_FIELDS_TOO_LONG +create table t1 (a varchar(1500), b varchar(1570)) +partition by list column_list(a,b) +( partition p0 values in (('a','b'))); + +create table t1 (a varchar(1023) character set utf8 collate utf8_spanish2_ci) +partition by range column_list(a) +( partition p0 values less than ('CZ'), + partition p1 values less than ('CH'), + partition p2 values less than ('D')); +insert into t1 values ('czz'),('chi'),('ci'),('cg'); +select * from t1 where a between 'cg' AND 'ci'; +drop table t1; + +# # BUG#48165, sql_mode gives error # set @@sql_mode=allow_invalid_dates; |