source include/have_innodb.inc;
source include/have_partition.inc;
set names utf8;

create database mysqltest1;
select database_name, table_name, length(table_name) from mysql.innodb_table_stats where database_name = 'mysqltest1';
CREATE TABLE mysqltest1.test_jfg_table_name_with_64_chars_123456789012345678901234567890 (
  id int(10) unsigned NOT NULL,
  id2 int(10) unsigned NOT NULL,
  PRIMARY KEY ( id, id2 )
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC
PARTITION BY RANGE ( id )
  SUBPARTITION BY HASH ( id2 )
  SUBPARTITIONS 2 (
  PARTITION test_jfg_partition_name_with_60_chars_1234567890123456789012 VALUES LESS THAN (1000) ENGINE = InnoDB,
  PARTITION pmax VALUES LESS THAN MAXVALUE ENGINE = InnoDB);

select database_name, table_name, length(table_name) from mysql.innodb_table_stats where database_name = 'mysqltest1';

--error ER_PATH_LENGTH
CREATE TABLE mysqltest1.éééééééééééééééééééééééééééééééééééééééééééééééééééééééééééééééé (
  id int(10) unsigned NOT NULL,
  id2 int(10) unsigned NOT NULL,
  PRIMARY KEY ( id, id2 )
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC
PARTITION BY RANGE ( id )
  SUBPARTITION BY HASH ( id2 )
  SUBPARTITIONS 2 (
  PARTITION çççççççççççççççççççççççççççççççççççççççççççççççççççççççççççç VALUES LESS THAN (1000) ENGINE = InnoDB,
  PARTITION pmax VALUES LESS THAN MAXVALUE ENGINE = InnoDB);

drop database mysqltest1;