-- source include/have_ndb.inc
-- source suite/ndb/include/backup_restore_setup.inc

# Store initial counts of both detected and synchronized objects
--let $initial_detected_count = query_get_value(SHOW STATUS LIKE 'Ndb_metadata_detected_count', Value, 1)
--let $initial_synced_count = query_get_value(SHOW STATUS LIKE 'Ndb_metadata_synced_count', Value, 1)
# Turn auto sync on with a low interval so changes are detected quickly
SET @old_ndb_metadata_check = @@global.ndb_metadata_check;
SET @old_ndb_metadata_check_interval = @@global.ndb_metadata_check_interval;
SET GLOBAL ndb_metadata_check = true;
SET GLOBAL ndb_metadata_check_interval = 0;

--exec $NDB_RESTORE -b 1 -n 1 -p 1 -m -r $NDB_SAVED_BACKUPS/51_dd >> $NDB_TOOLS_OUTPUT
--exec $NDB_RESTORE -e -b 1 -n 2 -p 1 -r $NDB_SAVED_BACKUPS/51_dd >> $NDB_TOOLS_OUTPUT

--disable_query_log
call mtr.add_suppression("NDB: Table upgrade required");
call mtr.add_suppression("NDB: Table definition contains obsolete data types");
call mtr.add_suppression("NDB: Failed to migrate table");
call mtr.add_suppression("NDB: Got error '1296: Table definition contains obsolete data types");
--enable_query_log

# Wait until the following 3 object changes are detected:
# Logfile group 'lg'
# Tablespace 'ts'
# Table 'test.t1'
--let $expected_changes = 3
--let $max_wait = 30
--source wait_metadata_changes_detected.inc

# Wait until the changes detected have been synced
--let $max_wait = 30
--source wait_metadata_synced.inc

--error ER_NO_SUCH_TABLE
SHOW CREATE TABLE t1;
SHOW WARNINGS;

--exec $NDB_DROP_TABLE --no-defaults -d test t1 >> $NDB_TOOLS_OUTPUT

# Wait until the blacklist is empty
--let $max_wait = 30
--source wait_metadata_sync_blacklist_empty.inc

# Reset metadata check values
SET GLOBAL ndb_metadata_check = @old_ndb_metadata_check;
SET GLOBAL ndb_metadata_check_interval = @old_ndb_metadata_check_interval;

ALTER TABLESPACE ts
DROP DATAFILE 'datafile.dat';
DROP TABLESPACE ts;
DROP LOGFILE GROUP lg
  ENGINE NDB;
--remove_file $NDB_TOOLS_OUTPUT