Debian Codegraph @

mysql-test/suite/parts/t/longname.test

raw
1 source include/have_innodb.inc;
2 source include/have_partition.inc;
3 # The absolute path names in the embedded server hit the limit earlier.
4 source include/not_embedded.inc;
5 set names utf8;
6
7 create database mysqltest1;
8 select database_name, table_name, length(table_name) from mysql.innodb_table_stats where database_name = 'mysqltest1';
9 CREATE TABLE mysqltest1.test_jfg_table_name_with_64_chars_123456789012345678901234567890 (
10 id int(10) unsigned NOT NULL,
11 id2 int(10) unsigned NOT NULL,
12 PRIMARY KEY ( id, id2 )
13 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC
14 PARTITION BY RANGE ( id )
15 SUBPARTITION BY HASH ( id2 )
16 SUBPARTITIONS 2 (
17 PARTITION test_jfg_partition_name_with_60_chars_1234567890123456789012 VALUES LESS THAN (1000) ENGINE = InnoDB,
18 PARTITION pmax VALUES LESS THAN MAXVALUE ENGINE = InnoDB);
19
20 select database_name, table_name, length(table_name) from mysql.innodb_table_stats where database_name = 'mysqltest1';
21
22 --error ER_PATH_LENGTH
23 CREATE TABLE mysqltest1.éééééééééééééééééééééééééééééééééééééééééééééééééééééééééééééééé (
24 id int(10) unsigned NOT NULL,
25 id2 int(10) unsigned NOT NULL,
26 PRIMARY KEY ( id, id2 )
27 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC
28 PARTITION BY RANGE ( id )
29 SUBPARTITION BY HASH ( id2 )
30 SUBPARTITIONS 2 (
31 PARTITION çççççççççççççççççççççççççççççççççççççççççççççççççççççççççççç VALUES LESS THAN (1000) ENGINE = InnoDB,
32 PARTITION pmax VALUES LESS THAN MAXVALUE ENGINE = InnoDB);
33
34 SET @file_per_table=@@GLOBAL.innodb_file_per_table;
35 SET GLOBAL innodb_file_per_table=0;
36
37 CREATE TABLE mysqltest1.t1 (a INT) ENGINE=INNODB
38 PARTITION BY RANGE (a) SUBPARTITION BY HASH(a)
39 (PARTITION `$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$`
40 VALUES LESS THAN (10)
41 (SUBPARTITION
42 `--------------------------abcdef0123456789abcdef0123456789abcdef`,
43 SUBPARTITION
44 `0123456789abcdef0123456789abcdef0123456789abcdef0123456789abcdef`)
45 );
46
47 SET GLOBAL innodb_file_per_table=@file_per_table;
48
49 SHOW CREATE TABLE mysqltest1.t1;
50 INSERT INTO mysqltest1.t1 VALUES(1);
51
52 --error ER_WRONG_TABLE_NAME
53 DROP TABLE mysqltest1.`#mysql50#t1#P#@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024#SP#0123456789abcdef0123456789abcdef0123456789abcdef0123456789abcdef`;
54
55 --error ER_FEATURE_NOT_SUPPORTED_WITH_PARTITIONING
56 ALTER TABLE mysqltest1.t1 ADD FOREIGN KEY (a) REFERENCES
57 mysqltest1.test_jfg_table_name_with_64_chars_123456789012345678901234567890;
58 --error ER_FEATURE_NOT_SUPPORTED_WITH_PARTITIONING
59 ALTER TABLE
60 mysqltest1.test_jfg_table_name_with_64_chars_123456789012345678901234567890
61 ADD FOREIGN KEY (a) REFERENCES mysqltest1.t1;
62
63 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES
64 WHERE NAME LIKE 'mysqltest1%';
65
66 drop database mysqltest1;