← Back to branch summary

~jlukas79/+junk/mysql-server

« back to all changes in this revision

Viewing changes to mysql-test/suite/falcon/t/falcon_bug_31295.test

manual merge 6.0-main --> 6.0-bka-review

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/falcon/t/falcon_bug_31295.test
 
1
--source include/have_falcon.inc
 
2
#
 
3
# Bug #31295: NULL alter table operation causes falcon table to lose it's
 
4
#             tablespace assoc 
 
5
#
 
6
--echo *** Bug #31295 ***
 
7
 
 
8
# ----------------------------------------------------- #
 
9
# --- Initialisation                                --- #
 
10
# ----------------------------------------------------- #
 
11
let $engine = 'Falcon';
 
12
eval SET @@storage_engine = $engine;
 
13
 
 
14
--disable_warnings
 
15
DROP TABLE IF EXISTS t1;
 
16
--error 0,ER_NO_SUCH_TABLESPACE
 
17
eval DROP TABLESPACE ts1 ENGINE $engine;
 
18
--enable_warnings
 
19
 
 
20
eval CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.fts' ENGINE $engine;
 
21
CREATE TABLE t1(a int);
 
22
 
 
23
# ----------------------------------------------------- #
 
24
# --- Test                                          --- #
 
25
# ----------------------------------------------------- #
 
26
SELECT * FROM INFORMATION_SCHEMA.FALCON_TABLES WHERE TABLE_NAME='t1';
 
27
eval ALTER TABLE t1 TABLESPACE ts1 ENGINE $engine;
 
28
SELECT * FROM INFORMATION_SCHEMA.FALCON_TABLES WHERE TABLE_NAME='t1';
 
29
eval ALTER TABLE t1 ENGINE $engine;
 
30
SELECT * FROM INFORMATION_SCHEMA.FALCON_TABLES WHERE TABLE_NAME='t1';
 
31
 
 
32
 
 
33
# ----------------------------------------------------- #
 
34
# --- Check                                         --- #
 
35
# ----------------------------------------------------- #
 
36
SELECT count(*) FROM t1;
 
37
 
 
38
# ----------------------------------------------------- #
 
39
# --- Final cleanup                                 --- #
 
40
# ----------------------------------------------------- #
 
41
DROP TABLE t1;
 
42
eval DROP TABLESPACE ts1 ENGINE $engine;