Debian Codegraph @

mysql-test/suite/innodb/r/foreign_key_not_windows.result

raw
1 #
2 # MDEV-28980 InnoDB: Failing assertion: len <= MAX_TABLE_NAME_LEN
3 #
4 CREATE TABLE t (a INT PRIMARY KEY) ENGINE=InnoDB;
5 CREATE DATABASE `d255`;
6 CREATE TABLE `d255`.`d255`
7 (a INT PRIMARY KEY, FOREIGN KEY(a) REFERENCES test.t(a)) ENGINE=InnoDB;
8 ERROR HY000: Long database name and identifier for object resulted in path length exceeding 512 characters. Path: './@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023/@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@
9 CREATE TABLE `d255`.`_##################################################`
10 (a INT PRIMARY KEY, FOREIGN KEY(a) REFERENCES test.t(a)) ENGINE=InnoDB;
11 ERROR HY000: Long database name and identifier for object resulted in path length exceeding 512 characters. Path: './@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023/_@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023@0023
12 CREATE TABLE `d255`.`##################################################`
13 (a INT PRIMARY KEY, FOREIGN KEY(a) REFERENCES test.t(a)) ENGINE=InnoDB;
14 #
15 # MDEV-29258 Failing assertion for name length on RENAME TABLE
16 #
17 CREATE TABLE `d255`.`d245` (x INT) ENGINE=InnoDB;
18 DROP TABLE `d255`.`d250`;
19 RENAME TABLE `d250#`.`d245` TO `d250#`.`d250`;
20 RENAME TABLE `d255`.`d250` TO a;
21 DROP TABLE a,t;
22 #
23 # MDEV-29409 Buffer overflow in my_wc_mb_filename() on RENAME TABLE
24 #
25 CREATE TABLE `d255`.t(a INT PRIMARY KEY)ENGINE=InnoDB;
26 CREATE TABLE `d255`.u(a INT PRIMARY KEY,
27 CONSTRAINT `d320` FOREIGN KEY (a) REFERENCES `d255`.t (a)) ENGINE=InnoDB;
28 RENAME TABLE `d255`.u TO u;
29 DROP TABLE u;
30 DROP DATABASE `d255`;
31 # End of 10.3 tests
32 #
33 # MDEV-24356 InnoDB: Failing assertion: len < sizeof(tmp_buff)
34 # in get_foreign_key_info
35 #
36 CREATE DATABASE `db_new..............................................end`;
37 USE `db_new..............................................end`;
38 SET STATEMENT foreign_key_checks=0 for
39 CREATE TABLE t1(f1 INT UNSIGNED,f2 INT UNSIGNED,
40 FOREIGN KEY (f2)REFERENCES t2 (f1))ENGINE=InnoDB;
41 ALTER TABLE t1 FORCE;
42 DROP DATABASE `db_new..............................................end`;