diff options
| author | Nirbhay Choubey <nirbhay@mariadb.com> | 2016-09-06 10:36:10 -0400 |
|---|---|---|
| committer | Nirbhay Choubey <nirbhay@mariadb.com> | 2016-09-06 10:36:10 -0400 |
| commit | 780c40ef0e1d200fd6874a9e8e65705e685d76c0 (patch) | |
| tree | 0a29ad51f0192f865d79de65b566da61add4b536 /mysql-test/t/partition_innodb.test | |
| parent | d8ad96eac0df9241ba200634717227a7153086e1 (diff) | |
| download | mariadb-git-10.2-mdev7635.tar.gz | |
MDEV-7635: Part 110.2-mdev7635
innodb_buffer_pool_dump_at_shutdown = ON
innodb_buffer_pool_dump_pct = 25
innodb_buffer_pool_load_at_startup = ON
innodb_checksum_algorithm = CRC32
innodb_file_format = Barracuda
innodb_file_format_max = Barracuda
innodb_large_prefix = ON
innodb_log_compressed_pages = ON
innodb_log_file_size = 128M
innodb_purge_threads = 4
innodb_stats_traditional = OFF
innodb_strict_mode = ON
binlog_annotate_row_events = ON
binlog_format = MIXED
group_concat_max_len = 1M
histogram_size = 255
long-query-time = 2
lower_case_table_names = 2
max_allowed_packet = 16M
replicate_annotate_row_events = ON
slave_net_timeout = 60
sync_binlog = 1
use_stat_tables = complementary
aria_recover = FORCE,BACKUP
myisam_recover_options = FORCE,BACKUP
Diffstat (limited to 'mysql-test/t/partition_innodb.test')
| -rw-r--r-- | mysql-test/t/partition_innodb.test | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/t/partition_innodb.test b/mysql-test/t/partition_innodb.test index 62a9173b526..97130eb1a84 100644 --- a/mysql-test/t/partition_innodb.test +++ b/mysql-test/t/partition_innodb.test @@ -825,6 +825,7 @@ DROP TABLE t1; CREATE TABLE t1 (f1 VARCHAR(512) CHARACTER SET utf8) ENGINE=InnoDB; INSERT INTO t1 VALUES ('j'); +--error ER_INDEX_COLUMN_TOO_LONG CREATE TABLE t2 ( f2 VARCHAR(5) CHARACTER SET latin1, f3 VARCHAR(5) CHARACTER SET utf8, @@ -840,6 +841,22 @@ CREATE TABLE t2 ( PARTITION p1 VALUES IN (2,4,0) ); +CREATE TABLE t2 ( + f2 VARCHAR(5) CHARACTER SET latin1, + f3 VARCHAR(5) CHARACTER SET utf8, + f4 INT, + f5 VARCHAR(512) CHARACTER SET utf8, + f6 VARCHAR(256) CHARACTER SET utf8, + key (f2), + key (f3), + key (f5) +) ENGINE=InnoDB ROW_FORMAT=DYNAMIC + PARTITION BY LIST COLUMNS (f4) + SUBPARTITION BY KEY(f6) SUBPARTITIONS 4 ( + PARTITION p0 VALUES IN (1,3,9,null), + PARTITION p1 VALUES IN (2,4,0) +); + INSERT INTO t2 VALUES ('k','s',3,'b','j'),('a','b',NULL,'v','j'),('c','m',9,'t',NULL), ('b','l',9,'b',NULL),('i','y',3,'o','w'),('c','m',NULL,'a','m'), |