Debian Codegraph @

mysql-test/suite/ndbcluster/tablespace_basic.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 2M
10 ENGINE NDB;
11 CREATE TABLE t1 (
12 a int PRIMARY KEY,
13 b varchar(255)
14 ) ENGINE = NDB
15 TABLESPACE ts1
16 STORAGE DISK;
17 INSERT INTO t1 VALUES (1, "MySQL Server with NDB");
18 SELECT * FROM t1 WHERE a = 1;
19 a b
20 1 MySQL Server with NDB
21 UPDATE t1 SET b = CONCAT(b, " test") WHERE a = 1;
22 SELECT * FROM t1 WHERE a = 1;
23 a b
24 1 MySQL Server with NDB test
25 REPLACE t1 (a, b) VALUES (1, "Another layer");
26 SELECT * FROM t1 WHERE a = 12 ORDER BY a;
27 a b
28 DELETE FROM t1 WHERE a = 11;
29 SELECT COUNT(*) FROM t1;
30 COUNT(*)
31 1
32 SELECT b FROM t1 WHERE b LIKE "MySQL%";
33 b
34 DELETE FROM t1 ORDER BY b DESC;
35 DROP TABLE t1;
36 # Need to implement rename in handlerton::alter_tablespace
37 ALTER TABLESPACE ts1 RENAME TO ts2;
38 ERROR 42000: The storage engine for the table doesn't support ALTER TABLESPACE ... RENAME TO
39 ALTER TABLESPACE ts1
40 DROP DATAFILE 'ts1_datafile.dat';
41 DROP TABLESPACE ts1;
42 DROP LOGFILE GROUP lg1
43 ENGINE=NDB;