diff options
| author | unknown <mikael@c-520ae253.1238-1-64736c10.cust.bredbandsbolaget.se> | 2006-04-01 00:59:25 -0500 |
|---|---|---|
| committer | unknown <mikael@c-520ae253.1238-1-64736c10.cust.bredbandsbolaget.se> | 2006-04-01 00:59:25 -0500 |
| commit | 9eccbdaa887a946994b92cea4b33b51d1a39cf1d (patch) | |
| tree | 9c875658b18b988129a7c7ea507ecabe9d9fc99b /mysql-test | |
| parent | 561c21c3f970d4a29d8891c48cb91437a3c0d7e7 (diff) | |
| parent | 6f2d033ca7d0e84f9fc7f40b5fcdc609fe0e220b (diff) | |
| download | mariadb-git-9eccbdaa887a946994b92cea4b33b51d1a39cf1d.tar.gz | |
Merge mronstrom@bk-internal.mysql.com:/home/bk/mysql-5.1-new
into c-520ae253.1238-1-64736c10.cust.bredbandsbolaget.se:/home/pappa/bug13520
sql/sql_partition.cc:
Auto merged
mysql-test/r/partition.result:
SCCS merged
mysql-test/t/partition.test:
SCCS merged
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 # |