经测试，在--03134283914-20220909-169171-20009 Pack1版本测试无问题，请尝试该语句在数据库中执行。
create table a (
"ACTIONTIME" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP(6)
NOT NULL,
"ACTIONCODE" CHAR(1) NOT NULL,
"IDENTIFIER" VARCHAR(255) NULL,
"SERIAL" DEC(16,0) NOT NULL,
"NODE" VARCHAR(64) NULL,
"NODEALIAS" VARCHAR(64) NULL,
"MANAGER" VARCHAR(64) NULL,
"AGENT" VARCHAR(64) NULL,
"ALERTGROUP" VARCHAR(255) NULL,
"ALERTKEY" VARCHAR(255) NULL,
"SEVERITY" DEC(1,0) NULL,
"SUMMARY" VARCHAR(1024) NULL,
"STATECHANGE" TIMESTAMP(0) NULL,
"FIRSTOCCURRENCE" TIMESTAMP(0) NULL,
"LASTOCCURRENCE" TIMESTAMP(0) NULL,
"INTERNALLAST" TIMESTAMP(0) NULL,
"POLL" DEC(16,0) NULL,
"TYPE" DEC(16,0) NULL,
"TALLY" DEC(16,0) NULL,
"CLASS" DEC(16,0) NULL,
"GRADE" DEC(16,0) NULL,
"LOCATION" VARCHAR(64) NULL,
"OWNERUID" DEC(16,0) NULL,
"OWNERGID" DEC(16,0) NULL,
"ACKNOWLEDGED" DEC(16,0) NULL,
"FLASH" DEC(16,0) NULL,
"EVENTID" VARCHAR(255) NULL,
"EXPIRETIME" DEC(16,0) NULL,
"PROCESSREQ" DEC(16,0) NULL,
"SUPPRESSESCL" DEC(16,0) NULL,
"CUSTOMER" VARCHAR(64) NULL,
"SERVICE" VARCHAR(64) NULL,
"PHYSICALSLOT" DEC(16,0) NULL,
"PHYSICALPORT" DEC(16,0) NULL,
"PHYSICALCARD" VARCHAR(64) NULL,
"TASKLIST" DEC(16,0) NULL,
"NMOSSERIAL" VARCHAR(64) NULL,
"NMOSOBJINST" DEC(16,0) NULL,
"NMOSCAUSETYPE" DEC(16,0) NULL,
"NMOSDOMAINNAME" VARCHAR(64) NULL,
"NMOSENTITYID" DEC(16,0) NULL,
"NMOSMANAGEDSTATUS" DEC(16,0) NULL,
"LOCALNODEALIAS" VARCHAR(64) NULL,
"LOCALPRIOBJ" VARCHAR(255) NULL,
"LOCALSECOBJ" VARCHAR(255) NULL,
"LOCALROOTOBJ" VARCHAR(255) NULL,
"REMOTENODEALIAS" VARCHAR(64) NULL,
"REMOTEPRIOBJ" VARCHAR(255) NULL,
"REMOTESECOBJ" VARCHAR(255) NULL,
"REMOTEROOTOBJ" VARCHAR(255) NULL,
"X733EVENTTYPE" DEC(16,0) NULL,
"X733PROBABLECAUSE" DEC(16,0) NULL,
"X733SPECIFICPROB" VARCHAR(64) NULL,
"X733CORRNOTIF" VARCHAR(255) NULL,
"ORIGINALSEVERITY" DEC(16,0) NULL,
"SERVERNAME" VARCHAR(64) NOT NULL,
"SERVERSERIAL" DEC(16,0) NOT NULL,
"N_TRIGGERNAME" VARCHAR(128) NULL,
"A_ARAW" VARCHAR(1500) NULL,
"N_SUMMARYCN" VARCHAR(1024) NULL,
"N_CUSTOMERSEVERITY" DEC(2,0) NULL,
"N_COMPONENT_NAME" VARCHAR(64) NULL,
"N_COMPONENT_CODE" VARCHAR(64) NULL,
"N_COMPONENTTYPE_NAME" VARCHAR(64) NULL,
"N_COMPONENTTYPE_CODE" VARCHAR(64) NULL,
"N_SUBCOMPONENT_NAME" VARCHAR(64) NULL,
"N_SUBCOMPONENT_CODE" VARCHAR(64) NULL,
"N_INSTANCEID" VARCHAR(64) NULL,
"N_INSTANCESITUATION" VARCHAR(128) NULL,
"N_INSTANCEVALUE" VARCHAR(64) NULL,
"N_ISMTHRESHOLDTALLY" DEC(2,0) NULL,
"N_ISMMONITORTYPE" DEC(2,0) NULL,
"N_ENRICH_FLAG" DEC(2,0) NULL,
"N_CLOSE_FLAG" DEC(2,0) NULL,
"N_CURRENTSTATUS" VARCHAR(64) NULL,
"N_CHANGESTATUS_TIME" TIMESTAMP(0) NULL,
"N_CHANGESTATUS_HANDLERS_NAME" VARCHAR(64) NULL,
"N_CHANGESTATUS_HANDLERS_CODE" VARCHAR(64) NULL,
"N_RECOVER_STATUS" DEC(2,0) NULL,
"N_RECOVER_TIME" TIMESTAMP(0) NULL,
"N_ACK_TIME" TIMESTAMP(0) NULL,
"N_ACK_USER_NAME" VARCHAR(64) NULL,
"N_ACK_USER_CODE" VARCHAR(64) NULL,
"N_ACK_OVERTIME" DEC(2,0) NULL,
"N_ACK_DURATION" DEC(19,0) NULL,
"N_CLOSE_TIME" TIMESTAMP(0) NULL,
"N_CLOSE_USER_NAME" VARCHAR(64) NULL,
"N_CLOSE_USER_CODE" VARCHAR(64) NULL,
"N_CLOSE_OVERTIME" DEC(2,0) NULL,
"N_CLOSE_DURATION" DEC(19,0) NULL,
"N_CLOSE_INFO" VARCHAR(256) NULL,
"N_CONTINUE_DURATION" DEC(19,0) NULL,
"N_RECOVER_TYPE" DEC(2,0) NULL,
"N_KPI_NAME" VARCHAR(128) NULL,
"N_KPI_CODE" VARCHAR(128) NULL,
"N_KPI_PATH" VARCHAR(512) NULL,
"N_DIAGNOSE_CODE" VARCHAR(128) NULL,
"N_DIAGNOSE_PARAMETER" VARCHAR(512) NULL,
"N_DIAGNOSE_CALL_CYCLE" VARCHAR(32) NULL,
"N_CI_ID" VARCHAR(32) NULL,
"N_CI_KEY" VARCHAR(128) NULL,
"N_CI_TYPE_CODE" VARCHAR(128) NULL,
"N_CI_TYPE_NAME" VARCHAR(128) NULL,
"N_LOCATION_ID" VARCHAR(64) NULL,
"N_LOCATION_PATH_NAME" VARCHAR(128) NULL,
"N_LOCATION_NAME" VARCHAR(128) NULL,
"N_ORG_BELONG_ID" VARCHAR(256) NULL,
"N_ORG_BELONG_PATH_NAME" VARCHAR(256) NULL,
"N_ORG_BELONG_NAME" VARCHAR(256) NULL,
"N_ORG_MANAGER_ID" VARCHAR(256) NULL,
"N_ORG_MANAGER_PATH_NAME" VARCHAR(256) NULL,
"N_ORG_MANAGER_NAME" VARCHAR(256) NULL,
"N_CI_ADMIN_CODE" VARCHAR(256) NULL,
"N_CI_ADMIN_INFO" VARCHAR(256) NULL,
"N_OBJ_NAME" VARCHAR(128) NULL,
"N_OBJ_USE" VARCHAR(128) NULL,
"N_APP_CODE" VARCHAR(128) NULL,
"N_APP_NAME" VARCHAR(64) NULL,
"N_NET_BIZAREA" VARCHAR(64) NULL,
"N_MAINTENANCE_STATUS" DEC(2,0) NULL,
"N_MAINTENANCE_ID" VARCHAR(128) NULL,
"N_MAINTENANCE_BTIME" TIMESTAMP(0) NULL,
"N_MAINTENANCE_ETIME" TIMESTAMP(0) NULL,
"N_MAINTENANCE_DURATION" DEC(19,0) NULL,
"N_NOTICE_FLAG" DEC(2,0) NULL,
"N_CALL_FLAG" DEC(2,0) NULL,
"N_SMS_FLAG" DEC(2,0) NULL,
"N_MAIL_FLAG" DEC(2,0) NULL,
"N_TICKET_FLAG" DEC(2,0) NULL,
"N_DESKTOP_FLAG" DEC(2,0) NULL,
"N_APP_FLAG" DEC(2,0) NULL,
"N_SITRCA_FLAG" DEC(2,0) NULL,
"N_SITRCA_SERIAL" VARCHAR(64) NULL,
"N_SITRCA_RULEID" VARCHAR(64) NULL,
"N_SITRCA_IFRCA" VARCHAR(20) NULL,
"N_EVENTSTORM" VARCHAR(64) NULL,
"N_KPI_PATH_NAME" VARCHAR(128) NULL,
"N_CI_ADMIN_ID" VARCHAR(2048) NULL,
"N_CI_APP_ADMIN_ID" VARCHAR(2048) NULL,
"N_OBJ_TYPE_CODE" VARCHAR(128) NULL,
"N_OBJ_TYPE_NAME" VARCHAR(128) NULL,
"N_OBJ_TYPE_ID" VARCHAR(128) NULL,
"N_IFEFFECTBUSINESS" VARCHAR(12) NULL,
"N_COMPUTER_ROOM_INFO" VARCHAR(128) NULL,
"N_CLOSE_INFO_ORTHER" VARCHAR(256) NULL,
"N_UNKOWN" INT NULL,
"N_WEB_FLAG" INT NULL,
"N_TICKET_CODE" VARCHAR(32) NULL,
"UP_TYPE" INT NULL,
"UPRULEID" INT NULL,
"UPRULENAME" VARCHAR(255) NULL,
"AUTO_FIX_NOTICE_ID" BIGINT NULL,
"N_CHANGESEVERITY_TIME" TIMESTAMP(0) NULL,
"N_CHANGESEVERITY_HANDLERS_CODE" VARCHAR(64) DEFAULT ''
NULL,
"N_CHANGESEVERITY_HANDLERS_NAME" VARCHAR(64) DEFAULT ''
NULL,
"AUTO_FIX_NOTICE_RULE" TEXT NULL,
"N_ALARM_CODE" VARCHAR(255) NULL,
"N_ALARM_CODE_NAME" VARCHAR(255) NULL,
"IS_IMPORTANT" INT NULL,
"N_IS_ROOT" INT NULL,
"N_TREATMENT_SCHEME_TYPE" TINYINT NULL,
"IS_WUBAO" INT NULL,
"IS_OUFA" INT NULL,
"N_CABINET_CODE" VARCHAR(64) NULL,
"N_CABINET_POSITION" VARCHAR(64) NULL,
"$DTS_TO_DAYS$TO_DAYS(ACTIONTIME)" INT as(TO_DAYS(ACTIONTIME))
NOT NULL
)PARTITION BY RANGE("$DTS_TO_DAYS$TO_DAYS(ACTIONTIME)")
(PARTITION "reporter_status_202210" VALUES LESS THAN (738825)
,PARTITION "reporter_status_202211" VALUES LESS THAN (738855)
,PARTITION "reporter_status_202212" VALUES LESS THAN (738886)
,PARTITION "reporter_status_202301" VALUES LESS THAN (738917)
,PARTITION "reporter_status_202302" VALUES LESS THAN (738945)
,PARTITION "reporter_status_202303" VALUES LESS THAN (738976)
)