github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/ddl/mysql_ddl_3.result (about) 1 create database if not exists mysql_ddl_test_db; 2 use mysql_ddl_test_db; 3 create table mysql_ddl_test_t31(id int); 4 /*!50001 DROP VIEW IF EXISTS mysql_ddl_test_v31 */; 5 /*!50001 CREATE DEFINER = `root`@`%` VIEW mysql_ddl_test_v31 AS Select id from mysql_ddl_test_t31 */; 6 show create view mysql_ddl_test_v31; 7 View Create View character_set_client collation_connection 8 mysql_ddl_test_v31 /*!50001 CREATE DEFINER = `root`@`%` VIEW mysql_ddl_test_v31 AS Select id from mysql_ddl_test_t31 */; utf8mb4 utf8mb4_general_ci 9 DROP TABLE IF EXISTS `mysql_ddl_test_t32`; 10 CREATE TABLE `mysql_ddl_test_t32` ( 11 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键id', 12 `plt` int(11) DEFAULT '0' COMMENT '平台id', 13 `device_id` varchar(32) DEFAULT '' COMMENT '设备id', 14 `user_id` int(11) DEFAULT '0' COMMENT '用户id', 15 `home_id` int(11) DEFAULT '0' COMMENT '家庭id', 16 `type` varchar(32) DEFAULT '' COMMENT '视频类型 CRY, MOVE, VOICE, STATE, LOW_BATTERY', 17 `video_image` varchar(500) DEFAULT '' COMMENT '封面链接', 18 `video_url` varchar(1024) DEFAULT '' COMMENT '视频链接', 19 `video_start` char(12) NOT NULL DEFAULT '' COMMENT '视频开始时间戳', 20 `video_end` char(12) NOT NULL DEFAULT '' COMMENT '视频结束时间戳', 21 `status` tinyint(4) DEFAULT '0' COMMENT '0未读1已读', 22 `visible` tinyint(4) NOT NULL DEFAULT '0' COMMENT '未购买套餐不可见 0不可见1可见', 23 `create_time` char(12) NOT NULL DEFAULT '' COMMENT '创建时间戳', 24 `created_at` datetime NOT NULL COMMENT '创建时间', 25 `updated_at` datetime DEFAULT NULL COMMENT '更新时间', 26 `content` text, 27 `event_start` char(12) NOT NULL DEFAULT '' COMMENT '事件开始时间戳', 28 `event_end` char(12) NOT NULL DEFAULT '' COMMENT '事件结束时间戳', 29 `msg_id` varchar(32) NOT NULL DEFAULT '', 30 `event_id` varchar(32) NOT NULL DEFAULT '', 31 `accept` tinyint(4) NOT NULL DEFAULT '0', 32 PRIMARY KEY (`id`,`created_at`) USING BTREE, 33 KEY `device_id` (`device_id`) USING BTREE, 34 KEY `userId` (`user_id`) USING BTREE, 35 KEY `createTime` (`create_time`) USING BTREE, 36 KEY `plt_dev_user_sv_ctime` (`plt`,`status`,`visible`) USING BTREE, 37 KEY `created` (`created_at`) USING BTREE, 38 KEY `index_0` (`user_id`,`status`,`create_time`) USING BTREE 39 ) ENGINE=InnoDB AUTO_INCREMENT=2122298806 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='视频' 40 /*!50100 PARTITION BY LIST ((TO_DAYS(created_at)*24 + HOUR(created_at)) % (7*24)) 41 (PARTITION hour0 VALUES IN (0) ENGINE = InnoDB, 42 PARTITION hour1 VALUES IN (1) ENGINE = InnoDB, 43 PARTITION hour2 VALUES IN (2) ENGINE = InnoDB, 44 PARTITION hour3 VALUES IN (3) ENGINE = InnoDB, 45 PARTITION hour4 VALUES IN (4) ENGINE = InnoDB, 46 PARTITION hour5 VALUES IN (5) ENGINE = InnoDB, 47 PARTITION hour6 VALUES IN (6) ENGINE = InnoDB, 48 PARTITION hour7 VALUES IN (7) ENGINE = InnoDB, 49 PARTITION hour8 VALUES IN (8) ENGINE = InnoDB, 50 PARTITION hour9 VALUES IN (9) ENGINE = InnoDB, 51 PARTITION hour10 VALUES IN (10) ENGINE = InnoDB, 52 PARTITION hour11 VALUES IN (11) ENGINE = InnoDB, 53 PARTITION hour12 VALUES IN (12) ENGINE = InnoDB, 54 PARTITION hour13 VALUES IN (13) ENGINE = InnoDB, 55 PARTITION hour14 VALUES IN (14) ENGINE = InnoDB, 56 PARTITION hour15 VALUES IN (15) ENGINE = InnoDB, 57 PARTITION hour16 VALUES IN (16) ENGINE = InnoDB, 58 PARTITION hour17 VALUES IN (17) ENGINE = InnoDB, 59 PARTITION hour18 VALUES IN (18) ENGINE = InnoDB, 60 PARTITION hour19 VALUES IN (19) ENGINE = InnoDB, 61 PARTITION hour20 VALUES IN (20) ENGINE = InnoDB, 62 PARTITION hour21 VALUES IN (21) ENGINE = InnoDB, 63 PARTITION hour22 VALUES IN (22) ENGINE = InnoDB, 64 PARTITION hour23 VALUES IN (23) ENGINE = InnoDB, 65 PARTITION hour24 VALUES IN (24) ENGINE = InnoDB, 66 PARTITION hour25 VALUES IN (25) ENGINE = InnoDB, 67 PARTITION hour26 VALUES IN (26) ENGINE = InnoDB, 68 PARTITION hour27 VALUES IN (27) ENGINE = InnoDB, 69 PARTITION hour28 VALUES IN (28) ENGINE = InnoDB, 70 PARTITION hour29 VALUES IN (29) ENGINE = InnoDB, 71 PARTITION hour30 VALUES IN (30) ENGINE = InnoDB, 72 PARTITION hour31 VALUES IN (31) ENGINE = InnoDB, 73 PARTITION hour32 VALUES IN (32) ENGINE = InnoDB, 74 PARTITION hour33 VALUES IN (33) ENGINE = InnoDB, 75 PARTITION hour34 VALUES IN (34) ENGINE = InnoDB, 76 PARTITION hour35 VALUES IN (35) ENGINE = InnoDB, 77 PARTITION hour36 VALUES IN (36) ENGINE = InnoDB, 78 PARTITION hour37 VALUES IN (37) ENGINE = InnoDB, 79 PARTITION hour38 VALUES IN (38) ENGINE = InnoDB, 80 PARTITION hour39 VALUES IN (39) ENGINE = InnoDB, 81 PARTITION hour40 VALUES IN (40) ENGINE = InnoDB, 82 PARTITION hour41 VALUES IN (41) ENGINE = InnoDB, 83 PARTITION hour42 VALUES IN (42) ENGINE = InnoDB, 84 PARTITION hour43 VALUES IN (43) ENGINE = InnoDB, 85 PARTITION hour44 VALUES IN (44) ENGINE = InnoDB, 86 PARTITION hour45 VALUES IN (45) ENGINE = InnoDB, 87 PARTITION hour46 VALUES IN (46) ENGINE = InnoDB, 88 PARTITION hour47 VALUES IN (47) ENGINE = InnoDB, 89 PARTITION hour48 VALUES IN (48) ENGINE = InnoDB, 90 PARTITION hour49 VALUES IN (49) ENGINE = InnoDB, 91 PARTITION hour50 VALUES IN (50) ENGINE = InnoDB, 92 PARTITION hour51 VALUES IN (51) ENGINE = InnoDB, 93 PARTITION hour52 VALUES IN (52) ENGINE = InnoDB, 94 PARTITION hour53 VALUES IN (53) ENGINE = InnoDB, 95 PARTITION hour54 VALUES IN (54) ENGINE = InnoDB, 96 PARTITION hour55 VALUES IN (55) ENGINE = InnoDB, 97 PARTITION hour56 VALUES IN (56) ENGINE = InnoDB, 98 PARTITION hour57 VALUES IN (57) ENGINE = InnoDB, 99 PARTITION hour58 VALUES IN (58) ENGINE = InnoDB, 100 PARTITION hour59 VALUES IN (59) ENGINE = InnoDB, 101 PARTITION hour60 VALUES IN (60) ENGINE = InnoDB, 102 PARTITION hour61 VALUES IN (61) ENGINE = InnoDB, 103 PARTITION hour62 VALUES IN (62) ENGINE = InnoDB, 104 PARTITION hour63 VALUES IN (63) ENGINE = InnoDB, 105 PARTITION hour64 VALUES IN (64) ENGINE = InnoDB, 106 PARTITION hour65 VALUES IN (65) ENGINE = InnoDB, 107 PARTITION hour66 VALUES IN (66) ENGINE = InnoDB, 108 PARTITION hour67 VALUES IN (67) ENGINE = InnoDB, 109 PARTITION hour68 VALUES IN (68) ENGINE = InnoDB, 110 PARTITION hour69 VALUES IN (69) ENGINE = InnoDB, 111 PARTITION hour70 VALUES IN (70) ENGINE = InnoDB, 112 PARTITION hour71 VALUES IN (71) ENGINE = InnoDB, 113 PARTITION hour72 VALUES IN (72) ENGINE = InnoDB, 114 PARTITION hour73 VALUES IN (73) ENGINE = InnoDB, 115 PARTITION hour74 VALUES IN (74) ENGINE = InnoDB, 116 PARTITION hour75 VALUES IN (75) ENGINE = InnoDB, 117 PARTITION hour76 VALUES IN (76) ENGINE = InnoDB, 118 PARTITION hour77 VALUES IN (77) ENGINE = InnoDB, 119 PARTITION hour78 VALUES IN (78) ENGINE = InnoDB, 120 PARTITION hour79 VALUES IN (79) ENGINE = InnoDB, 121 PARTITION hour80 VALUES IN (80) ENGINE = InnoDB, 122 PARTITION hour81 VALUES IN (81) ENGINE = InnoDB, 123 PARTITION hour82 VALUES IN (82) ENGINE = InnoDB, 124 PARTITION hour83 VALUES IN (83) ENGINE = InnoDB, 125 PARTITION hour84 VALUES IN (84) ENGINE = InnoDB, 126 PARTITION hour85 VALUES IN (85) ENGINE = InnoDB, 127 PARTITION hour86 VALUES IN (86) ENGINE = InnoDB, 128 PARTITION hour87 VALUES IN (87) ENGINE = InnoDB, 129 PARTITION hour88 VALUES IN (88) ENGINE = InnoDB, 130 PARTITION hour89 VALUES IN (89) ENGINE = InnoDB, 131 PARTITION hour90 VALUES IN (90) ENGINE = InnoDB, 132 PARTITION hour91 VALUES IN (91) ENGINE = InnoDB, 133 PARTITION hour92 VALUES IN (92) ENGINE = InnoDB, 134 PARTITION hour93 VALUES IN (93) ENGINE = InnoDB, 135 PARTITION hour94 VALUES IN (94) ENGINE = InnoDB, 136 PARTITION hour95 VALUES IN (95) ENGINE = InnoDB, 137 PARTITION hour96 VALUES IN (96) ENGINE = InnoDB, 138 PARTITION hour97 VALUES IN (97) ENGINE = InnoDB, 139 PARTITION hour98 VALUES IN (98) ENGINE = InnoDB, 140 PARTITION hour99 VALUES IN (99) ENGINE = InnoDB, 141 PARTITION hour100 VALUES IN (100) ENGINE = InnoDB, 142 PARTITION hour101 VALUES IN (101) ENGINE = InnoDB, 143 PARTITION hour102 VALUES IN (102) ENGINE = InnoDB, 144 PARTITION hour103 VALUES IN (103) ENGINE = InnoDB, 145 PARTITION hour104 VALUES IN (104) ENGINE = InnoDB, 146 PARTITION hour105 VALUES IN (105) ENGINE = InnoDB, 147 PARTITION hour106 VALUES IN (106) ENGINE = InnoDB, 148 PARTITION hour107 VALUES IN (107) ENGINE = InnoDB, 149 PARTITION hour108 VALUES IN (108) ENGINE = InnoDB, 150 PARTITION hour109 VALUES IN (109) ENGINE = InnoDB, 151 PARTITION hour110 VALUES IN (110) ENGINE = InnoDB, 152 PARTITION hour111 VALUES IN (111) ENGINE = InnoDB, 153 PARTITION hour112 VALUES IN (112) ENGINE = InnoDB, 154 PARTITION hour113 VALUES IN (113) ENGINE = InnoDB, 155 PARTITION hour114 VALUES IN (114) ENGINE = InnoDB, 156 PARTITION hour115 VALUES IN (115) ENGINE = InnoDB, 157 PARTITION hour116 VALUES IN (116) ENGINE = InnoDB, 158 PARTITION hour117 VALUES IN (117) ENGINE = InnoDB, 159 PARTITION hour118 VALUES IN (118) ENGINE = InnoDB, 160 PARTITION hour119 VALUES IN (119) ENGINE = InnoDB, 161 PARTITION hour120 VALUES IN (120) ENGINE = InnoDB, 162 PARTITION hour121 VALUES IN (121) ENGINE = InnoDB, 163 PARTITION hour122 VALUES IN (122) ENGINE = InnoDB, 164 PARTITION hour123 VALUES IN (123) ENGINE = InnoDB, 165 PARTITION hour124 VALUES IN (124) ENGINE = InnoDB, 166 PARTITION hour125 VALUES IN (125) ENGINE = InnoDB, 167 PARTITION hour126 VALUES IN (126) ENGINE = InnoDB, 168 PARTITION hour127 VALUES IN (127) ENGINE = InnoDB, 169 PARTITION hour128 VALUES IN (128) ENGINE = InnoDB, 170 PARTITION hour129 VALUES IN (129) ENGINE = InnoDB, 171 PARTITION hour130 VALUES IN (130) ENGINE = InnoDB, 172 PARTITION hour131 VALUES IN (131) ENGINE = InnoDB, 173 PARTITION hour132 VALUES IN (132) ENGINE = InnoDB, 174 PARTITION hour133 VALUES IN (133) ENGINE = InnoDB, 175 PARTITION hour134 VALUES IN (134) ENGINE = InnoDB, 176 PARTITION hour135 VALUES IN (135) ENGINE = InnoDB, 177 PARTITION hour136 VALUES IN (136) ENGINE = InnoDB, 178 PARTITION hour137 VALUES IN (137) ENGINE = InnoDB, 179 PARTITION hour138 VALUES IN (138) ENGINE = InnoDB, 180 PARTITION hour139 VALUES IN (139) ENGINE = InnoDB, 181 PARTITION hour140 VALUES IN (140) ENGINE = InnoDB, 182 PARTITION hour141 VALUES IN (141) ENGINE = InnoDB, 183 PARTITION hour142 VALUES IN (142) ENGINE = InnoDB, 184 PARTITION hour143 VALUES IN (143) ENGINE = InnoDB, 185 PARTITION hour144 VALUES IN (144) ENGINE = InnoDB, 186 PARTITION hour145 VALUES IN (145) ENGINE = InnoDB, 187 PARTITION hour146 VALUES IN (146) ENGINE = InnoDB, 188 PARTITION hour147 VALUES IN (147) ENGINE = InnoDB, 189 PARTITION hour148 VALUES IN (148) ENGINE = InnoDB, 190 PARTITION hour149 VALUES IN (149) ENGINE = InnoDB, 191 PARTITION hour150 VALUES IN (150) ENGINE = InnoDB, 192 PARTITION hour151 VALUES IN (151) ENGINE = InnoDB, 193 PARTITION hour152 VALUES IN (152) ENGINE = InnoDB, 194 PARTITION hour153 VALUES IN (153) ENGINE = InnoDB, 195 PARTITION hour154 VALUES IN (154) ENGINE = InnoDB, 196 PARTITION hour155 VALUES IN (155) ENGINE = InnoDB, 197 PARTITION hour156 VALUES IN (156) ENGINE = InnoDB, 198 PARTITION hour157 VALUES IN (157) ENGINE = InnoDB, 199 PARTITION hour158 VALUES IN (158) ENGINE = InnoDB, 200 PARTITION hour159 VALUES IN (159) ENGINE = InnoDB, 201 PARTITION hour160 VALUES IN (160) ENGINE = InnoDB, 202 PARTITION hour161 VALUES IN (161) ENGINE = InnoDB, 203 PARTITION hour162 VALUES IN (162) ENGINE = InnoDB, 204 PARTITION hour163 VALUES IN (163) ENGINE = InnoDB, 205 PARTITION hour164 VALUES IN (164) ENGINE = InnoDB, 206 PARTITION hour165 VALUES IN (165) ENGINE = InnoDB, 207 PARTITION hour167 VALUES IN (167) ENGINE = InnoDB) */; 208 show create table mysql_ddl_test_t32; 209 Table Create Table 210 mysql_ddl_test_t32 CREATE TABLE `mysql_ddl_test_t32` (\n`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键id',\n`plt` INT DEFAULT '0' COMMENT '平台id',\n`device_id` VARCHAR(32) DEFAULT '' COMMENT '设备id',\n`user_id` INT DEFAULT '0' COMMENT '用户id',\n`home_id` INT DEFAULT '0' COMMENT '家庭id',\n`type` VARCHAR(32) DEFAULT '' COMMENT '视频类型 CRY, MOVE, VOICE, STATE, LOW_BATTERY',\n`video_image` VARCHAR(500) DEFAULT '' COMMENT '封面链接',\n`video_url` VARCHAR(1024) DEFAULT '' COMMENT '视频链接',\n`video_start` CHAR(12) DEFAULT '' COMMENT '视频开始时间戳',\n`video_end` CHAR(12) DEFAULT '' COMMENT '视频结束时间戳',\n`status` TINYINT DEFAULT '0' COMMENT '0未读1已读',\n`visible` TINYINT DEFAULT '0' COMMENT '未购买套餐不可见 0不可见1可见',\n`create_time` CHAR(12) DEFAULT '' COMMENT '创建时间戳',\n`created_at` DATETIME NOT NULL COMMENT '创建时间',\n`updated_at` DATETIME DEFAULT null COMMENT '更新时间',\n`content` TEXT DEFAULT NULL,\n`event_start` CHAR(12) DEFAULT '' COMMENT '事件开始时间戳',\n`event_end` CHAR(12) DEFAULT '' COMMENT '事件结束时间戳',\n`msg_id` VARCHAR(32) DEFAULT '',\n`event_id` VARCHAR(32) DEFAULT '',\n`accept` TINYINT DEFAULT '0',\nPRIMARY KEY (`id`,`created_at`),\nKEY `device_id` (`device_id`),\nKEY `userid` (`user_id`),\nKEY `createtime` (`create_time`),\nKEY `plt_dev_user_sv_ctime` (`plt`,`status`,`visible`),\nKEY `created` (`created_at`),\nKEY `index_0` (`user_id`,`status`,`create_time`)\n) COMMENT='视频' partition by list((to_days(created_at) * 4 + hour(created_at)) % (7 * 4)) (partition hour0 values in (0) engine = innodb, partition hour1 values in (1) engine = innodb, partition hour2 values in (2) engine = innodb, partition hour3 values in (3) engine = innodb, partition hour4 values in (4) engine = innodb, partition hour5 values in (5) engine = innodb, partition hour6 values in (6) engine = innodb, partition hour7 values in (7) engine = innodb, partition hour8 values in (8) engine = innodb, partition hour9 values in (9) engine = innodb, partition hour10 values in (10) engine = innodb, partition hour11 values in (11) engine = innodb, partition hour12 values in (12) engine = innodb, partition hour13 values in (13) engine = innodb, partition hour14 values in (14) engine = innodb, partition hour15 values in (15) engine = innodb, partition hour16 values in (16) engine = innodb, partition hour17 values in (17) engine = innodb, partition hour18 values in (18) engine = innodb, partition hour19 values in (19) engine = innodb, partition hour20 values in (20) engine = innodb, partition hour21 values in (21) engine = innodb, partition hour22 values in (22) engine = innodb, partition hour23 values in (23) engine = innodb, partition hour24 values in (24) engine = innodb, partition hour25 values in (25) engine = innodb, partition hour26 values in (26) engine = innodb, partition hour27 values in (27) engine = innodb, partition hour28 values in (28) engine = innodb, partition hour29 values in (29) engine = innodb, partition hour30 values in (30) engine = innodb, partition hour31 values in (31) engine = innodb, partition hour32 values in (32) engine = innodb, partition hour33 values in (33) engine = innodb, partition hour34 values in (34) engine = innodb, partition hour35 values in (35) engine = innodb, partition hour36 values in (36) engine = innodb, partition hour37 values in (37) engine = innodb, partition hour38 values in (38) engine = innodb, partition hour39 values in (39) engine = innodb, partition hour40 values in (40) engine = innodb, partition hour41 values in (41) engine = innodb, partition hour42 values in (42) engine = innodb, partition hour43 values in (43) engine = innodb, partition hour44 values in (44) engine = innodb, partition hour45 values in (45) engine = innodb, partition hour46 values in (46) engine = innodb, partition hour47 values in (47) engine = innodb, partition hour48 values in (48) engine = innodb, partition hour49 values in (49) engine = innodb, partition hour50 values in (50) engine = innodb, partition hour51 values in (51) engine = innodb, partition hour52 values in (52) engine = innodb, partition hour53 values in (53) engine = innodb, partition hour54 values in (54) engine = innodb, partition hour55 values in (55) engine = innodb, partition hour56 values in (56) engine = innodb, partition hour57 values in (57) engine = innodb, partition hour58 values in (58) engine = innodb, partition hour59 values in (59) engine = innodb, partition hour60 values in (60) engine = innodb, partition hour61 values in (61) engine = innodb, partition hour62 values in (62) engine = innodb, partition hour63 values in (63) engine = innodb, partition hour64 values in (64) engine = innodb, partition hour65 values in (65) engine = innodb, partition hour66 values in (66) engine = innodb, partition hour67 values in (67) engine = innodb, partition hour68 values in (68) engine = innodb, partition hour69 values in (69) engine = innodb, partition hour70 values in (70) engine = innodb, partition hour71 values in (71) engine = innodb, partition hour72 values in (72) engine = innodb, partition hour73 values in (73) engine = innodb, partition hour74 values in (74) engine = innodb, partition hour75 values in (75) engine = innodb, partition hour76 values in (76) engine = innodb, partition hour77 values in (77) engine = innodb, partition hour78 values in (78) engine = innodb, partition hour79 values in (79) engine = innodb, partition hour80 values in (80) engine = innodb, partition hour81 values in (81) engine = innodb, partition hour82 values in (82) engine = innodb, partition hour83 values in (83) engine = innodb, partition hour84 values in (84) engine = innodb, partition hour85 values in (85) engine = innodb, partition hour86 values in (86) engine = innodb, partition hour87 values in (87) engine = innodb, partition hour88 values in (88) engine = innodb, partition hour89 values in (89) engine = innodb, partition hour90 values in (90) engine = innodb, partition hour91 values in (91) engine = innodb, partition hour92 values in (92) engine = innodb, partition hour93 values in (93) engine = innodb, partition hour94 values in (94) engine = innodb, partition hour95 values in (95) engine = innodb, partition hour96 values in (96) engine = innodb, partition hour97 values in (97) engine = innodb, partition hour98 values in (98) engine = innodb, partition hour99 values in (99) engine = innodb, partition hour100 values in (100) engine = innodb, partition hour101 values in (101) engine = innodb, partition hour102 values in (102) engine = innodb, partition hour103 values in (103) engine = innodb, partition hour104 values in (104) engine = innodb, partition hour105 values in (105) engine = innodb, partition hour106 values in (106) engine = innodb, partition hour107 values in (107) engine = innodb, partition hour108 values in (108) engine = innodb, partition hour109 values in (109) engine = innodb, partition hour110 values in (110) engine = innodb, partition hour111 values in (111) engine = innodb, partition hour112 values in (112) engine = innodb, partition hour113 values in (113) engine = innodb, partition hour114 values in (114) engine = innodb, partition hour115 values in (115) engine = innodb, partition hour116 values in (116) engine = innodb, partition hour117 values in (117) engine = innodb, partition hour118 values in (118) engine = innodb, partition hour119 values in (119) engine = innodb, partition hour120 values in (120) engine = innodb, partition hour121 values in (121) engine = innodb, partition hour122 values in (122) engine = innodb, partition hour123 values in (123) engine = innodb, partition hour124 values in (124) engine = innodb, partition hour125 values in (125) engine = innodb, partition hour126 values in (126) engine = innodb, partition hour127 values in (127) engine = innodb, partition hour128 values in (128) engine = innodb, partition hour129 values in (129) engine = innodb, partition hour130 values in (130) engine = innodb, partition hour131 values in (131) engine = innodb, partition hour132 values in (132) engine = innodb, partition hour133 values in (133) engine = innodb, partition hour134 values in (134) engine = innodb, partition hour135 values in (135) engine = innodb, partition hour136 values in (136) engine = innodb, partition hour137 values in (137) engine = innodb, partition hour138 values in (138) engine = innodb, partition hour139 values in (139) engine = innodb, partition hour140 values in (140) engine = innodb, partition hour141 values in (141) engine = innodb, partition hour142 values in (142) engine = innodb, partition hour143 values in (143) engine = innodb, partition hour144 values in (144) engine = innodb, partition hour145 values in (145) engine = innodb, partition hour146 values in (146) engine = innodb, partition hour147 values in (147) engine = innodb, partition hour148 values in (148) engine = innodb, partition hour149 values in (149) engine = innodb, partition hour150 values in (150) engine = innodb, partition hour151 values in (151) engine = innodb, partition hour152 values in (152) engine = innodb, partition hour153 values in (153) engine = innodb, partition hour154 values in (154) engine = innodb, partition hour155 values in (155) engine = innodb, partition hour156 values in (156) engine = innodb, partition hour157 values in (157) engine = innodb, partition hour158 values in (158) engine = innodb, partition hour159 values in (159) engine = innodb, partition hour160 values in (160) engine = innodb, partition hour161 values in (161) engine = innodb, partition hour162 values in (162) engine = innodb, partition hour163 values in (163) engine = innodb, partition hour164 values in (164) engine = innodb, partition hour165 values in (165) engine = innodb, partition hour167 values in (167) engine = innodb) 211 CREATE TABLE mysql_ddl_test_t33 ( 212 `created_at` datetime NOT NULL COMMENT 'create time') 213 /*!50100 PARTITION BY RANGE (TO_DAYS(created_at)) 214 (PARTITION p20221109 VALUES LESS THAN (738855) ENGINE = InnoDB, 215 PARTITION p20221208 VALUES LESS THAN (738862) ENGINE = InnoDB, 216 PARTITION p20221209 VALUES LESS THAN (738863) ENGINE = InnoDB, 217 PARTITION p20221210 VALUES LESS THAN (738864) ENGINE = InnoDB, 218 PARTITION p20221211 VALUES LESS THAN (738865) ENGINE = InnoDB, 219 PARTITION p20221212 VALUES LESS THAN (738866) ENGINE = InnoDB, 220 PARTITION p20221213 VALUES LESS THAN (738867) ENGINE = InnoDB, 221 PARTITION p20221214 VALUES LESS THAN (738868) ENGINE = InnoDB) */; 222 show create table mysql_ddl_test_t33; 223 Table Create Table 224 mysql_ddl_test_t33 CREATE TABLE `mysql_ddl_test_t33` (\n`created_at` DATETIME NOT NULL COMMENT 'create time'\n) partition by range(to_days(created_at)) (partition p20221109 values less than (738855) engine = innodb, partition p20221208 values less than (738862) engine = innodb, partition p20221209 values less than (738863) engine = innodb, partition p20221210 values less than (738864) engine = innodb, partition p20221211 values less than (738865) engine = innodb, partition p20221212 values less than (738866) engine = innodb, partition p20221213 values less than (738867) engine = innodb, partition p20221214 values less than (738868) engine = innodb) 225 CREATE TABLE mysql_ddl_test_t34 ( 226 `created_at` datetime NOT NULL COMMENT 'create time') 227 PARTITION BY RANGE (TO_DAYS(created_at)) 228 (PARTITION p20221109 VALUES LESS THAN (738855) ENGINE = InnoDB, 229 PARTITION p20221208 VALUES LESS THAN (738862) ENGINE = InnoDB, 230 PARTITION p20221209 VALUES LESS THAN (738863) ENGINE = InnoDB, 231 PARTITION p20221210 VALUES LESS THAN (738864) ENGINE = InnoDB, 232 PARTITION p20221211 VALUES LESS THAN (738865) ENGINE = InnoDB, 233 PARTITION p20221212 VALUES LESS THAN (738866) ENGINE = InnoDB, 234 PARTITION p20221213 VALUES LESS THAN (738867) ENGINE = InnoDB, 235 PARTITION p20221214 VALUES LESS THAN (738868) ENGINE = InnoDB); 236 show create table mysql_ddl_test_t34; 237 Table Create Table 238 mysql_ddl_test_t34 CREATE TABLE `mysql_ddl_test_t34` (\n`created_at` DATETIME NOT NULL COMMENT 'create time'\n) partition by range(to_days(created_at)) (partition p20221109 values less than (738855) engine = innodb, partition p20221208 values less than (738862) engine = innodb, partition p20221209 values less than (738863) engine = innodb, partition p20221210 values less than (738864) engine = innodb, partition p20221211 values less than (738865) engine = innodb, partition p20221212 values less than (738866) engine = innodb, partition p20221213 values less than (738867) engine = innodb, partition p20221214 values less than (738868) engine = innodb) 239 create table mysql_ddl_test_t35 (id int, gender enum('male', 'female')); 240 show create table mysql_ddl_test_t35; 241 Table Create Table 242 mysql_ddl_test_t35 CREATE TABLE `mysql_ddl_test_t35` (\n`id` INT DEFAULT NULL,\n`gender` ENUM('male','female') DEFAULT NULL\n) 243 create table mysql_ddl_test_t36 (id int, gender enum('male', 'female') NOT NULL); 244 show create table mysql_ddl_test_t36; 245 Table Create Table 246 mysql_ddl_test_t36 CREATE TABLE `mysql_ddl_test_t36` (\n`id` INT DEFAULT NULL,\n`gender` ENUM('male','female') NOT NULL\n) 247 create table mysql_ddl_test_t37 (id int, gender enum('male', 'female') default 'male'); 248 show create table mysql_ddl_test_t37; 249 Table Create Table 250 mysql_ddl_test_t37 CREATE TABLE `mysql_ddl_test_t37` (\n`id` INT DEFAULT NULL,\n`gender` ENUM('male','female') DEFAULT 'male'\n) 251 CREATE TABLE `mysql_ddl_test_t38` (id int, gender enum('male', 'female') NOT NULL default 'male'); 252 show create table mysql_ddl_test_t38; 253 Table Create Table 254 mysql_ddl_test_t38 CREATE TABLE `mysql_ddl_test_t38` (\n`id` INT DEFAULT NULL,\n`gender` ENUM('male','female') DEFAULT 'male'\n) 255 CREATE TABLE mysql_ddl_test_t39 (id int, name varchar(50)); 256 SHOW CREATE TABLE mysql_ddl_test_t39; 257 Table Create Table 258 mysql_ddl_test_t39 CREATE TABLE `mysql_ddl_test_t39` (\n`id` INT DEFAULT NULL,\n`name` VARCHAR(50) DEFAULT NULL\n) 259 insert into mysql_ddl_test_t39 values(1,'ashley'),(2,'ben'),(3,'cindy'); 260 select * from mysql_ddl_test_t39; 261 id name 262 1 ashley 263 2 ben 264 3 cindy 265 CREATE VIEW mysql_ddl_test_v32 AS select convert(`mysql_ddl_test_t39`.`name` using utf8mb4) as converted_name from mysql_ddl_test_t39; 266 SHOW CREATE VIEW mysql_ddl_test_v32; 267 View Create View character_set_client collation_connection 268 mysql_ddl_test_v32 CREATE VIEW mysql_ddl_test_v32 AS select convert(`mysql_ddl_test_t39`.`name` using utf8mb4) as converted_name from mysql_ddl_test_t39; utf8mb4 utf8mb4_general_ci 269 select * from mysql_ddl_test_v32; 270 converted_name 271 ashley 272 ben 273 cindy 274 CREATE TABLE mysql_ddl_test_t40 (id int, score_1 decimal(15,2), score_2 numeric(15,2), score_3 numeric); 275 Insert into mysql_ddl_test_t40 values(1, '66.34', '80.32', '80.2222'); 276 Insert into mysql_ddl_test_t40 values(1, '55.34', '11.32', '1.22'); 277 Insert into mysql_ddl_test_t40 values(1, '33.34', '22.32', 'abc'); 278 invalid input: abc beyond the range, can't be converted to Decimal128(38,0). 279 select * from mysql_ddl_test_t40; 280 id score_1 score_2 score_3 281 1 66.34 80.32 80 282 1 55.34 11.32 1 283 drop database if exists mysql_ddl_test_db;