--source include/not_valgrind.inc
--source include/have_innodb_default_undo_tablespaces.inc

call mtr.add_suppression("innodb-rollback-segments");

--echo #
--echo # WL7943 Implement INFORMATION_SCHEMA.FILES
--echo #

--echo # Mysqld is initialized in this test with with:
--echo # --innodb_rollback_segments=1
--echo # --bootstrap --innodb_page_size=16k
--echo # 2 implicit and 30 explicit undo tablespaces

let $cnt = 3;
while ($cnt <= 32)
{
  let $undo_space_name = undo_$cnt;
  let $datafile = undo_$cnt.ibu;
  eval CREATE UNDO TABLESPACE $undo_space_name ADD DATAFILE '$datafile';
  inc $cnt;
}

--source suite/innodb_undo/include/i_s_files.inc

--echo # Set all explicit undo tablespaces to inacitve.
let $cnt = 3;
while ($cnt <= 32)
{
  let $undo_space_name = undo_$cnt;
  eval ALTER UNDO TABLESPACE $undo_space_name SET INACTIVE; 
  inc $cnt;
}

--echo # Wait for all explicit undo tablespaces to become empty.
let $cnt = 3;
while ($cnt <= 32)
{
  let $inactive_undo_space = undo_$cnt;
  source include/wait_until_undo_space_is_empty.inc;
  inc $cnt;
}

--echo # Drop all explicit undo tablespaces.
let $cnt = 3;
while ($cnt <= 32)
{
  let $undo_space_name = undo_$cnt;
  eval DROP UNDO TABLESPACE $undo_space_name; 
  inc $cnt;
}