1#
2# MDEV-19906 Port show_old_temporals from MySQL 5.6
3#
4TRUNCATE TABLE mariadb5312_datetime;
5SHOW CREATE TABLE mariadb5312_datetime;
6Table	Create Table
7mariadb5312_datetime	CREATE TABLE `mariadb5312_datetime` (
8  `t0` datetime /* mariadb-5.3 */ DEFAULT NULL,
9  `t1` datetime(1) /* mariadb-5.3 */ DEFAULT NULL,
10  `t2` datetime(2) /* mariadb-5.3 */ DEFAULT NULL,
11  `t3` datetime(3) /* mariadb-5.3 */ DEFAULT NULL,
12  `t4` datetime(4) /* mariadb-5.3 */ DEFAULT NULL,
13  `t5` datetime(5) /* mariadb-5.3 */ DEFAULT NULL,
14  `t6` datetime(6) /* mariadb-5.3 */ DEFAULT NULL
15) ENGINE=MyISAM DEFAULT CHARSET=latin1
16SELECT COLUMN_NAME, DATA_TYPE, COLUMN_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='mariadb5312_datetime';
17COLUMN_NAME	t0
18DATA_TYPE	datetime
19COLUMN_TYPE	datetime /* mariadb-5.3 */
20COLUMN_NAME	t1
21DATA_TYPE	datetime
22COLUMN_TYPE	datetime(1) /* mariadb-5.3 */
23COLUMN_NAME	t2
24DATA_TYPE	datetime
25COLUMN_TYPE	datetime(2) /* mariadb-5.3 */
26COLUMN_NAME	t3
27DATA_TYPE	datetime
28COLUMN_TYPE	datetime(3) /* mariadb-5.3 */
29COLUMN_NAME	t4
30DATA_TYPE	datetime
31COLUMN_TYPE	datetime(4) /* mariadb-5.3 */
32COLUMN_NAME	t5
33DATA_TYPE	datetime
34COLUMN_TYPE	datetime(5) /* mariadb-5.3 */
35COLUMN_NAME	t6
36DATA_TYPE	datetime
37COLUMN_TYPE	datetime(6) /* mariadb-5.3 */
38DESCRIBE mariadb5312_datetime;
39Field	t0
40Type	datetime /* mariadb-5.3 */
41Null	YES
42Key
43Default	NULL
44Extra
45Field	t1
46Type	datetime(1) /* mariadb-5.3 */
47Null	YES
48Key
49Default	NULL
50Extra
51Field	t2
52Type	datetime(2) /* mariadb-5.3 */
53Null	YES
54Key
55Default	NULL
56Extra
57Field	t3
58Type	datetime(3) /* mariadb-5.3 */
59Null	YES
60Key
61Default	NULL
62Extra
63Field	t4
64Type	datetime(4) /* mariadb-5.3 */
65Null	YES
66Key
67Default	NULL
68Extra
69Field	t5
70Type	datetime(5) /* mariadb-5.3 */
71Null	YES
72Key
73Default	NULL
74Extra
75Field	t6
76Type	datetime(6) /* mariadb-5.3 */
77Null	YES
78Key
79Default	NULL
80Extra
81DROP TABLE mariadb5312_datetime;
82TRUNCATE TABLE mariadb5312_timestamp;
83SHOW CREATE TABLE mariadb5312_timestamp;
84Table	Create Table
85mariadb5312_timestamp	CREATE TABLE `mariadb5312_timestamp` (
86  `t0` timestamp /* mariadb-5.3 */ NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
87  `t1` timestamp(1) /* mariadb-5.3 */ NOT NULL DEFAULT '0000-00-00 00:00:00.0',
88  `t2` timestamp(2) /* mariadb-5.3 */ NOT NULL DEFAULT '0000-00-00 00:00:00.00',
89  `t3` timestamp(3) /* mariadb-5.3 */ NOT NULL DEFAULT '0000-00-00 00:00:00.000',
90  `t4` timestamp(4) /* mariadb-5.3 */ NOT NULL DEFAULT '0000-00-00 00:00:00.0000',
91  `t5` timestamp(5) /* mariadb-5.3 */ NOT NULL DEFAULT '0000-00-00 00:00:00.00000',
92  `t6` timestamp(6) /* mariadb-5.3 */ NOT NULL DEFAULT '0000-00-00 00:00:00.000000'
93) ENGINE=MyISAM DEFAULT CHARSET=latin1
94SELECT COLUMN_NAME, DATA_TYPE, COLUMN_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='mariadb5312_timestamp';
95COLUMN_NAME	t0
96DATA_TYPE	timestamp
97COLUMN_TYPE	timestamp /* mariadb-5.3 */
98COLUMN_NAME	t1
99DATA_TYPE	timestamp
100COLUMN_TYPE	timestamp(1) /* mariadb-5.3 */
101COLUMN_NAME	t2
102DATA_TYPE	timestamp
103COLUMN_TYPE	timestamp(2) /* mariadb-5.3 */
104COLUMN_NAME	t3
105DATA_TYPE	timestamp
106COLUMN_TYPE	timestamp(3) /* mariadb-5.3 */
107COLUMN_NAME	t4
108DATA_TYPE	timestamp
109COLUMN_TYPE	timestamp(4) /* mariadb-5.3 */
110COLUMN_NAME	t5
111DATA_TYPE	timestamp
112COLUMN_TYPE	timestamp(5) /* mariadb-5.3 */
113COLUMN_NAME	t6
114DATA_TYPE	timestamp
115COLUMN_TYPE	timestamp(6) /* mariadb-5.3 */
116DESCRIBE mariadb5312_timestamp;
117Field	t0
118Type	timestamp /* mariadb-5.3 */
119Null	NO
120Key
121Default	current_timestamp()
122Extra	on update current_timestamp()
123Field	t1
124Type	timestamp(1) /* mariadb-5.3 */
125Null	NO
126Key
127Default	0000-00-00 00:00:00.0
128Extra
129Field	t2
130Type	timestamp(2) /* mariadb-5.3 */
131Null	NO
132Key
133Default	0000-00-00 00:00:00.00
134Extra
135Field	t3
136Type	timestamp(3) /* mariadb-5.3 */
137Null	NO
138Key
139Default	0000-00-00 00:00:00.000
140Extra
141Field	t4
142Type	timestamp(4) /* mariadb-5.3 */
143Null	NO
144Key
145Default	0000-00-00 00:00:00.0000
146Extra
147Field	t5
148Type	timestamp(5) /* mariadb-5.3 */
149Null	NO
150Key
151Default	0000-00-00 00:00:00.00000
152Extra
153Field	t6
154Type	timestamp(6) /* mariadb-5.3 */
155Null	NO
156Key
157Default	0000-00-00 00:00:00.000000
158Extra
159DROP TABLE mariadb5312_timestamp;
160TRUNCATE TABLE mariadb5312_time;
161SHOW CREATE TABLE mariadb5312_time;
162Table	Create Table
163mariadb5312_time	CREATE TABLE `mariadb5312_time` (
164  `t0` time /* mariadb-5.3 */ DEFAULT NULL,
165  `t1` time(1) /* mariadb-5.3 */ DEFAULT NULL,
166  `t2` time(2) /* mariadb-5.3 */ DEFAULT NULL,
167  `t3` time(3) /* mariadb-5.3 */ DEFAULT NULL,
168  `t4` time(4) /* mariadb-5.3 */ DEFAULT NULL,
169  `t5` time(5) /* mariadb-5.3 */ DEFAULT NULL,
170  `t6` time(6) /* mariadb-5.3 */ DEFAULT NULL
171) ENGINE=MyISAM DEFAULT CHARSET=latin1
172SELECT COLUMN_NAME, DATA_TYPE, COLUMN_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='mariadb5312_time';
173COLUMN_NAME	t0
174DATA_TYPE	time
175COLUMN_TYPE	time /* mariadb-5.3 */
176COLUMN_NAME	t1
177DATA_TYPE	time
178COLUMN_TYPE	time(1) /* mariadb-5.3 */
179COLUMN_NAME	t2
180DATA_TYPE	time
181COLUMN_TYPE	time(2) /* mariadb-5.3 */
182COLUMN_NAME	t3
183DATA_TYPE	time
184COLUMN_TYPE	time(3) /* mariadb-5.3 */
185COLUMN_NAME	t4
186DATA_TYPE	time
187COLUMN_TYPE	time(4) /* mariadb-5.3 */
188COLUMN_NAME	t5
189DATA_TYPE	time
190COLUMN_TYPE	time(5) /* mariadb-5.3 */
191COLUMN_NAME	t6
192DATA_TYPE	time
193COLUMN_TYPE	time(6) /* mariadb-5.3 */
194DESCRIBE mariadb5312_time;
195Field	t0
196Type	time /* mariadb-5.3 */
197Null	YES
198Key
199Default	NULL
200Extra
201Field	t1
202Type	time(1) /* mariadb-5.3 */
203Null	YES
204Key
205Default	NULL
206Extra
207Field	t2
208Type	time(2) /* mariadb-5.3 */
209Null	YES
210Key
211Default	NULL
212Extra
213Field	t3
214Type	time(3) /* mariadb-5.3 */
215Null	YES
216Key
217Default	NULL
218Extra
219Field	t4
220Type	time(4) /* mariadb-5.3 */
221Null	YES
222Key
223Default	NULL
224Extra
225Field	t5
226Type	time(5) /* mariadb-5.3 */
227Null	YES
228Key
229Default	NULL
230Extra
231Field	t6
232Type	time(6) /* mariadb-5.3 */
233Null	YES
234Key
235Default	NULL
236Extra
237DROP TABLE mariadb5312_time;
238