diff options
| author | Alexey Botchkov <holyfoot@mysql.com> | 2010-10-15 20:13:35 +0500 |
|---|---|---|
| committer | Alexey Botchkov <holyfoot@mysql.com> | 2010-10-15 20:13:35 +0500 |
| commit | 8760cec601f6925d6141c6474fbed87c85c693f7 (patch) | |
| tree | a1092d19baf131d3a71bb50f527840460e51f93b /mysql-test/r/partition_innodb.result | |
| parent | 2234783085de0865192c5a30af89cb20643c6322 (diff) | |
| parent | 6d14cae604d064ec5cd8141bfd05408cc41bf134 (diff) | |
| download | mariadb-git-8760cec601f6925d6141c6474fbed87c85c693f7.tar.gz | |
merging.
Diffstat (limited to 'mysql-test/r/partition_innodb.result')
| -rw-r--r-- | mysql-test/r/partition_innodb.result | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/r/partition_innodb.result b/mysql-test/r/partition_innodb.result index af4a03bb0ea..5fcb0e796b1 100644 --- a/mysql-test/r/partition_innodb.result +++ b/mysql-test/r/partition_innodb.result @@ -413,3 +413,9 @@ a b 3 2003-03-03 COMMIT; DROP TABLE t1; +CREATE TABLE t1 (i1 int NOT NULL primary key, f1 int) ENGINE = InnoDB +PARTITION BY HASH(i1) PARTITIONS 2; +INSERT INTO t1 VALUES (1,1), (2,2); +SELECT * FROM t1 WHERE i1 = ( SELECT i1 FROM t1 WHERE f1=0 LIMIT 1 ); +i1 f1 +DROP TABLE t1; |