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