1drop table if exists t1;
2SET @OLD_SQL_MODE=@@SQL_MODE;
3SET SQL_MODE='IGNORE_BAD_TABLE_OPTIONS';
4create table t1 (a int fkey=vvv, key akey (a) dff=vvv) tkey1='1v1';
5Warnings:
6Warning	1911	Unknown option 'fkey'
7Warning	1911	Unknown option 'dff'
8Warning	1911	Unknown option 'tkey1'
9show create table t1;
10Table	Create Table
11t1	CREATE TABLE `t1` (
12  `a` int(11) DEFAULT NULL `fkey`=vvv,
13  KEY `akey` (`a`) `dff`=vvv
14) ENGINE=MyISAM DEFAULT CHARSET=latin1 `tkey1`='1v1'
15drop table t1;
16#reassiginig options in the same line
17create table t1 (a int fkey=vvv, key akey (a) dff=vvv) tkey1=1v1 TKEY1=DEFAULT tkey1=1v2 tkey2=2v1;
18Warnings:
19Warning	1911	Unknown option 'fkey'
20Warning	1911	Unknown option 'dff'
21Warning	1911	Unknown option 'tkey1'
22Warning	1911	Unknown option 'tkey2'
23show create table t1;
24Table	Create Table
25t1	CREATE TABLE `t1` (
26  `a` int(11) DEFAULT NULL `fkey`=vvv,
27  KEY `akey` (`a`) `dff`=vvv
28) ENGINE=MyISAM DEFAULT CHARSET=latin1 `tkey1`=1v2 `tkey2`=2v1
29#add option
30alter table t1 tkey4=4v1;
31Warnings:
32Warning	1911	Unknown option 'tkey4'
33show create table t1;
34Table	Create Table
35t1	CREATE TABLE `t1` (
36  `a` int(11) DEFAULT NULL `fkey`=vvv,
37  KEY `akey` (`a`) `dff`=vvv
38) ENGINE=MyISAM DEFAULT CHARSET=latin1 `tkey1`=1v2 `tkey2`=2v1 `tkey4`=4v1
39#remove options
40alter table t1 tkey3=DEFAULT tkey4=DEFAULT;
41Warnings:
42Warning	1911	Unknown option 'tkey3'
43Warning	1911	Unknown option 'tkey4'
44show create table t1;
45Table	Create Table
46t1	CREATE TABLE `t1` (
47  `a` int(11) DEFAULT NULL `fkey`=vvv,
48  KEY `akey` (`a`) `dff`=vvv
49) ENGINE=MyISAM DEFAULT CHARSET=latin1 `tkey1`=1v2 `tkey2`=2v1
50drop table t1;
51create table t1 (a int fkey1=v1, key akey (a) kkey1=v1) tkey1=1v1 tkey1=1v2 TKEY1=DEFAULT tkey2=2v1 tkey3=3v1;
52Warnings:
53Warning	1911	Unknown option 'fkey1'
54Warning	1911	Unknown option 'kkey1'
55Warning	1911	Unknown option 'TKEY1'
56Warning	1911	Unknown option 'tkey2'
57Warning	1911	Unknown option 'tkey3'
58show create table t1;
59Table	Create Table
60t1	CREATE TABLE `t1` (
61  `a` int(11) DEFAULT NULL `fkey1`=v1,
62  KEY `akey` (`a`) `kkey1`=v1
63) ENGINE=MyISAM DEFAULT CHARSET=latin1 `tkey2`=2v1 `tkey3`=3v1
64#change field with option with the same value
65alter table t1 change a a int `FKEY1`='v1';
66Warnings:
67Warning	1911	Unknown option 'FKEY1'
68show create table t1;
69Table	Create Table
70t1	CREATE TABLE `t1` (
71  `a` int(11) DEFAULT NULL `FKEY1`='v1',
72  KEY `akey` (`a`) `kkey1`=v1
73) ENGINE=MyISAM DEFAULT CHARSET=latin1 `tkey2`=2v1 `tkey3`=3v1
74#change field with option with a different value
75alter table t1 change a a int fkey1=v2;
76Warnings:
77Warning	1911	Unknown option 'fkey1'
78show create table t1;
79Table	Create Table
80t1	CREATE TABLE `t1` (
81  `a` int(11) DEFAULT NULL `fkey1`=v2,
82  KEY `akey` (`a`) `kkey1`=v1
83) ENGINE=MyISAM DEFAULT CHARSET=latin1 `tkey2`=2v1 `tkey3`=3v1
84#new column no options
85alter table t1 add column b int;
86show create table t1;
87Table	Create Table
88t1	CREATE TABLE `t1` (
89  `a` int(11) DEFAULT NULL `fkey1`=v2,
90  `b` int(11) DEFAULT NULL,
91  KEY `akey` (`a`) `kkey1`=v1
92) ENGINE=MyISAM DEFAULT CHARSET=latin1 `tkey2`=2v1 `tkey3`=3v1
93#new key with options
94alter table t1 add key bkey (b) kkey2=v1;
95Warnings:
96Warning	1911	Unknown option 'kkey2'
97show create table t1;
98Table	Create Table
99t1	CREATE TABLE `t1` (
100  `a` int(11) DEFAULT NULL `fkey1`=v2,
101  `b` int(11) DEFAULT NULL,
102  KEY `akey` (`a`) `kkey1`=v1,
103  KEY `bkey` (`b`) `kkey2`=v1
104) ENGINE=MyISAM DEFAULT CHARSET=latin1 `tkey2`=2v1 `tkey3`=3v1
105#new column with options
106alter table t1 add column c int fkey1=v1 fkey2=v2;
107Warnings:
108Warning	1911	Unknown option 'fkey1'
109Warning	1911	Unknown option 'fkey2'
110show create table t1;
111Table	Create Table
112t1	CREATE TABLE `t1` (
113  `a` int(11) DEFAULT NULL `fkey1`=v2,
114  `b` int(11) DEFAULT NULL,
115  `c` int(11) DEFAULT NULL `fkey1`=v1 `fkey2`=v2,
116  KEY `akey` (`a`) `kkey1`=v1,
117  KEY `bkey` (`b`) `kkey2`=v1
118) ENGINE=MyISAM DEFAULT CHARSET=latin1 `tkey2`=2v1 `tkey3`=3v1
119#new key no options
120alter table t1 add key ckey (c);
121show create table t1;
122Table	Create Table
123t1	CREATE TABLE `t1` (
124  `a` int(11) DEFAULT NULL `fkey1`=v2,
125  `b` int(11) DEFAULT NULL,
126  `c` int(11) DEFAULT NULL `fkey1`=v1 `fkey2`=v2,
127  KEY `akey` (`a`) `kkey1`=v1,
128  KEY `bkey` (`b`) `kkey2`=v1,
129  KEY `ckey` (`c`)
130) ENGINE=MyISAM DEFAULT CHARSET=latin1 `tkey2`=2v1 `tkey3`=3v1
131#drop column
132alter table t1 drop b;
133show create table t1;
134Table	Create Table
135t1	CREATE TABLE `t1` (
136  `a` int(11) DEFAULT NULL `fkey1`=v2,
137  `c` int(11) DEFAULT NULL `fkey1`=v1 `fkey2`=v2,
138  KEY `akey` (`a`) `kkey1`=v1,
139  KEY `ckey` (`c`)
140) ENGINE=MyISAM DEFAULT CHARSET=latin1 `tkey2`=2v1 `tkey3`=3v1
141#add column with options after delete
142alter table t1 add column b int fkey2=v1;
143Warnings:
144Warning	1911	Unknown option 'fkey2'
145show create table t1;
146Table	Create Table
147t1	CREATE TABLE `t1` (
148  `a` int(11) DEFAULT NULL `fkey1`=v2,
149  `c` int(11) DEFAULT NULL `fkey1`=v1 `fkey2`=v2,
150  `b` int(11) DEFAULT NULL `fkey2`=v1,
151  KEY `akey` (`a`) `kkey1`=v1,
152  KEY `ckey` (`c`)
153) ENGINE=MyISAM DEFAULT CHARSET=latin1 `tkey2`=2v1 `tkey3`=3v1
154#add key
155alter table t1 add key bkey (b) kkey2=v2;
156Warnings:
157Warning	1911	Unknown option 'kkey2'
158show create table t1;
159Table	Create Table
160t1	CREATE TABLE `t1` (
161  `a` int(11) DEFAULT NULL `fkey1`=v2,
162  `c` int(11) DEFAULT NULL `fkey1`=v1 `fkey2`=v2,
163  `b` int(11) DEFAULT NULL `fkey2`=v1,
164  KEY `akey` (`a`) `kkey1`=v1,
165  KEY `ckey` (`c`),
166  KEY `bkey` (`b`) `kkey2`=v2
167) ENGINE=MyISAM DEFAULT CHARSET=latin1 `tkey2`=2v1 `tkey3`=3v1
168drop table t1;
169create table t1 (a int) tkey1=100;
170Warnings:
171Warning	1911	Unknown option 'tkey1'
172show create table t1;
173Table	Create Table
174t1	CREATE TABLE `t1` (
175  `a` int(11) DEFAULT NULL
176) ENGINE=MyISAM DEFAULT CHARSET=latin1 `tkey1`=100
177drop table t1;
178#error on unknown option
179SET SQL_MODE='';
180create table t1 (a int fkey=vvv, key akey (a) dff=vvv) tkey1=1v1;
181ERROR HY000: Unknown option 'fkey'
182SET @@SQL_MODE=@OLD_SQL_MODE;
183