diff options
| author | unknown <mikael@dator3.(none)> | 2007-04-20 18:35:16 +0200 |
|---|---|---|
| committer | unknown <mikael@dator3.(none)> | 2007-04-20 18:35:16 +0200 |
| commit | 2a2b1ea8258a151f2420e8b6226b3fad629956ad (patch) | |
| tree | 83f54976d02e37311f895d3581ca830cc130e0fb /mysql-test | |
| parent | 61aaff4a01647d11dae851afda810cee07e99d1d (diff) | |
| download | mariadb-git-2a2b1ea8258a151f2420e8b6226b3fad629956ad.tar.gz | |
BUG#18198
Added new test cases, fixed bugs in relation to those
mysql-test/r/partition_charset.result:
New test case
mysql-test/r/partition_list.result:
New test case
mysql-test/t/partition_list.test:
New test case
sql/partition_info.cc:
Missing initialisation
sql/sql_partition.cc:
key_restore made use of field->ptr in VARCHAR fields and
when used with REPLACE it caused the key_restore to
become against table->record[0] when buf pointed to
table->record[1]
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/partition_charset.result | 6 | ||||
| -rw-r--r-- | mysql-test/r/partition_list.result | 4 | ||||
| -rw-r--r-- | mysql-test/t/partition_list.test | 2 |
3 files changed, 11 insertions, 1 deletions
diff --git a/mysql-test/r/partition_charset.result b/mysql-test/r/partition_charset.result index 665e5d55f8f..bb6cb5e3bef 100644 --- a/mysql-test/r/partition_charset.result +++ b/mysql-test/r/partition_charset.result @@ -16,3 +16,9 @@ s1 1 3 drop table t1; +create table t1 (a varchar(1), primary key (a)) +partition by list (ascii(a)) +(partition p1 values in (65)); +insert into t1 values ('A'); +replace into t1 values ('A'); +drop table t1; diff --git a/mysql-test/r/partition_list.result b/mysql-test/r/partition_list.result index e64a7a8d154..a68a67c6386 100644 --- a/mysql-test/r/partition_list.result +++ b/mysql-test/r/partition_list.result @@ -295,3 +295,7 @@ select * from t1; a 100 drop table t1; +create table t1 (a char(1)) +partition by list (ascii(ucase(a))) +(partition p1 values in (2)); +ERROR HY000: This partition function is not allowed diff --git a/mysql-test/t/partition_list.test b/mysql-test/t/partition_list.test index 7d71d66f2d9..1c76de9d55a 100644 --- a/mysql-test/t/partition_list.test +++ b/mysql-test/t/partition_list.test @@ -179,7 +179,7 @@ insert into t1 values (null); select * from t1; drop table t1; --- error ER_PARTITION_FUNC_NOT_ALLOWED +--error ER_PARTITION_FUNCTION_IS_NOT_ALLOWED create table t1 (a char(1)) partition by list (ascii(ucase(a))) (partition p1 values in (2)); |