Debian Codegraph @

mysql-test/suite/ndbcluster/tablespace_datafiles.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 1M
10 ENGINE NDB;
11 ALTER TABLESPACE ts1
12 ADD DATAFILE 'ts1_datafile2.dat'
13 INITIAL_SIZE = 4M;
14 SELECT file_name, file_type FROM information_schema.files
15 WHERE engine='ndbcluster' AND file_type = 'UNDO LOG';
16 FILE_NAME FILE_TYPE
17 ./lg1_undofile.dat UNDO LOG
18 SELECT file_name, file_type FROM information_schema.files
19 WHERE engine='ndbcluster' AND file_type = 'DATAFILE';
20 FILE_NAME FILE_TYPE
21 ./ts1_datafile.dat DATAFILE
22 ./ts1_datafile2.dat DATAFILE
23 ALTER TABLESPACE ts1
24 DROP DATAFILE 'ts1_datafile.dat';
25 ALTER TABLESPACE ts1
26 DROP DATAFILE 'ts1_datafile2.dat';
27 ALTER TABLESPACE ts1
28 DROP DATAFILE 'ts1_datafile2.dat';
29 ERROR HY000: Tablespace 'ts1' does not have a file named 'ts1_datafile2.dat'
30 DROP TABLESPACE ts1;
31 CREATE TABLESPACE ts1 ADD DATAFILE 'MYSQLTEST_VARDIR/tmp/t1.dat' USE LOGFILE GROUP lg1 INITIAL_SIZE 1M ENGINE NDB;
32 ERROR HY000: Failed to create TABLESPACE
33 SHOW WARNINGS;
34 Level Code Message
35 Warning 1296 Got error 1509 'File system error, check if path,permissions etc' from NDB
36 Warning 1296 Failed to commit NDB schema transaction
37 Error 1528 Failed to create TABLESPACE
38 CREATE TABLESPACE ts1
39 ADD DATAFILE 'ts1_datafile.dat'
40 USE LOGFILE GROUP lg1
41 INITIAL_SIZE 1M
42 ENGINE NDB;
43 ALTER TABLESPACE ts1
44 DROP DATAFILE 'ts1_datafile.dat';
45 DROP TABLESPACE ts1;
46 #
47 # WL#12236 - CREATE TABLESPACE without DATAFILE clause.
48 #
49 CREATE TABLESPACE ts1
50 USE LOGFILE GROUP lg1
51 INITIAL_SIZE 1M
52 ENGINE NDB;
53 ALTER TABLESPACE ts1 DROP DATAFILE 'DATAFILE_NAME';
54 DROP TABLESPACE ts1;
55 CREATE TABLESPACE ts2
56 USE LOGFILE GROUP lg1
57 INITIAL_SIZE 1M
58 ENGINE NDB;
59 ALTER TABLESPACE ts2
60 ADD DATAFILE 'data_2.dat'
61 INITIAL_SIZE 1M;
62 CREATE TABLE t2 (
63 id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
64 last_name VARCHAR(50) NOT NULL,
65 first_name VARCHAR(50) NOT NULL,
66 dob DATE NOT NULL,
67 joined DATE NOT NULL,
68 INDEX(last_name, first_name)
69 )
70 TABLESPACE ts2 STORAGE DISK
71 ENGINE NDB;
72 INSERT INTO t2 VALUES(1,'aaa','bbb','1981-02-04','2017-07-17');
73 SELECT * FROM t2;
74 id last_name first_name dob joined
75 1 aaa bbb 1981-02-04 2017-07-17
76 DROP TABLE t2;
77 ALTER TABLESPACE ts2 DROP DATAFILE 'data_2.dat';
78 ALTER TABLESPACE ts2 DROP DATAFILE 'DATAFILE_NAME';
79 DROP TABLESPACE ts2;
80 DROP LOGFILE GROUP lg1
81 ENGINE=NDB;