1
SET DEFAULT_STORAGE_ENGINE = 'tokudb';
4
DROP TABLE IF EXISTS foo;
6
set tokudb_disable_slow_alter=on;
18
--error ER_UNSUPPORTED_EXTENSION
19
alter table foo change a a timestamp(1);
20
--error ER_UNSUPPORTED_EXTENSION
21
alter table foo change a a timestamp(2);
22
--error ER_UNSUPPORTED_EXTENSION
23
alter table foo change a a timestamp(3);
24
--error ER_UNSUPPORTED_EXTENSION
25
alter table foo change a a timestamp(4);
26
--error ER_UNSUPPORTED_EXTENSION
27
alter table foo change a a timestamp(5);
28
--error ER_UNSUPPORTED_EXTENSION
29
alter table foo change a a timestamp(6);
31
alter table foo change b b timestamp(2);
32
show create table foo;
33
alter table foo change b b timestamp(1);
34
--error ER_UNSUPPORTED_EXTENSION
35
alter table foo change b b timestamp(3);
36
--error ER_UNSUPPORTED_EXTENSION
37
alter table foo change b b timestamp(4);
38
--error ER_UNSUPPORTED_EXTENSION
39
alter table foo change b b timestamp(5);
40
--error ER_UNSUPPORTED_EXTENSION
41
alter table foo change b b timestamp(6);
43
--error ER_UNSUPPORTED_EXTENSION
44
alter table foo change d d timestamp(2);
45
--error ER_UNSUPPORTED_EXTENSION
46
alter table foo change d d timestamp(5);
47
--error ER_UNSUPPORTED_EXTENSION
48
alter table foo change d d timestamp(6);
50
alter table foo change f f timestamp(6);
51
alter table foo change f f timestamp(5);
52
--error ER_UNSUPPORTED_EXTENSION
53
alter table foo change f f timestamp(4);
67
--error ER_UNSUPPORTED_EXTENSION
68
alter table foo change a a datetime(1);
69
--error ER_UNSUPPORTED_EXTENSION
70
alter table foo change a a datetime(2);
71
--error ER_UNSUPPORTED_EXTENSION
72
alter table foo change a a datetime(3);
73
--error ER_UNSUPPORTED_EXTENSION
74
alter table foo change a a datetime(4);
75
--error ER_UNSUPPORTED_EXTENSION
76
alter table foo change a a datetime(5);
77
--error ER_UNSUPPORTED_EXTENSION
78
alter table foo change a a datetime(6);
80
alter table foo change b b datetime(2);
81
show create table foo;
82
alter table foo change b b datetime(1);
83
--error ER_UNSUPPORTED_EXTENSION
84
alter table foo change b b datetime(3);
85
--error ER_UNSUPPORTED_EXTENSION
86
alter table foo change b b datetime(4);
87
--error ER_UNSUPPORTED_EXTENSION
88
alter table foo change b b datetime(5);
89
--error ER_UNSUPPORTED_EXTENSION
90
alter table foo change b b datetime(6);
92
--error ER_UNSUPPORTED_EXTENSION
93
alter table foo change d d datetime(2);
94
alter table foo change d d datetime(5);
95
--error ER_UNSUPPORTED_EXTENSION
96
alter table foo change d d datetime(6);
98
--error ER_UNSUPPORTED_EXTENSION
99
alter table foo change g g datetime(5);
113
--error ER_UNSUPPORTED_EXTENSION
114
alter table foo change a a time(1);
115
--error ER_UNSUPPORTED_EXTENSION
116
alter table foo change a a time(2);
117
--error ER_UNSUPPORTED_EXTENSION
118
alter table foo change a a time(3);
119
--error ER_UNSUPPORTED_EXTENSION
120
alter table foo change a a time(4);
121
--error ER_UNSUPPORTED_EXTENSION
122
alter table foo change a a time(5);
123
--error ER_UNSUPPORTED_EXTENSION
124
alter table foo change a a time(6);
126
alter table foo change b b time(2);
127
show create table foo;
128
alter table foo change b b time(1);
129
--error ER_UNSUPPORTED_EXTENSION
130
alter table foo change b b time(3);
131
--error ER_UNSUPPORTED_EXTENSION
132
alter table foo change b b time(4);
133
--error ER_UNSUPPORTED_EXTENSION
134
alter table foo change b b time(5);
135
--error ER_UNSUPPORTED_EXTENSION
136
alter table foo change b b time(6);
138
--error ER_UNSUPPORTED_EXTENSION
139
alter table foo change d d time(2);
140
alter table foo change d d time(5);
141
--error ER_UNSUPPORTED_EXTENSION
142
alter table foo change d d time(6);
144
--error ER_UNSUPPORTED_EXTENSION
145
alter table foo change g g time(5);
149
create table foo (a int, b int) engine=TokuDB;
150
insert into foo values (1,2);
151
alter table foo add column tt timestamp(3) NOT NULL Default '1981-11-01 10:11:13.123' after a;
153
alter table foo drop column tt;
155
alter table foo add column tt datetime(3) NOT NULL Default '1981-11-01 10:11:13.123' after a;
157
alter table foo drop column tt;
160
alter table foo add column tt time(3) NOT NULL Default '10:11:13.123' after a;
162
alter table foo drop column tt;