diff options
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb_parts/r/partition_exchange_tokudb.result')
| -rw-r--r-- | storage/tokudb/mysql-test/tokudb_parts/r/partition_exchange_tokudb.result | 28 |
1 files changed, 14 insertions, 14 deletions
diff --git a/storage/tokudb/mysql-test/tokudb_parts/r/partition_exchange_tokudb.result b/storage/tokudb/mysql-test/tokudb_parts/r/partition_exchange_tokudb.result index 11c75321b4b..b3cc206e854 100644 --- a/storage/tokudb/mysql-test/tokudb_parts/r/partition_exchange_tokudb.result +++ b/storage/tokudb/mysql-test/tokudb_parts/r/partition_exchange_tokudb.result @@ -13,7 +13,7 @@ tp CREATE TABLE `tp` ( `b` varchar(24) DEFAULT NULL, PRIMARY KEY (`a`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - PARTITION BY HASH (a) + PARTITION BY HASH (`a`) PARTITIONS 4 SHOW CREATE TABLE t; Table Create Table @@ -86,7 +86,7 @@ tp CREATE TABLE `tp` ( `b` varchar(24) DEFAULT NULL, PRIMARY KEY (`a`) ) ENGINE=TokuDB AUTO_INCREMENT=112 DEFAULT CHARSET=latin1 - PARTITION BY HASH (a) + PARTITION BY HASH (`a`) PARTITIONS 4 SHOW CREATE TABLE t; Table Create Table @@ -194,9 +194,9 @@ tp CREATE TABLE `tp` ( `b` varchar(55) DEFAULT NULL, PRIMARY KEY (`a`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - PARTITION BY RANGE (a) -(PARTITION p0 VALUES LESS THAN (100) ENGINE = TokuDB, - PARTITION p1 VALUES LESS THAN MAXVALUE ENGINE = TokuDB) + PARTITION BY RANGE (`a`) +(PARTITION `p0` VALUES LESS THAN (100) ENGINE = TokuDB, + PARTITION `p1` VALUES LESS THAN MAXVALUE ENGINE = TokuDB) SET DEBUG_SYNC= 'now SIGNAL goto_verification'; SET DEBUG_SYNC= 'now WAIT_FOR swap_in_progress'; # select from t and select/update/delete/insert from tp should work @@ -237,9 +237,9 @@ tp CREATE TABLE `tp` ( `b` varchar(55) DEFAULT NULL, PRIMARY KEY (`a`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - PARTITION BY RANGE (a) -(PARTITION p0 VALUES LESS THAN (100) ENGINE = TokuDB, - PARTITION p1 VALUES LESS THAN MAXVALUE ENGINE = TokuDB) + PARTITION BY RANGE (`a`) +(PARTITION `p0` VALUES LESS THAN (100) ENGINE = TokuDB, + PARTITION `p1` VALUES LESS THAN MAXVALUE ENGINE = TokuDB) SET DEBUG_SYNC= 'now SIGNAL goto_wait'; SET DEBUG_SYNC= 'now WAIT_FOR swap_in_progress'; # Both tables should now be under exclusive lock, even SHOW should fail @@ -312,9 +312,9 @@ tp CREATE TABLE `tp` ( `b` varchar(55) DEFAULT NULL, PRIMARY KEY (`a`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - PARTITION BY RANGE (a) -(PARTITION p0 VALUES LESS THAN (100) ENGINE = TokuDB, - PARTITION p1 VALUES LESS THAN MAXVALUE ENGINE = TokuDB) + PARTITION BY RANGE (`a`) +(PARTITION `p0` VALUES LESS THAN (100) ENGINE = TokuDB, + PARTITION `p1` VALUES LESS THAN MAXVALUE ENGINE = TokuDB) SELECT * FROM tp WHERE a = 99; a b 99 End of values @@ -346,9 +346,9 @@ tp CREATE TABLE `tp` ( `b` varchar(55) DEFAULT NULL, PRIMARY KEY (`a`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - PARTITION BY RANGE (a) -(PARTITION p0 VALUES LESS THAN (100) ENGINE = TokuDB, - PARTITION p1 VALUES LESS THAN MAXVALUE ENGINE = TokuDB) + PARTITION BY RANGE (`a`) +(PARTITION `p0` VALUES LESS THAN (100) ENGINE = TokuDB, + PARTITION `p1` VALUES LESS THAN MAXVALUE ENGINE = TokuDB) SELECT * FROM t; a b 10 Ten |