Debian Codegraph @

mysql-test/suite/x/r/explicit_undo_tablespaces.result

raw
1 create user insertsqluser@localhost identified by 'insertsqluser';
2 grant all on *.* to insertsqluser@localhost;
3 RUN DROP SCHEMA if EXISTS mysqlxplugin
4
5 0 rows affected
6 RUN CREATE SCHEMA mysqlxplugin
7
8 1 rows affected
9 RUN USE mysqlxplugin
10
11 0 rows affected
12 RUN CREATE UNDO TABLESPACE undo_003 ADD DATAFILE 'undo_003.ibu'
13
14 0 rows affected
15 RUN SELECT name,space_type,state FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
16 WHERE space_type = 'Undo'
17 name space_type state
18 innodb_undo_001 Undo active
19 innodb_undo_002 Undo active
20 undo_003 Undo active
21 0 rows affected
22 RUN ALTER UNDO TABLESPACE undo_003 SET INACTIVE
23
24 0 rows affected
25 RUN CREATE TABLE tab2(c1 int , c2 varchar(10)) Engine=InnoDB
26
27 0 rows affected
28 RUN INSERT INTO tab2 VALUES(2, 'VISH')
29
30 1 rows affected
31 RUN CREATE INDEX ix1 ON tab2(c2) USING BTREE
32
33 0 rows affected
34 Records: 0 Duplicates: 0 Warnings: 0
35 RUN SELECT * FROM tab2
36 c1 c2
37 2 VISH
38 0 rows affected
39 Mysqlx.Ok {
40 msg: "bye!"
41 }
42 ok
43 SELECT name,space_type,state FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
44 WHERE space_type = 'Undo';
45 name space_type state
46 innodb_undo_001 Undo active
47 innodb_undo_002 Undo active
48 undo_003 Undo empty
49 RUN USE mysqlxplugin
50
51 0 rows affected
52 RUN DROP TABLE tab2
53
54 0 rows affected
55 RUN DROP UNDO TABLESPACE undo_003
56
57 0 rows affected
58 RUN DROP SCHEMA if EXISTS mysqlxplugin
59
60 0 rows affected
61 RUN DROP USER insertsqluser@localhost
62
63 0 rows affected
64 Mysqlx.Ok {
65 msg: "bye!"
66 }
67 ok