Debian Codegraph @

mysql-test/suite/innodb/t/foreign_key_not_windows.test

raw
1 --source include/have_innodb.inc
2 # On Microsoft Windows, there is an additional limit of MAX_PATH
3 --source include/not_windows.inc
4 # The embedded server prepends --datadir or --innodb-data-home-dir
5 # to the path names, which reduces the maximum length of names further.
6 --source include/not_embedded.inc
7
8 --echo #
9 --echo # MDEV-28980 InnoDB: Failing assertion: len <= MAX_TABLE_NAME_LEN
10 --echo #
11
12 # The main test is innodb.foreign_key. This is an additional test that
13 # the maximum length cannot be exceeded for implicitly created
14 # constraint names. On Microsoft Windows, MAX_PATH is a much stricter
15 # limit than the 255-byte maximum path component length on many other systems,
16 # including Linux and IBM AIX.
17
18 CREATE TABLE t (a INT PRIMARY KEY) ENGINE=InnoDB;
19
20 # The maximum identifier length is 64 characters.
21 # my_charset_filename will expand some characters to 5 characters,
22 # e.g., # to @0023.
23 # Many operating systems (such as Linux) or file systems
24 # limit the path component length to 255 bytes,
25 # corresponding to the 51 characters below: 5*51=255.
26 let $d255=###################################################;
27 let $d250=##################################################;
28 --replace_result $d255 d255
29 eval CREATE DATABASE `$d255`;
30 --replace_result $d255 d255
31 --error ER_IDENT_CAUSES_TOO_LONG_PATH
32 eval CREATE TABLE `$d255`.`$d255`
33 (a INT PRIMARY KEY, FOREIGN KEY(a) REFERENCES test.t(a)) ENGINE=InnoDB;
34 --replace_result $d255 d255
35 --error ER_IDENT_CAUSES_TOO_LONG_PATH
36 eval CREATE TABLE `$d255`.`_$d250`
37 (a INT PRIMARY KEY, FOREIGN KEY(a) REFERENCES test.t(a)) ENGINE=InnoDB;
38 --replace_result $d255 d255
39 eval CREATE TABLE `$d255`.`$d250`
40 (a INT PRIMARY KEY, FOREIGN KEY(a) REFERENCES test.t(a)) ENGINE=InnoDB;
41
42 --echo #
43 --echo # MDEV-29258 Failing assertion for name length on RENAME TABLE
44 --echo #
45
46 let $d245=-------------------------------------------------;
47 --replace_result $d245 d245 $d255 d255
48 eval CREATE TABLE `$d255`.`$d245` (x INT) ENGINE=InnoDB;
49 --replace_result $d250 d250 $d255 d255
50 eval DROP TABLE `$d255`.`$d250`;
51
52 --replace_result $d245 d245 $d250 d250 d255 d255
53 eval RENAME TABLE `$d255`.`$d245` TO `$d255`.`$d250`;
54 --replace_result $d250 d250 $d255 d255
55 eval RENAME TABLE `$d255`.`$d250` TO a;
56 --replace_result $d255 d255
57 DROP TABLE a,t;
58
59 --echo #
60 --echo # MDEV-29409 Buffer overflow in my_wc_mb_filename() on RENAME TABLE
61 --echo #
62
63 let $d225=#############################################;
64 let $d320=################################################################;
65
66 --replace_result $d255 d255
67 eval CREATE TABLE `$d255`.t(a INT PRIMARY KEY)ENGINE=InnoDB;
68 --replace_result $d255 d255 $d320 d320
69 eval CREATE TABLE `$d255`.u(a INT PRIMARY KEY,
70 CONSTRAINT `$d320` FOREIGN KEY (a) REFERENCES `$d255`.t (a)) ENGINE=InnoDB;
71 --replace_result $d255 d255
72 eval RENAME TABLE `$d255`.u TO u;
73 DROP TABLE u;
74 --replace_result $d255 d255
75 eval DROP DATABASE `$d255`;
76
77 --echo # End of 10.3 tests
78
79 --echo #
80 --echo # MDEV-24356 InnoDB: Failing assertion: len < sizeof(tmp_buff)
81 --echo # in get_foreign_key_info
82 --echo #
83 CREATE DATABASE `db_new..............................................end`;
84 USE `db_new..............................................end`;
85 SET STATEMENT foreign_key_checks=0 for
86 CREATE TABLE t1(f1 INT UNSIGNED,f2 INT UNSIGNED,
87 FOREIGN KEY (f2)REFERENCES t2 (f1))ENGINE=InnoDB;
88 ALTER TABLE t1 FORCE;
89 DROP DATABASE `db_new..............................................end`;