diff options
| author | unknown <aelkin@mysql.com> | 2006-04-01 20:11:22 +0300 |
|---|---|---|
| committer | unknown <aelkin@mysql.com> | 2006-04-01 20:11:22 +0300 |
| commit | 4e8577550c3ee4f0a650e1928ceeb5421c9a8896 (patch) | |
| tree | 694c54599da255f70261a8c63abebf8f41ac0847 /mysql-test | |
| parent | 583ff30bcb650fa2df38ae9599756cf15d658a52 (diff) | |
| parent | a11399c9209f46a9083091c64cd3a90cf29bfc0c (diff) | |
| download | mariadb-git-4e8577550c3ee4f0a650e1928ceeb5421c9a8896.tar.gz | |
Merge aelkin@bk-internal.mysql.com:/home/bk/mysql-5.1-new
into mysql.com:/usr_rh9/home/elkin.rh9/MySQL/BARE/mysql-5.1-new
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 # |