diff options
| author | unknown <mikael@c-4908e253.1238-1-64736c10.cust.bredbandsbolaget.se> | 2006-04-01 12:11:21 -0500 |
|---|---|---|
| committer | unknown <mikael@c-4908e253.1238-1-64736c10.cust.bredbandsbolaget.se> | 2006-04-01 12:11:21 -0500 |
| commit | a11399c9209f46a9083091c64cd3a90cf29bfc0c (patch) | |
| tree | 36e722afc4381e53672d1aa14d8d345a9dec25cc /mysql-test | |
| parent | d5db81aa34da471ab1f4cd84317e85ec83f42fdf (diff) | |
| parent | 9eccbdaa887a946994b92cea4b33b51d1a39cf1d (diff) | |
| download | mariadb-git-a11399c9209f46a9083091c64cd3a90cf29bfc0c.tar.gz | |
Merge mronstrom@bk-internal.mysql.com:/home/bk/mysql-5.1-new
into c-4908e253.1238-1-64736c10.cust.bredbandsbolaget.se:/home/pappa/bug13520
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/partition.result | 10 | ||||
| -rw-r--r-- | mysql-test/t/partition.test | 19 |
2 files changed, 29 insertions, 0 deletions
diff --git a/mysql-test/r/partition.result b/mysql-test/r/partition.result index 970e5234ca8..2e293df50e2 100644 --- a/mysql-test/r/partition.result +++ b/mysql-test/r/partition.result @@ -718,6 +718,16 @@ CALL test.p1(13); Warnings: Warning 1196 Some non-transactional changed tables couldn't be rolled back drop table t1; +CREATE TABLE t1 (a int not null) +partition by key(a) +(partition p0 COMMENT='first partition'); +drop table t1; +CREATE TABLE t1 (`a b` int not null) +partition by key(`a b`); +drop table t1; +CREATE TABLE t1 (`a b` int not null) +partition by hash(`a b`); +drop table t1; create table t1 (f1 integer) partition by range(f1) (partition p1 values less than (0), partition p2 values less than (10)); insert into t1 set f1 = null; diff --git a/mysql-test/t/partition.test b/mysql-test/t/partition.test index b3a6319643d..a3aa3f6f025 100644 --- a/mysql-test/t/partition.test +++ b/mysql-test/t/partition.test @@ -850,6 +850,25 @@ CALL test.p1(13); drop table t1; # +# Bug 13520: Problem with delimiters in COMMENT DATA DIRECTORY .. +# +CREATE TABLE t1 (a int not null) +partition by key(a) +(partition p0 COMMENT='first partition'); +drop table t1; + +# +# Bug 13433: Problem with delimited identifiers +# +CREATE TABLE t1 (`a b` int not null) +partition by key(`a b`); +drop table t1; + +CREATE TABLE t1 (`a b` int not null) +partition by hash(`a b`); +drop table t1; + +# # Bug#18053 Partitions: crash if null # Bug#18070 Partitions: wrong result on WHERE ... IS NULL # |