Debian Codegraph @

mysql-test/suite/ndb_ddl/tablespace_mdl.result

raw
1 CREATE LOGFILE GROUP lg1
2 ADD UNDOFILE 'lg1_undofile.dat'
3 INITIAL_SIZE 1M
4 UNDO_BUFFER_SIZE = 1M
5 ENGINE NDB;
6 CREATE TABLESPACE ts1
7 ADD DATAFILE 'ts1_datafile.dat'
8 USE LOGFILE GROUP lg1
9 INITIAL_SIZE 16M
10 ENGINE NDB;
11 CREATE TABLE procedure_control(
12 stop_flag INT
13 ) ENGINE NDB;
14 CREATE PROCEDURE p1()
15 BEGIN
16 DECLARE done INT DEFAULT 0;
17 REPEAT
18 CREATE TABLE t1 (
19 a INT PRIMARY KEY,
20 b VARCHAR(255)
21 )
22 ENGINE NDB TABLESPACE ts1 STORAGE DISK;
23 DROP TABLE t1;
24 SELECT stop_flag INTO done FROM procedure_control;
25 UNTIL done END REPEAT;
26 END//
27 INSERT INTO procedure_control VALUE(0);
28 Start background load of CREATE + DROP TABLE t1 which uses tablespace ts1
29 CALL p1();
30 Start CREATE + DROP TABLE t2 which uses tablespace ts1
31 UPDATE procedure_control SET stop_flag=1;
32 Wait for background load to complete
33 DROP PROCEDURE p1;
34 DROP TABLE procedure_control;
35 ALTER TABLESPACE ts1
36 DROP DATAFILE 'ts1_datafile.dat';
37 DROP TABLESPACE ts1;
38 DROP LOGFILE GROUP lg1
39 ENGINE NDB;
40 CREATE LOGFILE GROUP lg1
41 ADD UNDOFILE 'lg1_undofile.dat'
42 INITIAL_SIZE 1M
43 UNDO_BUFFER_SIZE = 1M
44 ENGINE NDB;
45 CREATE TABLESPACE ts1
46 ADD DATAFILE 'ts1_datafile.dat'
47 USE LOGFILE GROUP lg1
48 INITIAL_SIZE 16M
49 ENGINE NDB;
50 CREATE TABLE procedure_control(
51 stop_flag INT
52 ) ENGINE NDB;
53 CREATE TABLE dummy (
54 a INT PRIMARY KEY
55 ) ENGINE NDB;
56 INSERT INTO dummy VALUES (1), (2), (3), (4), (5);
57 CREATE PROCEDURE p1()
58 BEGIN
59 DECLARE done INT DEFAULT 0;
60 DECLARE dummy_var INT DEFAULT 5;
61 REPEAT
62 ALTER TABLESPACE ts1
63 ADD DATAFILE 'ts1_datafile2.dat';
64 ALTER TABLESPACE ts1
65 DROP DATAFILE 'ts1_datafile2.dat';
66 SELECT stop_flag INTO done FROM procedure_control;
67 SELECT a INTO dummy_var FROM dummy WHERE a > 4;
68 UNTIL done END REPEAT;
69 END//
70 INSERT INTO procedure_control VALUE(0);
71 Start background load of ALTER TABLESPACE ts1 ADD/DROP DATAFILE
72 CALL p1();
73 Start CREATE + DROP TABLE t1 which uses tablespace ts1
74 UPDATE procedure_control SET stop_flag=1;
75 Wait for background load to complete
76 DROP PROCEDURE p1;
77 DROP TABLE procedure_control;
78 ALTER TABLESPACE ts1
79 DROP DATAFILE 'ts1_datafile.dat';
80 DROP TABLESPACE ts1;
81 DROP LOGFILE GROUP lg1
82 ENGINE NDB;
83 CREATE LOGFILE GROUP lg1
84 ADD UNDOFILE 'lg1_undofile.dat'
85 INITIAL_SIZE 1M
86 UNDO_BUFFER_SIZE = 1M
87 ENGINE NDB;
88 CREATE TABLESPACE ts1
89 ADD DATAFILE 'ts1_datafile.dat'
90 USE LOGFILE GROUP lg1
91 INITIAL_SIZE 16M
92 ENGINE NDB;
93 CREATE TABLE procedure_control(
94 stop_flag INT
95 ) ENGINE NDB;
96 CREATE PROCEDURE p1()
97 BEGIN
98 DECLARE done INT DEFAULT 0;
99 REPEAT
100 ALTER TABLESPACE ts1
101 ADD DATAFILE 'ts1_datafile2.dat';
102 ALTER TABLESPACE ts1
103 DROP DATAFILE 'ts1_datafile2.dat';
104 SELECT stop_flag INTO done FROM procedure_control;
105 UNTIL done END REPEAT;
106 END//
107 INSERT INTO procedure_control VALUE(0);
108 Start background load of ALTER TABLESPACE ts1 ADD/DROP DATAFILE
109 CALL p1();
110 Start ALTER TABLESPACE ts1 ADD/DROP DATAFILE
111 UPDATE procedure_control SET stop_flag=1;
112 Wait for background load to complete
113 DROP PROCEDURE p1;
114 DROP TABLE procedure_control,dummy;
115 ALTER TABLESPACE ts1
116 DROP DATAFILE 'ts1_datafile.dat';
117 DROP TABLESPACE ts1;
118 DROP LOGFILE GROUP lg1
119 ENGINE NDB;