1
--source include/have_falcon.inc
3
# Bug #31296: falcon does not remove associated tablespace file.
5
--echo *** Bug #31296 ***
7
# ----------------------------------------------------- #
8
# --- Initialisation --- #
9
# ----------------------------------------------------- #
10
let $engine = 'Falcon';
11
eval SET @@storage_engine = $engine;
14
DROP TABLE IF EXISTS t1;
15
--error 0,ER_NO_SUCH_TABLESPACE
16
eval DROP TABLESPACE ts1 ENGINE $engine;
19
eval CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.fts' ENGINE $engine;
21
# ----------------------------------------------------- #
23
# ----------------------------------------------------- #
24
eval DROP TABLESPACE ts1 ENGINE $engine;
25
eval CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.fts' ENGINE $engine;
27
# ----------------------------------------------------- #
29
# ----------------------------------------------------- #
30
# Check is not suitable here.
31
#SELECT count(*) FROM t1;
33
# ----------------------------------------------------- #
34
# --- Final cleanup --- #
35
# ----------------------------------------------------- #
36
eval DROP TABLESPACE ts1 ENGINE $engine;