summaryrefslogtreecommitdiff
path: root/mysql-test/suite/tokudb.alter_table/t/frm_discover.test
blob: 36f97a1f27aa3cda9e79724f5a8e1eac944fd83f (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
# test that tokudb discover on simple tables works when there is an frm mismatch
--source include/have_tokudb.inc

--disable_warnings
DROP TABLE IF EXISTS foo, bar;
--enable_warnings

SET SESSION DEFAULT_STORAGE_ENGINE='TokuDB';

let $MYSQLD_DATADIR= `SELECT @@datadir`;

CREATE TABLE foo (id INT PRIMARY KEY);
SHOW CREATE TABLE foo;
CREATE TABLE bar LIKE foo;
SHOW CREATE TABLE bar;

ALTER TABLE foo ADD COLUMN a INT;
SHOW CREATE TABLE foo;

FLUSH TABLES;

remove_file $MYSQLD_DATADIR/test/foo.frm;
copy_file $MYSQLD_DATADIR/test/bar.frm $MYSQLD_DATADIR/test/foo.frm;

SHOW CREATE TABLE foo;

DROP TABLE foo, bar;