diff options
Diffstat (limited to 'storage/myisammrg/mysql-test/storage_engine/parts/check_table.rdiff')
| -rw-r--r-- | storage/myisammrg/mysql-test/storage_engine/parts/check_table.rdiff | 172 |
1 files changed, 172 insertions, 0 deletions
diff --git a/storage/myisammrg/mysql-test/storage_engine/parts/check_table.rdiff b/storage/myisammrg/mysql-test/storage_engine/parts/check_table.rdiff new file mode 100644 index 00000000000..3f3db85a23e --- /dev/null +++ b/storage/myisammrg/mysql-test/storage_engine/parts/check_table.rdiff @@ -0,0 +1,172 @@ +3,36c3,12 +< INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b'),(3,'c'),(2,'d'),(4,'e'),(100,'f'),(101,'g'); +< CREATE TABLE t2 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS> PARTITION BY RANGE(a) ( +< PARTITION p0 VALUES LESS THAN (100), +< PARTITION p1 VALUES LESS THAN MAXVALUE +< ); +< INSERT INTO t2 (a,b) SELECT a, b FROM t1; +< ALTER TABLE t1 CHECK PARTITION p0; +< Table Op Msg_type Msg_text +< test.t1 check status OK +< INSERT INTO t1 (a,b) VALUES (3,'c'); +< ALTER TABLE t1 CHECK PARTITION p0, p1 FOR UPGRADE; +< Table Op Msg_type Msg_text +< test.t1 check status OK +< INSERT INTO t2 (a,b) VALUES (10000,'e'); +< ALTER TABLE t2 CHECK PARTITION p0 QUICK; +< Table Op Msg_type Msg_text +< test.t2 check status OK +< INSERT INTO t1 (a,b) VALUES (6,'f'); +< ALTER TABLE t1 CHECK PARTITION p1 FAST; +< Table Op Msg_type Msg_text +< test.t1 check status OK +< INSERT INTO t2 (a,b) VALUES (8,'h'); +< ALTER TABLE t2 CHECK PARTITION p1 MEDIUM; +< Table Op Msg_type Msg_text +< test.t2 check status OK +< INSERT INTO t1 (a,b) VALUES (9,'i'); +< ALTER TABLE t1 CHECK PARTITION ALL EXTENDED; +< Table Op Msg_type Msg_text +< test.t1 check status OK +< INSERT INTO t1 (a,b) VALUES (11,'k'); +< ALTER TABLE t1 CHECK PARTITION p0 CHANGED; +< Table Op Msg_type Msg_text +< test.t1 check status OK +< DROP TABLE t1, t2; +--- +> ERROR HY000: Engine cannot be used in partitioned tables +> # ERROR: Statement ended with errno 1572, errname ER_PARTITION_MERGE_ERROR (expected to succeed) +> # ------------ UNEXPECTED RESULT ------------ +> # [ CREATE TABLE t1 (a INT(11) /*!*/ /*Custom column options*/, b CHAR(8) /*!*/ /*Custom column options*/) ENGINE=MRG_MYISAM /*!*/ /*Custom table options*/ UNION(mrg.t1) INSERT_METHOD=LAST PARTITION BY HASH(a) PARTITIONS 2 ] +> # The statement|command finished with ER_PARTITION_MERGE_ERROR. +> # Partitions or the mix could be unsupported|malfunctioning, or the problem was caused by previous errors. +> # You can change the engine code, or create an rdiff, or disable the test by adding it to disabled.def. +> # Further in this test, the message might sometimes be suppressed; a part of the test might be skipped. +> # Also, this problem may cause a chain effect (more errors of different kinds in the test). +> # ------------------------------------------- +38a15,16 +> ERROR HY000: Engine cannot be used in partitioned tables +> # ERROR: Statement ended with errno 1572, errname ER_PARTITION_MERGE_ERROR (expected to succeed) +39a18 +> ERROR 42S02: Table 'test.t1' doesn't exist +40a20,21 +> ERROR HY000: Engine cannot be used in partitioned tables +> # ERROR: Statement ended with errno 1572, errname ER_PARTITION_MERGE_ERROR (expected to succeed) +43c24,25 +< test.t1 check status OK +--- +> test.t1 check Error Table 'test.t1' doesn't exist +> test.t1 check status Operation failed +44a27 +> ERROR 42S02: Table 'test.t1' doesn't exist +45a29 +> ERROR 42S02: Table 'test.t2' doesn't exist +48,49c32,35 +< test.t1 check status OK +< test.t2 check status OK +--- +> test.t1 check Error Table 'test.t1' doesn't exist +> test.t1 check status Operation failed +> test.t2 check Error Table 'test.t2' doesn't exist +> test.t2 check status Operation failed +50a37 +> ERROR 42S02: Table 'test.t2' doesn't exist +53c40,41 +< test.t2 check status OK +--- +> test.t2 check Error Table 'test.t2' doesn't exist +> test.t2 check status Operation failed +54a43 +> ERROR 42S02: Table 'test.t1' doesn't exist +57c46,47 +< test.t1 check status OK +--- +> test.t1 check Error Table 'test.t1' doesn't exist +> test.t1 check status Operation failed +58a49 +> ERROR 42S02: Table 'test.t1' doesn't exist +59a51 +> ERROR 42S02: Table 'test.t2' doesn't exist +62,63c54,57 +< test.t2 check status OK +< test.t1 check status OK +--- +> test.t2 check Error Table 'test.t2' doesn't exist +> test.t2 check status Operation failed +> test.t1 check Error Table 'test.t1' doesn't exist +> test.t1 check status Operation failed +64a59 +> ERROR 42S02: Table 'test.t1' doesn't exist +65a61 +> ERROR 42S02: Table 'test.t2' doesn't exist +68,69c64,67 +< test.t1 check status OK +< test.t2 check status OK +--- +> test.t1 check Error Table 'test.t1' doesn't exist +> test.t1 check status Operation failed +> test.t2 check Error Table 'test.t2' doesn't exist +> test.t2 check status Operation failed +70a69 +> ERROR 42S02: Table 'test.t1' doesn't exist +73c72,73 +< test.t1 check status OK +--- +> test.t1 check Error Table 'test.t1' doesn't exist +> test.t1 check status Operation failed +74a75 +> ERROR 42S02: Unknown table 't1,t2' +75a77,78 +> ERROR HY000: Engine cannot be used in partitioned tables +> # ERROR: Statement ended with errno 1572, errname ER_PARTITION_MERGE_ERROR (expected to succeed) +76a80 +> ERROR 42S02: Table 'test.t1' doesn't exist +79c83,84 +< test.t1 check status OK +--- +> test.t1 check Error Table 'test.t1' doesn't exist +> test.t1 check status Operation failed +80a86 +> ERROR 42S02: Table 'test.t1' doesn't exist +83c89,90 +< test.t1 check status OK +--- +> test.t1 check Error Table 'test.t1' doesn't exist +> test.t1 check status Operation failed +84a92 +> ERROR 42S02: Table 'test.t1' doesn't exist +87c95,96 +< test.t1 check status OK +--- +> test.t1 check Error Table 'test.t1' doesn't exist +> test.t1 check status Operation failed +88a98 +> ERROR 42S02: Table 'test.t1' doesn't exist +91c101,102 +< test.t1 check status OK +--- +> test.t1 check Error Table 'test.t1' doesn't exist +> test.t1 check status Operation failed +92a104 +> ERROR 42S02: Table 'test.t1' doesn't exist +95c107,108 +< test.t1 check status OK +--- +> test.t1 check Error Table 'test.t1' doesn't exist +> test.t1 check status Operation failed +96a110 +> ERROR 42S02: Table 'test.t1' doesn't exist +99c113,114 +< test.t1 check status OK +--- +> test.t1 check Error Table 'test.t1' doesn't exist +> test.t1 check status Operation failed +100a116 +> ERROR 42S02: Table 'test.t1' doesn't exist +103c119,120 +< test.t1 check status OK +--- +> test.t1 check Error Table 'test.t1' doesn't exist +> test.t1 check status Operation failed +104a122 +> ERROR 42S02: Unknown table 't1' |