#sql-backup tables are visible upon CREATE OR REPLACE and get stuck in S3 storage

# Because it's not easy to drop the garbage tables which are the essense

# of the report, I re-create the bucket to force-remove the contents.

# This assumes that I run the test with --mysqld=--s3-bucket=mtr,

# and MinIO server is already running. Naturally it doesn't belong

# to the eventual test case for the regression suite

--exec mc alias set local http://127.0.0.1:9000 minio minioadmin

--exec mc rb --force local/mtr || true

--exec mc mb local/mtr

show tables;

# This is to clean up S3 in a "normal" situation, when there is no garbage

drop table if exists t;

--connect (con1,localhost,root,,test)

CREATE TABLE t (a INT);

ALTER TABLE t ENGINE=S3;

--send

  CREATE OR REPLACE TABLE t (b INT);

--connection default

--let $i= 100

while ($i)

{

  --let $tbl= `show tables like '%sql-backup%'`

  if ($tbl != '')

  {  

     --echo #

     --echo # Found a backup table $tbl

     --echo #

     show tables;

     --let $shutdown_timeout= 0

     --source include/restart_mysqld.inc

     --echo #

     --echo # The table is still there

     --echo #

     show tables;

     --echo #

     --echo # .. but cannot be dropped

     --echo #

     --eval drop table if exists `$tbl`

     show tables;

     --let $i= 1

  }

  --dec $i

}

# Cleanup

DROP TABLE t;

connection default;

#

# Found a backup table #sql-backup-12beea-5-t

#

show tables;

Tables_in_test

#sql-backup-12beea-5-t

t

# restart

#

# The table is still there

#

show tables;

Tables_in_test

#sql-backup-12beea-5-t

t

#

# .. but cannot be dropped

#

drop table if exists `#sql-backup-12beea-5-t`;

Warnings:

Note	1051	Unknown table 'test.#sql-backup-12beea-5-t'

show tables;

Tables_in_test

#sql-backup-12beea-5-t

t