summaryrefslogtreecommitdiff
path: root/storage/myisammrg/mysql-test/storage_engine/alter_tablespace.rdiff
blob: cfc821582ed13d2bf1567fe203d27a2b28c14935 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
4,18c4,13
< DROP TABLE t1;
< CREATE TABLE t1 (a <INT_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
< INSERT INTO t1 (a) VALUES (1),(2);
< SELECT * FROM t1;
< a
< 1
< 2
< ALTER TABLE t1 DISCARD TABLESPACE;
< SELECT * FROM t1;
< ERROR HY000: Got error -1 from storage engine
< ALTER TABLE t1 IMPORT TABLESPACE;
< SELECT * FROM t1;
< a
< 1
< 2
---
> ERROR HY000: 'test.t1' is not BASE TABLE
> # ERROR: Statement ended with errno 1347, errname ER_WRONG_OBJECT (expected to succeed)
> # ------------ UNEXPECTED RESULT ------------
> # [ ALTER TABLE t1 DISCARD TABLESPACE ]
> # The statement|command finished with ER_WRONG_OBJECT.
> # Tablespace operations or the mix could be unsupported|malfunctioning, or the problem was caused by previous errors. 
> # You can change the engine code, or create an rdiff, or disable the test by adding it to disabled.def.
> # Further in this test, the message might sometimes be suppressed; a part of the test might be skipped.
> # Also, this problem may cause a chain effect (more errors of different kinds in the test).
> # -------------------------------------------