Debian Codegraph @

mysql-test/suite/innodb_undo/r/undo_tablespace_win.result

raw
1 #
2 # InnoDB supports CREATE/ALTER/DROP UNDO TABLESPACE
3 #
4 SET GLOBAL innodb_fast_shutdown = 0;
5 # restart
6 #
7 # Try CREATE UNDO TABLESPACE commands that respond differently on Windows
8 #
9 # Cannot embed a newline character into windows file name
10 CREATE UNDO TABLESPACE undo_99 ADD DATAFILE 'undo_\n_99.ibu';
11 ERROR HY000: Failed to create UNDO TABLESPACE undo_99
12 SHOW WARNINGS;
13 Level Code Message
14 Error 1528 Failed to create UNDO TABLESPACE undo_99
15 Error 1030 Got error 168 - 'Unknown (generic) error from engine' from storage engine
16 # Cannot embed a CR character into windows file name
17 CREATE UNDO TABLESPACE undo_99 ADD DATAFILE 'undo_\r_99.ibu';
18 ERROR HY000: Failed to create UNDO TABLESPACE undo_99
19 SHOW WARNINGS;
20 Level Code Message
21 Error 1528 Failed to create UNDO TABLESPACE undo_99
22 Error 1030 Got error 168 - 'Unknown (generic) error from engine' from storage engine
23 # Cannot embed a tab character into a windows file name
24 CREATE UNDO TABLESPACE undo_99 ADD DATAFILE 'undo_\t_99.ibu';
25 ERROR HY000: Failed to create UNDO TABLESPACE undo_99
26 SHOW WARNINGS;
27 Level Code Message
28 Error 1528 Failed to create UNDO TABLESPACE undo_99
29 Error 1030 Got error 168 - 'Unknown (generic) error from engine' from storage engine
30 #
31 # Cleanup
32 #
33 #
34 # InnoDB Test UNDO Tablespace truncation on Windows while the tablespace
35 # file is externally opened with and without FILE_SHARE_DELETE flag.
36 #
37 CREATE TABLE t1 (id INT) ENGINE=InnoDB;
38 CREATE UNDO TABLESPACE undo_003 ADD DATAFILE 'undo_003.ibu';
39 begin;
40 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
41 INSERT INTO t1 VALUES (1);
42 ALTER UNDO TABLESPACE undo_003 SET ACTIVE;
43 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
44 INSERT INTO t1 VALUES (1);
45 ALTER UNDO TABLESPACE undo_003 SET ACTIVE;
46 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
47 INSERT INTO t1 VALUES (1);
48 ALTER UNDO TABLESPACE undo_003 SET ACTIVE;
49 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
50 INSERT INTO t1 VALUES (1);
51 ALTER UNDO TABLESPACE undo_003 SET ACTIVE;
52 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
53 INSERT INTO t1 VALUES (1);
54 ALTER UNDO TABLESPACE undo_003 SET ACTIVE;
55 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
56 INSERT INTO t1 VALUES (1);
57 ALTER UNDO TABLESPACE undo_003 SET ACTIVE;
58 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
59 INSERT INTO t1 VALUES (1);
60 ALTER UNDO TABLESPACE undo_003 SET ACTIVE;
61 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
62 INSERT INTO t1 VALUES (1);
63 ALTER UNDO TABLESPACE undo_003 SET ACTIVE;
64 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
65 INSERT INTO t1 VALUES (1);
66 ALTER UNDO TABLESPACE undo_003 SET ACTIVE;
67 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
68 INSERT INTO t1 VALUES (1);
69 ALTER UNDO TABLESPACE undo_003 SET ACTIVE;
70 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
71 ALTER UNDO TABLESPACE undo_003 SET ACTIVE;
72 begin;
73 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
74 INSERT INTO t1 VALUES (1);
75 ALTER UNDO TABLESPACE undo_003 SET ACTIVE;
76 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
77 INSERT INTO t1 VALUES (1);
78 ALTER UNDO TABLESPACE undo_003 SET ACTIVE;
79 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
80 INSERT INTO t1 VALUES (1);
81 ALTER UNDO TABLESPACE undo_003 SET ACTIVE;
82 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
83 INSERT INTO t1 VALUES (1);
84 ALTER UNDO TABLESPACE undo_003 SET ACTIVE;
85 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
86 INSERT INTO t1 VALUES (1);
87 ALTER UNDO TABLESPACE undo_003 SET ACTIVE;
88 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
89 INSERT INTO t1 VALUES (1);
90 ALTER UNDO TABLESPACE undo_003 SET ACTIVE;
91 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
92 INSERT INTO t1 VALUES (1);
93 ALTER UNDO TABLESPACE undo_003 SET ACTIVE;
94 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
95 INSERT INTO t1 VALUES (1);
96 ALTER UNDO TABLESPACE undo_003 SET ACTIVE;
97 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
98 INSERT INTO t1 VALUES (1);
99 ALTER UNDO TABLESPACE undo_003 SET ACTIVE;
100 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
101 INSERT INTO t1 VALUES (1);
102 ALTER UNDO TABLESPACE undo_003 SET ACTIVE;
103 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
104 DROP UNDO TABLESPACE undo_003;
105 DROP TABLE t1;