Debian Codegraph @

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

raw
1 --source include/have_innodb.inc
2 --source include/have_partition.inc
3 # Test causes OS error printout
4 --source include/not_windows.inc
5 --source include/default_charset.inc
6
7 --disable_query_log
8 --disable_result_log
9 --disable_warnings
10
11
12 # Ignore OS errors
13 call mtr.add_suppression("InnoDB: File ./test/t1");
14 call mtr.add_suppression("InnoDB: Error number");
15 call mtr.add_suppression("InnoDB: Cannot rename file '.*/test/t1#[Pp]#p1#[Ss][Pp]#p1sp0\\.ibd' to");
16 call mtr.add_suppression("InnoDB: Operating system error number .* in a file operation.");
17
18 # MDEV-7046: MySQL#74480 - Failing assertion: os_file_status(newpath, &exists, &type)
19 # after Operating system error number 36 in a file operation
20
21 USE test;
22 create table t1(f1 INT,f2 INT,f3 CHAR (10),primary key(f1,f2)) partition by range(f1) subpartition by hash(f2) subpartitions 2 (partition p1 values less than (0),partition p2 values less than (2),partition p3 values less than (2147483647));
23 --replace_regex /'.*t2_new.*'/'t2_new'/
24 --error 7
25 RENAME TABLE t1 TO `t2_new..............................................end`;
26 alter table t1 engine=innodb;
27 --replace_regex /'.*t2_new.*'/'t2_new'/
28 --error 1025
29 RENAME TABLE t1 TO `t2_new..............................................end`;
30 --replace_regex /'.*t2_new.*'/'t2_new'/
31 show warnings;
32 drop table t1;
33
34 # Starting with MariaDB 10.6, ensure that DDL recovery will have completed.
35 SET GLOBAL innodb_max_purge_lag_wait=0;
36 drop database test;
37 create database test;
38 use test;
39
40 SET @@session.default_storage_engine=MYISAM;
41 --error 0,1,1103
42 CREATE TABLE t1(id INT,purchased DATE)PARTITION BY RANGE(YEAR(purchased)) SUBPARTITION BY HASH(TO_DAYS(purchased)) SUBPARTITIONS 2 (PARTITION p0 VALUES LESS THAN MAXVALUE (SUBPARTITION sp0 DATA DIRECTORY='/tmp/not-existing' INDEX DIRECTORY='/tmp/not-existing',SUBPARTITION sp1));
43 drop table if exists t1;
44 CREATE TABLE t1(id INT,purchased DATE)PARTITION BY RANGE(YEAR(purchased)) SUBPARTITION BY HASH(TO_DAYS(purchased)) SUBPARTITIONS 2 (PARTITION p0 VALUES LESS THAN MAXVALUE (SUBPARTITION sp0,SUBPARTITION sp1));
45 ALTER TABLE t1 ENGINE=InnoDB;
46
47 drop table t1;
48
49 drop database test;
50 create database test character set utf8mb4;
51 use test;
52
53 --enable_query_log
54 --enable_result_log
55 --enable_warnings
56
57 show create database test;