EVOLUTION-MANAGER

Edit File: create_table.rdiff

--- /data/src/bb-10.2-mdev12528/mysql-test/suite/storage_engine/parts/create_table.result 2017-06-22 00:33:46.419995639 +0300 +++ /data/src/bb-10.2-mdev12528/mysql-test/suite/storage_engine/parts/create_table.reject 2017-06-22 19:25:05.335568983 +0300 @@ -65,7 +65,7 @@ 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 # # # # # # # +1 SIMPLE t1 def # # # # # # # INSERT INTO t1 (a) VALUES (50); ERROR HY000: Table has no partition for value 50 DROP TABLE t1; @@ -81,7 +81,7 @@ 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 # # # # # # # +1 SIMPLE t1 def_defsp0 # # # # # # # 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