Debian Codegraph @

mysql-test/suite/storage_engine/tbl_opt_data_dir.result

raw
1 DROP TABLE IF EXISTS t1;
2 # Running CREATE TABLE .. DATA DIRECTORY = <>
3 SHOW CREATE TABLE t1;
4 Table Create Table
5 t1 CREATE TABLE `t1` (
6 `a` int(11) DEFAULT NULL,
7 `b` char(8) DEFAULT NULL
8 ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1 DATA DIRECTORY='<DATA_DIR_1>'
9 # For ALTER TABLE the option is ignored
10 # Running ALTER TABLE .. DATA DIRECTORY = <>
11 Warnings:
12 Warning 1618 <DATA DIRECTORY> option ignored
13 SHOW CREATE TABLE t1;
14 Table Create Table
15 t1 CREATE TABLE `t1` (
16 `a` int(11) DEFAULT NULL,
17 `b` char(8) DEFAULT NULL
18 ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1 DATA DIRECTORY='<DATA_DIR_1>'
19 DROP TABLE t1;