diff options
| author | unknown <mattiasj@mattiasj-laptop.(none)> | 2007-10-23 22:07:45 +0200 |
|---|---|---|
| committer | unknown <mattiasj@mattiasj-laptop.(none)> | 2007-10-23 22:07:45 +0200 |
| commit | 2b5bcaabeeab4aff80b51b5ee6a65c7494ac3c6e (patch) | |
| tree | bf430a8dd4ebeba5d7604f180ab467b084dc8246 /mysql-test/r/partition.result | |
| parent | bfc41161b49dec93a1f59e15d5147b3f18fc3578 (diff) | |
| parent | fe784fac00494c1d48f0c245d0d4c23bfb717680 (diff) | |
| download | mariadb-git-2b5bcaabeeab4aff80b51b5ee6a65c7494ac3c6e.tar.gz | |
Merge mattiasj-laptop.(none):/home/mattiasj/clones/mysql-5.1-bug30695
into mattiasj-laptop.(none):/home/mattiasj/clones/mysql-5.1-bug30878
mysql-test/r/partition.result:
SCCS merged
mysql-test/t/partition.test:
SCCS merged
Diffstat (limited to 'mysql-test/r/partition.result')
| -rw-r--r-- | mysql-test/r/partition.result | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/r/partition.result b/mysql-test/r/partition.result index 753a2e31632..15335a59421 100644 --- a/mysql-test/r/partition.result +++ b/mysql-test/r/partition.result @@ -1,4 +1,20 @@ drop table if exists t1; +CREATE TABLE t1 ( +d DATE NOT NULL +) +PARTITION BY RANGE( YEAR(d) ) ( +PARTITION p0 VALUES LESS THAN (1960), +PARTITION p1 VALUES LESS THAN (1970), +PARTITION p2 VALUES LESS THAN (1980), +PARTITION p3 VALUES LESS THAN (1990) +); +ALTER TABLE t1 ADD PARTITION ( +PARTITION `p5` VALUES LESS THAN (2010) +COMMENT 'APSTART \' APEND' +); +SELECT * FROM t1 LIMIT 1; +d +DROP TABLE t1; create table t1 (id int auto_increment, s1 int, primary key (id)); insert into t1 values (null,1); insert into t1 values (null,6); |