Debian Codegraph @

mysql-test/suite/parts/r/longname.result

raw
1 set names utf8;
2 create database mysqltest1;
3 select database_name, table_name, length(table_name) from mysql.innodb_table_stats where database_name = 'mysqltest1';
4 database_name table_name length(table_name)
5 CREATE TABLE mysqltest1.test_jfg_table_name_with_64_chars_123456789012345678901234567890 (
6 id int(10) unsigned NOT NULL,
7 id2 int(10) unsigned NOT NULL,
8 PRIMARY KEY ( id, id2 )
9 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC
10 PARTITION BY RANGE ( id )
11 SUBPARTITION BY HASH ( id2 )
12 SUBPARTITIONS 2 (
13 PARTITION test_jfg_partition_name_with_60_chars_1234567890123456789012 VALUES LESS THAN (1000) ENGINE = InnoDB,
14 PARTITION pmax VALUES LESS THAN MAXVALUE ENGINE = InnoDB);
15 select database_name, table_name, length(table_name) from mysql.innodb_table_stats where database_name = 'mysqltest1';
16 database_name table_name length(table_name)
17 mysqltest1 test_jfg_table_name_with_64_chars_123456789012345678901234567890#P#pmax#SP#pmaxsp0 82
18 mysqltest1 test_jfg_table_name_with_64_chars_123456789012345678901234567890#P#pmax#SP#pmaxsp1 82
19 mysqltest1 test_jfg_table_name_with_64_chars_123456789012345678901234567890#P#test_jfg_partition_name_with_60_chars_1234567890123456789012#SP#test_jfg_partition_name_with_60_chars_1234567890123456789012sp0 194
20 mysqltest1 test_jfg_table_name_with_64_chars_123456789012345678901234567890#P#test_jfg_partition_name_with_60_chars_1234567890123456789012#SP#test_jfg_partition_name_with_60_chars_1234567890123456789012sp1 194
21 CREATE TABLE mysqltest1.éééééééééééééééééééééééééééééééééééééééééééééééééééééééééééééééé (
22 id int(10) unsigned NOT NULL,
23 id2 int(10) unsigned NOT NULL,
24 PRIMARY KEY ( id, id2 )
25 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC
26 PARTITION BY RANGE ( id )
27 SUBPARTITION BY HASH ( id2 )
28 SUBPARTITIONS 2 (
29 PARTITION çççççççççççççççççççççççççççççççççççççççççççççççççççççççççççç VALUES LESS THAN (1000) ENGINE = InnoDB,
30 PARTITION pmax VALUES LESS THAN MAXVALUE ENGINE = InnoDB);
31 ERROR HY000: The path specified for @0n@0n@0n@0n@0n@0n@0n@0n@0n@0n@0n@0n@0n@0n@0n@0n@0n@0n@0n@0n@... is too long
32 SET @file_per_table=@@GLOBAL.innodb_file_per_table;
33 SET GLOBAL innodb_file_per_table=0;
34 Warnings:
35 Warning 1287 '@@innodb_file_per_table' is deprecated and will be removed in a future release
36 CREATE TABLE mysqltest1.t1 (a INT) ENGINE=INNODB
37 PARTITION BY RANGE (a) SUBPARTITION BY HASH(a)
38 (PARTITION `$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$`
39 VALUES LESS THAN (10)
40 (SUBPARTITION
41 `--------------------------abcdef0123456789abcdef0123456789abcdef`,
42 SUBPARTITION
43 `0123456789abcdef0123456789abcdef0123456789abcdef0123456789abcdef`)
44 );
45 SET GLOBAL innodb_file_per_table=@file_per_table;
46 Warnings:
47 Warning 1287 '@@innodb_file_per_table' is deprecated and will be removed in a future release
48 SHOW CREATE TABLE mysqltest1.t1;
49 Table Create Table
50 t1 CREATE TABLE `t1` (
51 `a` int(11) DEFAULT NULL
52 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
53 PARTITION BY RANGE (`a`)
54 SUBPARTITION BY HASH (`a`)
55 (PARTITION `$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$` VALUES LESS THAN (10)
56 (SUBPARTITION `--------------------------abcdef0123456789abcdef0123456789abcdef` ENGINE = InnoDB,
57 SUBPARTITION `0123456789abcdef0123456789abcdef0123456789abcdef0123456789abcdef` ENGINE = InnoDB))
58 INSERT INTO mysqltest1.t1 VALUES(1);
59 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`;
60 ERROR 42000: Incorrect table name '#mysql50#t1#P#@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@0024@'
61 ALTER TABLE mysqltest1.t1 ADD FOREIGN KEY (a) REFERENCES
62 mysqltest1.test_jfg_table_name_with_64_chars_123456789012345678901234567890;
63 ERROR HY000: Partitioned tables do not support FOREIGN KEY
64 ALTER TABLE
65 mysqltest1.test_jfg_table_name_with_64_chars_123456789012345678901234567890
66 ADD FOREIGN KEY (a) REFERENCES mysqltest1.t1;
67 ERROR HY000: Partitioned tables do not support FOREIGN KEY
68 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES
69 WHERE NAME LIKE 'mysqltest1%';
70 NAME
71 mysqltest1/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
72 mysqltest1/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#@002d@002d@002d@002d@002d@002d@002d@002d@002d@002d@002d@002d@002d@002d@002d@002d@002d@002d@002d@002d@002d@002d@002d@002d@002d@002dabcdef0123456789abcdef0123456789abcdef
73 mysqltest1/test_jfg_table_name_with_64_chars_123456789012345678901234567890#P#pmax#SP#pmaxsp0
74 mysqltest1/test_jfg_table_name_with_64_chars_123456789012345678901234567890#P#pmax#SP#pmaxsp1
75 mysqltest1/test_jfg_table_name_with_64_chars_123456789012345678901234567890#P#test_jfg_partition_name_with_60_chars_1234567890123456789012#SP#test_jfg_partition_name_with_60_chars_1234567890123456789012sp0
76 mysqltest1/test_jfg_table_name_with_64_chars_123456789012345678901234567890#P#test_jfg_partition_name_with_60_chars_1234567890123456789012#SP#test_jfg_partition_name_with_60_chars_1234567890123456789012sp1
77 drop database mysqltest1;