1
--source include/have_falcon.inc
3
# Bug #31110: falcon: missing engine check while dropping tablespace
5
--echo *** Bug #31110 ***
7
# ----------------------------------------------------- #
8
# --- Initialisation --- #
9
# ----------------------------------------------------- #
10
let $engine = 'Falcon';
11
let $other_engine = 'MyISAM';
12
eval SET @@storage_engine = $engine;
15
DROP TABLE IF EXISTS t1;
16
--error 0,ER_NO_SUCH_TABLESPACE
17
eval DROP TABLESPACE ts1 ENGINE $engine;
21
# ----------------------------------------------------- #
23
# ----------------------------------------------------- #
24
--error ER_ILLEGAL_HA_CREATE_OPTION
25
eval CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.fts' ENGINE $other_engine;
27
# ----------------------------------------------------- #
29
# ----------------------------------------------------- #
30
# No check applicable here.
31
#SELECT count(*) FROM t1;
33
# ----------------------------------------------------- #
34
# --- Final cleanup --- #
35
# ----------------------------------------------------- #
36
# No cleanup necessary in this case.