Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6.17
-
None
-
None
-
None
-
windows
Description
MariaB [dsa]> ALTER TABLE h_picrecord_wanted_xs REMOVE partitioning;
ERROR 1025 (HY000): Error on rename of '.\dsa#sql-alter-b128-189' to '.\dsa\h_picrecord_wanted_xs' (errno: 184 "Tablespace already exists")
CREATE TABLE `h_picrecord_wanted_xs` (
`ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '??',
`DEV_ID` varchar(50) NOT NULL COMMENT '??ID',
`DEV_CHNNUM` int(11) NOT NULL COMMENT '????',
`DEV_NAME` varchar(50) NOT NULL COMMENT '????',
`DEV_CHNNAME` varchar(50) NOT NULL COMMENT '????',
`CAR_NUM` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '???',
`CAR_NUMTYPE` int(11) NOT NULL COMMENT '????',
`CAR_NUMCOLOR` int(11) NOT NULL COMMENT '????',
`CAR_SPEED` int(11) NOT NULL COMMENT '??',
`CAR_TYPE` int(11) NOT NULL COMMENT '??',
`CAR_COLOR` int(11) NOT NULL COMMENT '???',
`CAR_LENGTH` int(11) DEFAULT NULL COMMENT '??',
`CAR_DIRECT` varchar(8) NOT NULL COMMENT '????',
`CAR_WAY_CODE` varchar(12) NOT NULL COMMENT '????',
`CAP_TIME` int(11) DEFAULT NULL COMMENT '????',
`CAP_DATE` datetime NOT NULL COMMENT '????',
`WAN_ORG` varchar(50) DEFAULT NULL COMMENT '????',
`OPT_ORG` varchar(50) DEFAULT NULL COMMENT '????',
`OPT_USER` varchar(50) DEFAULT NULL COMMENT '????',
`INF_NOTE` varchar(255) DEFAULT NULL COMMENT '????',
`MAX_SPEED` int(11) DEFAULT NULL COMMENT '????',
`MIN_SPEED` int(11) DEFAULT NULL COMMENT '??????',
`CAR_IMG_URL` varchar(255) DEFAULT NULL COMMENT '??????',
`CAR_IMG1_URL` varchar(255) DEFAULT NULL COMMENT '??????',
`CAR_IMG2_URL` varchar(255) DEFAULT NULL COMMENT '??????',
`CAR_IMG3_URL` varchar(255) DEFAULT NULL COMMENT '??????',
`CAR_IMG4_URL` varchar(255) DEFAULT NULL COMMENT '??????',
`CAR_IMG5_URL` varchar(255) DEFAULT NULL COMMENT '??????',
`REC_STAT` tinyint(4) DEFAULT 0 COMMENT '????',
`DEV_CHNID` varchar(50) NOT NULL COMMENT '??????',
`SAVE_FLAG` tinyint(4) DEFAULT 0 COMMENT '???????????',
`SURVEY_IMGURL` varchar(255) DEFAULT NULL COMMENT '??????',
`DC_CLEANFLAG` tinyint(4) DEFAULT 0 COMMENT 'DATACLEAN??????????????',
`SURVEY_TYPE` int(11) NOT NULL COMMENT '????',
`CAR_IMG_PLATE_LEFT` int(11) DEFAULT NULL COMMENT '?????????LEFT',
`CAR_IMG_PLATE_TOP` int(11) DEFAULT NULL COMMENT '?????????TOP',
`CAR_IMG_PLATE_RIGHT` int(11) DEFAULT NULL COMMENT '?????????RIGHT',
`CAR_IMG_PLATE_BOTTOM` int(11) DEFAULT NULL COMMENT '?????????BOTTOM',
`CAR_NUM_PIC` varchar(255) DEFAULT NULL COMMENT '?????URL',
`COMBINED_PIC_URL` varchar(255) DEFAULT NULL COMMENT '????????URL',
`VERIFY_MEMO` varchar(255) DEFAULT NULL COMMENT '????????????',
`CREATE_TIME` timestamp NOT NULL DEFAULT current_timestamp() COMMENT '????',
`SERVICE_CODE` varchar(20) NOT NULL DEFAULT '0' COMMENT '???????',
`SURVEY_ID` varchar(40) DEFAULT NULL,
`PIC_RECORD_WANTED_IDX` varchar(60) DEFAULT NULL,
`PIC_RECORD_IDX` varchar(60) DEFAULT NULL,
`CROSSROAD_ID` varchar(30) DEFAULT NULL,
`CHAN_CODE` varchar(30) DEFAULT NULL,
`DATA_SOURCE` tinyint(4) NOT NULL DEFAULT 0 COMMENT '????????0?1-?2-?3???4-????',
`CAP_DAY` date DEFAULT NULL COMMENT '????',
`CAP_DATE_UTC` bigint(20) DEFAULT NULL COMMENT '????utc',
KEY `PK_C_PICRECORD_WANTED` (`ID`),
KEY `IDX_CPW_CAP_DATE` (`CAP_DAY`,`CAP_DATE_UTC`),
KEY `IDX_CPW_COMBINE_UTC` (`CAR_NUM`,`CAP_DATE_UTC`),
KEY `IDX_CPW_CAP_DATE_UTC` (`CAP_DATE_UTC`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin COMMENT='???????'
PARTITION BY RANGE (to_days(`CAP_DAY`))
(PARTITION `P20230519` VALUES LESS THAN (739025) ENGINE = InnoDB,
PARTITION `p20230520` VALUES LESS THAN (739026) ENGINE = InnoDB,
PARTITION `p20230521` VALUES LESS THAN (739027) ENGINE = InnoDB)