Debian Codegraph @

mysql-test/suite/x/t/explicit_undo_tablespaces.test

raw
1 # ***************************************************************
2 # Sanity checking of explicit undo tablespaces
3 # Check CREATE,ALTER and DROP undo tablespaces are working
4 # ***************************************************************
5 --source ../mysql-test/include/xplugin_preamble.inc
6
7 create user insertsqluser@localhost identified by 'insertsqluser';
8 grant all on *.* to insertsqluser@localhost;
9
10 --write_file $MYSQL_TMP_DIR/mysqlx-undo_sql.xpl
11 -->sql
12
13 DROP SCHEMA if EXISTS mysqlxplugin;
14 CREATE SCHEMA mysqlxplugin;
15 USE mysqlxplugin;
16
17 CREATE UNDO TABLESPACE undo_003 ADD DATAFILE 'undo_003.ibu';
18
19 SELECT name,space_type,state FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
20 WHERE space_type = 'Undo';
21
22 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
23
24 CREATE TABLE tab2(c1 int , c2 varchar(10)) Engine=InnoDB;
25 INSERT INTO tab2 VALUES(2, 'VISH');
26 CREATE INDEX ix1 ON tab2(c2) USING BTREE;
27
28 SELECT * FROM tab2;
29
30 -->endsql
31 EOF
32
33 --exec $MYSQLXTEST -u insertsqluser --password='insertsqluser' --file=$MYSQL_TMP_DIR/mysqlx-undo_sql.xpl 2>&1
34 --remove_file $MYSQL_TMP_DIR/mysqlx-undo_sql.xpl
35
36 # Check metadata info
37 let $inactive_undo_space = undo_003;
38 source include/wait_until_undo_space_is_empty.inc;
39
40 SELECT name,space_type,state FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
41 WHERE space_type = 'Undo';
42
43 --write_file $MYSQL_TMP_DIR/mysqlx-undo_sql.xpl
44 -->sql
45
46 USE mysqlxplugin;
47 DROP TABLE tab2;
48 DROP UNDO TABLESPACE undo_003;
49 DROP SCHEMA if EXISTS mysqlxplugin;
50 DROP USER insertsqluser@localhost;
51
52 -->endsql
53 EOF
54
55 --exec $MYSQLXTEST -u insertsqluser --password='insertsqluser' --file=$MYSQL_TMP_DIR/mysqlx-undo_sql.xpl 2>&1
56
57 # Cleanup
58 --source ../include/xplugin_cleanup.inc