EVOLUTION-MANAGER

Edit File: create_table.rdiff

--- create_table.result 2013-01-22 22:05:05.246633000 +0400 +++ create_table.reject 2013-01-23 03:16:25.160324290 +0400 @@ -1,91 +1,79 @@ DROP TABLE IF EXISTS t1; CREATE TABLE t1 (a <INT_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS> PARTITION BY HASH(a) PARTITIONS 2; -INSERT INTO t1 (a) VALUES (1),(2),(3),(2); -EXPLAIN PARTITIONS SELECT a FROM t1; -id select_type table partitions type possible_keys key key_len ref rows Extra -1 SIMPLE t1 p0,p1 # # # # # # # -EXPLAIN PARTITIONS SELECT a FROM t1 WHERE a=2; -id select_type table partitions type possible_keys key key_len ref rows Extra -1 SIMPLE t1 p0 # # # # # # # -DROP TABLE t1; +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*/) 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). +# ------------------------------------------- CREATE TABLE t1 (a <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS> PARTITION BY KEY(a) PARTITIONS 2; -INSERT INTO t1 (a) VALUES ('a'),('b'),('c'); -EXPLAIN PARTITIONS SELECT a FROM t1; -id select_type table partitions type possible_keys key key_len ref rows Extra -1 SIMPLE t1 p0,p1 # # # # # # # -EXPLAIN PARTITIONS SELECT a FROM t1 WHERE a = 'b'; -id select_type table partitions type possible_keys key key_len ref rows Extra -1 SIMPLE t1 p1 # # # # # # # -DROP TABLE t1; +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 CHAR(8) /*!*/ /*Custom column options*/) ENGINE=MRG_MYISAM /*!*/ /*Custom table options*/ UNION(mrg.t1) INSERT_METHOD=LAST PARTITION BY KEY(a) PARTITIONS 2 ] +# The statement|command finished with ER_PARTITION_MERGE_ERROR. +# Partitions or CHAR types 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). +# ------------------------------------------- CREATE TABLE t1 (a <INT_COLUMN>, <CUSTOM_INDEX> (a)) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS> PARTITION BY KEY(a) PARTITIONS 2; -SHOW INDEX IN t1; -Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment -t1 1 a 1 a # # NULL NULL # # -INSERT INTO t1 (a) VALUES (1),(2),(3),(5); -EXPLAIN PARTITIONS SELECT a FROM t1; -id select_type table partitions type possible_keys key key_len ref rows Extra -1 SIMPLE t1 p0,p1 # # # # # # # -EXPLAIN PARTITIONS SELECT a FROM t1 WHERE a IN (1,3); -id select_type table partitions type possible_keys key key_len ref rows Extra -1 SIMPLE t1 p0 # # # # # # # -DROP TABLE t1; +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 indexed column options*/, /*!INDEX*/ /*Custom index*/ (a)) ENGINE=MRG_MYISAM /*!*/ /*Custom table options*/ UNION(mrg.t1) INSERT_METHOD=LAST PARTITION BY KEY(a) PARTITIONS 2 ] +# The statement|command finished with ER_PARTITION_MERGE_ERROR. +# Partitions or indexes 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). +# ------------------------------------------- CREATE TABLE t1 (a <INT_COLUMN> PRIMARY KEY) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS> PARTITION BY KEY() PARTITIONS 2; -SHOW INDEX IN t1; -Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment -t1 0 PRIMARY 1 a # # NULL NULL # # -INSERT INTO t1 (a) VALUES (1),(200),(3),(2); -EXPLAIN PARTITIONS SELECT a FROM t1; -id select_type table partitions type possible_keys key key_len ref rows Extra -1 SIMPLE t1 p0,p1 # # # # # # # -EXPLAIN PARTITIONS SELECT a FROM t1 WHERE a=2; -id select_type table partitions type possible_keys key key_len ref rows Extra -1 SIMPLE t1 p1 # # # # # # # -DROP TABLE t1; +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 indexed column options*/ PRIMARY KEY) ENGINE=MRG_MYISAM /*!*/ /*Custom table options*/ UNION(mrg.t1) INSERT_METHOD=LAST PARTITION BY KEY() PARTITIONS 2 ] +# The statement|command finished with ER_PARTITION_MERGE_ERROR. +# PK 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). +# ------------------------------------------- CREATE TABLE t1 (a <INT_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS> PARTITION BY RANGE(a) ( PARTITION p0 VALUES LESS THAN (10), PARTITION p1 VALUES LESS THAN (1000) ); -INSERT INTO t1 (a) VALUES (1),(2),(400); -EXPLAIN PARTITIONS SELECT a FROM t1; -id select_type table partitions type possible_keys key key_len ref rows Extra -1 SIMPLE t1 p0,p1 # # # # # # # -EXPLAIN PARTITIONS SELECT a FROM t1 WHERE a = 2; -id select_type table partitions type possible_keys key key_len ref rows Extra -1 SIMPLE t1 p0 # # # # # # # -INSERT INTO t1 (a) VALUES (10000); -ERROR HY000: Table has no partition for value 10000 -DROP TABLE t1; -CREATE TABLE t1 (a <INT_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS> PARTITION BY LIST(a) ( +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*/) ENGINE=MRG_MYISAM /*!*/ /*Custom table options*/ UNION(mrg.t1) INSERT_METHOD=LAST PARTITION BY RANGE(a) ( +PARTITION p0 VALUES LESS THAN (10), +PARTITION p1 VALUES LESS THAN (1000) +) ] +# 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). +# ------------------------------------------- +CREATE TABLE t1 (a <INT_COLUMN>, b <INT_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS> PARTITION BY LIST(a) SUBPARTITION by HASH(b) ( PARTITION abc VALUES IN (1,2,3), PARTITION def VALUES IN (100,101,102) ); -INSERT INTO t1 (a) VALUES (1),(101),(1); -EXPLAIN PARTITIONS SELECT a FROM t1; -id select_type table partitions type possible_keys key key_len ref rows Extra -1 SIMPLE t1 abc,def # # # # # # # -EXPLAIN PARTITIONS SELECT a FROM t1 WHERE a = 100; -id select_type table partitions type possible_keys key key_len ref rows Extra -1 SIMPLE NULL NULL # # # # # # # -INSERT INTO t1 (a) VALUES (50); -ERROR HY000: Table has no partition for value 50 -DROP TABLE t1; -CREATE TABLE t1 (a <INT_COLUMN>, b <INT_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS> PARTITION BY LIST(a) SUBPARTITION by HASH(b) ( +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 INT(11) /*!*/ /*Custom column options*/) ENGINE=MRG_MYISAM /*!*/ /*Custom table options*/ UNION(mrg.t1) INSERT_METHOD=LAST PARTITION BY LIST(a) SUBPARTITION by HASH(b) ( PARTITION abc VALUES IN (1,2,3), PARTITION def VALUES IN (100,101,102) -); -SHOW INDEX IN t1; -Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment -INSERT INTO t1 (a,b) VALUES (1,1),(101,2),(1,3); -EXPLAIN PARTITIONS SELECT a FROM t1; -id select_type table partitions type possible_keys key key_len ref rows Extra -1 SIMPLE t1 abc_abcsp0,def_defsp0 # # # # # # # -EXPLAIN PARTITIONS SELECT a FROM t1 WHERE a = 100; -id select_type table partitions type possible_keys key key_len ref rows Extra -1 SIMPLE NULL NULL # # # # # # # -SELECT TABLE_SCHEMA, TABLE_NAME, PARTITION_NAME, SUBPARTITION_NAME, PARTITION_METHOD, SUBPARTITION_METHOD -FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_NAME = 't1'; -TABLE_SCHEMA TABLE_NAME PARTITION_NAME SUBPARTITION_NAME PARTITION_METHOD SUBPARTITION_METHOD -test t1 abc abcsp0 LIST HASH -test t1 def defsp0 LIST HASH -SELECT * FROM INFORMATION_SCHEMA.PARTITIONS; -DROP TABLE t1; +) ] +# The statement|command finished with ER_PARTITION_MERGE_ERROR. +# Partitions or subpartitions 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). +# -------------------------------------------