summaryrefslogtreecommitdiff
path: root/mysql-test/r/partition.result
diff options
context:
space:
mode:
authorunknown <ramil/ram@mysql.com/ramil.myoffice.izhnet.ru>2007-11-27 12:28:08 +0400
committerunknown <ramil/ram@mysql.com/ramil.myoffice.izhnet.ru>2007-11-27 12:28:08 +0400
commit42853d172c45dc50eaea6b9a4563e96e5515f5bf (patch)
tree81e036c62c47b77fa8a1c3aa1bff57b3ca13c60e /mysql-test/r/partition.result
parent7eb5a83de6af972fa296606c0b5bf5b1f55c5030 (diff)
downloadmariadb-git-42853d172c45dc50eaea6b9a4563e96e5515f5bf.tar.gz
after-merge fix:
- archive test/result adjusted. - OPTIMIZE/ANALYZE PARTITION EXTENDED test case added. mysql-test/r/archive.result: after-merge fix: - archive test/result adjusted. mysql-test/r/partition.result: after-merge fix: - test case added. mysql-test/t/archive.test: after-merge fix: - archive test/result adjusted. mysql-test/t/partition.test: after-merge fix: - test case added.
Diffstat (limited to 'mysql-test/r/partition.result')
-rw-r--r--mysql-test/r/partition.result10
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/r/partition.result b/mysql-test/r/partition.result
index 2b8c79b4563..7c25e948d6c 100644
--- a/mysql-test/r/partition.result
+++ b/mysql-test/r/partition.result
@@ -1297,4 +1297,14 @@ create table t1
partition by key(s1) partitions 3;
insert into t1 values (null,null);
drop table t1;
+CREATE TABLE t1(a int)
+PARTITION BY RANGE (a) (
+PARTITION p1 VALUES LESS THAN (10),
+PARTITION p2 VALUES LESS THAN (20)
+);
+ALTER TABLE t1 OPTIMIZE PARTITION p1 EXTENDED;
+ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'EXTENDED' at line 1
+ALTER TABLE t1 ANALYZE PARTITION p1 EXTENDED;
+ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'EXTENDED' at line 1
+DROP TABLE t1;
End of 5.1 tests